Google Sheets

CREATE A GOOGLE SHEETS DATASTREAM

1. In the Connect Element, click "+Add Datastream".
2. Select Google Sheets from the list of Datastreams.
3. Select an existing Google Sheets Connection, or create a new one:
   • Input the authorization credentials required to access the Google Sheets Datasource.
4. 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.
• Keep Filename:
  Data extract will be named as per the Datasource Google Sheet.
  
• File ID:
  The spreadsheetId 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.