Our platform enables you to quickly and easily connect your data sources to data from a Google Spreadsheet. This enables a one-way synchronization to occur - where any changes in the Google Spreadsheet are downloaded into your data source on a regular basis. Your data source will be automatically updated in this way 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 here: https://support.google.com/drive/answer/37603
To set up a Google Spreadsheet connector for your data source, follow the steps below.
- Go to Connected Data -> Data Sources
- In the list of available data sources, 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.
- In the Settings page, mid way down you should see a Connector heading.
- Underneath it says something like "Use a Connector to automatically load rows directly from other systems." To the right of the heading is an add connector link. Click this link and you will see a new window with the selection of connectors to choose from. Click on the Google Spreadsheet option.
- The page should refresh with your newly-added connector:
- Using Connection: Choose the connection to use. This is relevant if multiple Google connections are set up in Connections.
- Spreadsheet Name: Type the folder path and filename/extension of the file containing the data to be synced. Omit the top-level Shared Drive directory and include only subfolders (if any), plus the file name and extension (if applicable).
- Refresh Frequency: Choose the frequency at which the data in the data source will be synced with the data in the hosted file on Google Drive. The maximum frequency is 15 minutes.
- Shared/Team Drive ID: Enter the unique identifier of the Shared Drive on Google if the file being synced exists in a Shared Drive. To retrieve the ID, go to your Google Drive in a web browser and navigate to the top-level Shared Drive folder (even if the destination folder is a subfolder within the Shared Drive). Next, check the address bar of your web browser and copy the characters which follow the “/folders/” part of the URL. E.g., if the URL is https://drive.google.com/drive/folders/1234567890ABCDEFGHI, then the drive ID is 1234567890ABCDEFGHI.
Note that this applies only to an entire Google Shared Drive, not just a single file or folder. Shared Drives are currently available to G Suite Business accounts.
Once all the above details have been entered, click "SAVE" in the upper-right corner of the page. Once the page has refreshed, on the Google Spreadsheet Connector click "Run Now." Wait a moment and then click "View Logs" to verify a successful sync. Once the initial sync has completed, the connector will operate at the specified frequency.
When you save your changes, the connector will be fired for the first time and after that will run at the interval you specified in the connector settings. Wait a minute or so and then check the Rows page for your data source. You should see the rows have been downloaded from the Google Spreadsheet. If rows are not downloaded, then 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.
If at any point the hosted file is removed or anything else should interrupt a scheduled sync, the dashboard will try several times to sync again before eventually reporting an error. At this point, the automatic sync will end. A connection must be re-established by again clicking "Sync Now"; if this manual sync is successful, automatic syncing will resume.