Connector Google Spreadsheet
Google Spreadsheet Connector allows you to use Google Spreadsheet files as a data source for the data flow.
It is possible to use more than one sheet (in one or more Google Spreadsheet files) as a data source. However, they all need to belong to one Google account.
You need a Google account and a spreadsheet on your Google Drive which you are planning to use as a data source. Irrespective of the access permission that the file has, the file can be accessed if your Google account is authorized.
Data In/ Data Out
CSV file in
Read more: about the folder structure here.
After creating the Google Spreadsheet connector, you will first need to authorize it to access your Google account.
File ID (Required)
The File ID is a unique identifier of the file on Google Drive.
Sheet ID (Required)
The Sheet ID is a unique identifier of the sheet of a spreadsheet you wish to use as a data source.
Output Filename (Optional)
The output filename will be entered if defined in this field. Otherwise, a name will follow the logic <FILE_ID>_<SHEET_ID>.
Enabled (True/ False)
Enable or disable a connection to that particular sheet you have defined above.
Header Sanitize (True/ False)
Enable or disable the header to be sanitized. If enabled header will be cleansed from special symbols e.g.
contact /name% to
/[^A-Za-z0-9_\s]/[\n\r]/ will be removed.