What is needed to configure an integration?
In order to synchronize a Google Sheets document, it is required:
- A valid Google Sheets document id. Not the full document URL, but the chunk that represents the id of the document.
- A valid Google account, which must have -at least- read access to the document. An OAuth process must be completed for that account in Datagran in order to continue.
- A specific format in the sheets that the integration should grab data from:
- The data must start from cell A1.
- Column names should avoid spaces.
- The first row's cells must consist of field names.
- The next rows must have data, which will be iterated through until the end of the sheet.
- Typically, the layout of the content will look quite rectangular. Only text will be imported from the cell's contents.
Is there any limitation on databases and data types?
As long as the cells' contents are text, this integration type will do its best on guessing the data type for each column to import. Most of the times the fields to import become textual, mostly related to having several different types, in the cells, being inferred.
How does the stream replication work?
Only one mode is supported: "Full Table".
"Full Table" completely wipes out any data in our platform the stream previously downloaded, and then the whole data from the stream's source sheet is dumped into our platform.
How can these integration be managed?
Google Sheets integrations provide the ability for self-management. This means: integrations can be configured (this includes connectivity parameters and adding more source streams), re-scheduled, and launched on demand.
How to prep Google Sheets data