Google Sheets as a Source
  • 2 Minutes to read
  • Dark
    Light

Google Sheets as a Source

  • Dark
    Light

Article Summary

Google Sheets is a cloud-based spreadsheet software developed by Google. It provides a platform for creating, editing, and collaborating on spreadsheets in real-time, offering features for data analysis, visualization, and organization, and it can be accessed through a web browser or mobile app.

API Call Limitations

All limitations for API calls are described here.

BEFORE YOU START!

Before you connect your Google Sheets and send the data to a destination, make sure the particular table is formatted correctly as the configuration of Attributes depends on it. The first row of the table should contain the names of the values in each column,  like this:
Google Sheets - first row example

How to Create a Google Sheets Data Source

  1. On the Sources page, click on the Create Source button and select the connector from the list.
  2. From the drop-down menu, choose your account.
    Didn't find your account?

    Click on Add new Account at the bottom of the drop-down and follow the on-screen prompts. You can also go to the Authorizers tab and click on Add New Service.

  3. Name your data source and select your spreadsheet and sheet.
  4. Select your metrics and attributes
  5. Configure your snapshotting preferences. Choose your sync frequency or the exact synchronization time under Show advanced settings.
  6. Preview your data by clicking on the Test Data button in the top right corner. You can adjust the date range for a more specific time frame.
  7. Click on Save and congratulations, your new data source is ready!

Troubleshooting

Data Preview Unavailable

If there is no data preview after clicking on Test Data, there might be a problem with your source configuration. The most common causes are:

  • Date range: Try a smaller date range. You can load the rest of your data afterward through our manual data load function.
  • Insufficient permissions: Please make sure your authorized account has at least admin-level permissions.
  • Invalid metrics, attributes, or breakdowns: You may not have any data for the selected metrics, attributes, or breakdowns.
  • Incompatible combination of metrics, attributes, or breakdowns: The combination you have selected cannot be queried together. Please refer to the service's documentation to view a full list of metrics that can be included in the same source.

Related Articles

Now that you have successfully created a data source, see how you can connect your data to a dashboarding app or a data storage.

Sending Data to Dashboarding Apps

Sending Data to Data Storages

Other Resources


Was this article helpful?

What's Next