- 2 Minutes to read
- DarkLight
Google Sheets as a Source
- 2 Minutes to read
- DarkLight
Automatic Data Synchronization
The Dataddo Google Sheets Connector gives you the ability to sync your data automatically in hourly, daily, weekly, or monthly increments.
API Call Limitations
All limitations for API calls are described here. Before you connect your Google Sheet 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:
How to Create a Google Sheets Data Source
Sign in to your Dataddo account and click on Sources at the top of the page.
Click on Create Source in the top right corner.
From the connector from the list of sources. You can type the name of the connector into the search bar to find it faster.
From the drop-down menu, choose your Account connected to Dataddo, Spreadsheet, and Sheet. Click on Next to continue with the setup.
Didn't find your account?
If you want to connect a new account that is not on the list, click on Add New Account at the bottom of the drop-down. You will be redirected to the authorization/sign-in page to confirm the right account. Once you confirm, you will be redirected back to the Dataddo app.Authorize your account
If you have not authorized your Account with Dataddo, click on Add new Account and you will be redirected to the authorization/sign-in page.After you log in and give Dataddo the necessary permissions to access your data, you will be redirected back to the connector.
Choose a Name for your Data Source, and select the Attributes. To continue to the next page, click Next.
Configure your snapshotting preferences by choosing your Sync type, Sync frequency, Time, and Timezone.
Before saving the source, you can see a preview of your data by clicking on the Preview button. You can adjust the date range to a more specific view.
Also, you can see the full list of the metrics you selected by clicking on Show all Metrics and attributes, in the left navigation.Broken View / Error Message
If you cannot see a preview of your data, go back a few steps and check your setup. The most common causes are:
- Date range - we recommend a smaller date range. If you need to load historical data, check our guide.
- Invalid metrics, attributes or breakdowns, or their combination - you may not have any values for them.
Click on Save and your new Data Source is ready.
Congratulations, your new Data Source is ready!
Feel free to contact us and we will help you with the setup. To speed the process of resolving your issue, make sure you provide us with sufficient information.