Connector Google Spreadsheet

Google ~~Spreadsheet~~Sheets ~~Connector~~is ~~allows~~a ~~you~~cloud-based spreadsheet application developed by Google, offering users a versatile platform for creating, editing, and sharing spreadsheets in real-time. With its integration capabilities and compatibility with various third-party tools, users can automate data exportation from Google Sheets to ~~use~~CDPs, ~~Google~~ensuring ~~Spreadsheet files as a data source for the~~seamless data flow.

Features

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.

Requirements

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 Out

Data In	N/A
Data Out	CSV file in `in/tables` folder.

Read more: about the folder structure here.

Authorization

After creating the Google Spreadsheet connector, you will first need to authorize it to access your Google account.

Click on the Authorize button and allow Meiro.io to access the chosen Google account. You can reset your authorization at any time or if you want to authorize another Google account instead.

Parameters

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 to `contact_name`. will be replaced with `_` `#` will be replaced with `count` `/[^A-Za-z0-9_\s]/[\n\r]/` will be removed.