Our platform enables you to quickly and easily connect your data sources to data from a Google Spreadsheet. Through a one-way synchronization, all changes made to the Google Spreadsheet are downloaded into your data source on a regular basis. This will continuously happen until you remove the connector, or an error occurs, such as losing authorization to access the Spreadsheet.
Note: Google Spreadsheets currently have a limit of 2,000,000 cells per spreadsheet and our platform currently supports a maximum of 50,000 rows. If your data source is beyond this limit, you will need to consider an alternative connector approach.
For more information refer to Google's help center click this link.
To set up a Google Spreadsheet connector for your data source, follow the steps below.
1. Using the navigation menu on the left side go to Connected Data, and select Data Sources from the drop down.
2. A list of available data sources will appear. Hover your mouse over the listing of the data source you wish to connect. A set of options will show, click on the 'settings' link.
3. In the Settings page, you will see a heading titled 'Connector'. To the right of the heading is an + ADD CONNECTOR button. Click on this link. A new window will appear with a selection of connectors to choose from. Click on the Google Spreadsheet option.
The page should refresh with your newly added connector. You will need to specify the name of your spreadsheet as it appears on your Google account. Please pay attention to the notes on the Google Spreadsheet connector. You must set the security settings on your spreadsheet as outlined in order for it to be connected successfully.
When you save your changes, the connector will be fired for the first time. After that it will run at the interval you specified in the connector settings. Wait a minute or so and then go back to the rows page for your data source. You should see the rows have been downloaded from the Google Spreadsheet.
If rows are not downloaded, there may be an error with the Spreadsheet's data or in accessing the spreadsheet. You can check this by clicking on the Error Logs button shown next to your connector on the Settings page.