Skip to main content

How to Use Google Sheets as a Data Source

Easily map, manage, and dynamically update your data from Google Sheets to begin account mapping with your partners

Joy Rudnick avatar
Written by Joy Rudnick
Updated this week


In this article:

How to Prepare and Sync your Google Sheet

Google Sheet Requirements

Before you connect a Google Sheet to Crossbeam, make sure it meets these requirements:

  • Crossbeam does not support XLSX files (Excel format) uploaded to Google Drive.

    • If you see a green .XLSX label next to the file name, it will not work. Convert it to Google Sheets format first.

  • Your Google Sheet must have:

    • A unique name

    • Unique headers for each column

      • For example, do not use Website as a header for multiple columns

    • Required columns:

      • Company Name

      • Company URL

    • Optional for Account Owner Mapping:

      • Account Owner Email (required for account owner mapping)

      • Account Owner Name (optional)

      • Account Owner Phone (optional)


✍️Note

Rows with identical values in the Company Name and the Company Website columns will be flagged as duplicates and skipped.

Once you've mapped these required columns in Crossbeam, do not change them or your sync will return an error.


Google Authentication

Only one user per org can authenticate, and they must use a Google Workspace email.

To connect Google Sheets:

  • Click on Data from the navigation menu, select Data Sources from the dropdown

  • Locate the Google Sheets tile and click on it

  • Click Authenticate with Google

  • Choose an organizational Google account (not a personal Gmail)

Make sure:

  • That same user has access to every Google Sheet your team wants to connect

  • Your team admin should ideally complete the authentication to ensure consistency and ownership


💡 Having authentication trouble?

Reach out to your IT team with the following instructions:

  • Log into admin.google.com using an account with sufficient privileges, such as Super Admin

  • Navigate to:

    • Security > API Controls > Manage Third-Party App Access

    • Click Configure New App > OAuth App Name or Client ID

  • In the search field, type Crossbeam and click Search

  • From the search results:

    • Hover over Crossbeam and click Select

  • On the next screen:

    • Under Select OAuth Client IDs, check the box for all listed IDs

    • Under Select Access Level, choose:

      • Trusted: Can access all Google services

  • Click Configure to apply the policy


✍️Note

Crossbeam only requests access to Google Drive to sync and read Sheets. Crossbeam does not gain access to any other Google Workspace services.


Add & Map Google Sheets

After authenticating:

  • Navigate to Data Sources

  • Click Add next to your Google Sheets connection

  • Paste the Google Sheet URL and select the sheet tab from the dropdown

  • Choose your Data Type:

    • Companies or

    • People

  • Map the columns for Company Name (Required)

    • For Companies: map Company Name and Company Website

    • For People: map Email

Click Add Google Sheet to complete the setup.


Optional: Map Account Owner Data

If your sheet includes account owner details, you can map those fields in Crossbeam.

To do this:

  • In the Data Sources list, locate your connected Google Sheet

  • Click the settings gear icon next to the sheet

  • Select Map Account Owner

  • Map the following fields:

    • Account Owner Email (required)

    • Account Owner Name (optional)

    • Account Owner Phone (optional)

  • Click Apply to save the mapping


Manage Connected Sheets

Once your sheets are connected, you can manage them from Data Sources.

On the Google Sheets row:

  • Click Add to a Google Sheet

  • Click Sync Now to manually refresh

  • Click the Settings gear icon to:

    • Adjust sync frequency

    • Reauthorize the connection

    • Remove the data source

    • View Connection Details

Click on the small arrow to the right of the data source name to display all of your uploaded sheets and their status. ​

  • Click the Settings gear icon to:

  • Check Connection

  • Add Field Mapping: Map Account Owner

  • Adjust Sharing Presets

  • Remove data source

Click Save when done.


Frequently Asked Questions

What are common sources for the data in these sheets?
Most often, data comes from a CRM. If your CRM isn’t supported, or you lack permission to connect it, export the data to Google Sheets and connect that instead. For ongoing sync, use tools like Zapier or Workato to automate it.

Can I collaborate with partners using Google Sheets?
Sure! Any columns that are outside of the columns you're collaborating with your partner on, will be pulled into Crossbeam and viewable in reports (and shareable) as “Account information”.

How do you authenticate with Google Sheets from Crossbeam?
We authenticate with your Google account so we can view your sheets. Any sheet you want to include in Crossbeam must have a unique name and be shared with the person that authenticated Google in Crossbeam.

Did this answer your question?