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
Amanda Groves avatar
Written by Amanda Groves
Updated over a week ago

Google Sheets serves as a goldilocks data source for companies that aren't quite ready to connect their CRM, but are tired of maintaining stale CSVs in Crossbeam.

Getting started is super easy and only requires a few steps. Let's get into it!

In this article:

More of a visual learner? Watch our quick tutorial below!


Prepare your Google Sheets for syncing with Crossbeam

To ensure your Google Sheet syncs properly, please title your Google Sheet with a unique name. Each column in your Google Sheet must be also uniquely named. For example, you cannot have two columns labeled "website".

✍️ Note

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

Include the following columns in your sheet:

  • Company Name

  • Company URL

  • Email

    • This column is not required, but can help produce better account matches in Crossbeam if included

Adding AE Data to Google Sheets

If you would like your Account Executive information to display in Crossbeam and Slack Search, provide Account Executive Data columns in your Google Sheet and toggle the optional Map Account Executive Columns button.

If you want Account Executive Data to be mapped in Crossbeam, you will need to add a column for Account Executive Email (Account Executive Name and Account Executive Phone are optional columns).


❗️Important

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



Google Authentication

In order to connect Google Sheets to Crossbeam, you will first need to authenticate this connection.

We suggest connecting as a team, and deputizing your Crossbeam account admin as your Google authenticator to maintain clear ownership and accountability. Follow the steps below to authenticate!

  1. Navigate to your Data Sources page by clicking on your avatar in the top right corner of the page

  2. Click on the Google Sheets tile

  3. Click Authenticate with Google

  4. Select which Google account you want to authenticate


    ❗️Important

    Only one user can authenticate this connection within a single organization. Any Google Sheet you wish to bring into Crossbeam must be shared with the user who authenticated the connection to your organization's Google Workspace.




  5. Authentication should happen super quickly! Once complete, you'll be ready to start syncing your sheets


✍️Note
For special circumstances where you need assistance with your Google Authentication, please reach out to your IT team with the following instructions:

  1. Log into admin.google.com with an account with sufficient privileges such as Super Admin

  2. Click 'Security' on the left

  3. Click 'API Controls'

  4. Click 'Manage Third-Party App Access'

  5. Click 'Configure New App'

  6. Select 'Oauth App Name or Client ID'

  7. Enter 'Crossbeam' and click Search

  8. Hover over 'Crossbeam' in the search results and click 'Select'

  9. Check the box 'Oauth Client ID' to select all client ID's

  10. Check 'Trusted: Can access all Google services' (please note the scopes for this app are only Google Drive, this does not grant access to all of your Google services to Crossbeam)

  11. Click 'Configure'



Syncing your Google Sheet

Now that your connection is authenticated, you can select sheets to upload!

  1. Navigate to your user avatar in the top right corner and select Data Sources

  2. Click Add next to your Google Sheets connection

  3. Copy your unique Google Sheet URL and add it to Crossbeam within the "Google Sheet URL" section

  4. Select the individual tab within your sheet that you would like to use

  5. Identify the data type you'd like to map with: Companies or People

  6. Click Next to map your columns

  7. Once you've mapped your columns, your Google Sheet is ready to go! Click Add Google Sheet to start the sync

Nice job! Your Google Sheet is now synced and ready to use within Crossbeam! Depending on how much data is included in your sheet, the initial sync may take a few moments to complete.


Managing your Google Sheets

Once your Google Sheets connection is in place, you can manage your sheets via the Data Sources Page. Click on the small arrow to display all of your uploaded sheets and their status.

Manually sync your data as needed by clicking on "Sync Now"

To adjust your update frequency, open Settings by hovering over the three dots next to the connection.


Select how often you would like Crossbeam to check for new data from the drop down menu. From the Settings menu, you can also delete this data source and view authentication information.


Frequently Asked Questions

What are the typical/example upstream data sources that can create a Google Sheet for your Crossbeam data replication?
The best example is data from a CRM! Do we support your CRM? Do you not have permission to connect to your production CRM? Export your data, import it into a Google Sheet, and you're ready to go. Even better, set up an automated workflow (Zapier, Workato) to add any new accounts into a Google sheet to keep your CRM and Google Sheets in sync.

Will you be able to 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?