CREATE A GOOGLE SHEETS DATASTREAM
- In the Connect Element, click "+Add Datastream".
- Select Google Sheets from the list of Datastreams.
- Select an existing Google Sheets Connection, or create a new one:
- Input the authorization credentials required to access the Google Sheets Datasource.
- Configure the Datastream (see Configuration Options below).
CONFIGURATION OPTIONS
- Workspace:
The Workspace in which you want this Datastream to reside. - Connection:
The Connection authorized to access your Google Sheets account. - Export Type:
The file format you want your Data Extract to use.
- CSV
Standard Comma Separated Value file. - Excel
.xlsx - HTML
A zipped HTML File. - Raw
File will retain whatever format it had in the Google Sheets Datasource.
- CSV
- Keep Filename:
Data extract will be named as per the Datasource Google Sheet. - File ID:
ThespreadsheetId
value as per your Google Sheet's API. It can be seen in the Google Drive URL after the "id=".
e.g.https://drive.google.com/open?id=1FR6FugVEqGayK2kf9d0ePsHYEol2GavV
.
For more information on identifying your spreadsheetID, please see Google's Documentation.
Schema Mapping
For a full explanation of Schema Mapping, please see this article.
ADVANCED SETTINGS
Please see our dedicated article on Advanced Settings.
TRANSFER
Please see our dedicated article on Transfer Settings.
Comments
0 comments
Article is closed for comments.