Connector Google Spreadsheet

Google Spreadsheet Connector allows you to use Google Spreadsheet files as a data source for the 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 

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  contact_name. 

 will be replaced with _

# will be replaced with count

/[^A-Za-z0-9_\s]/[\n\r]/ will be removed.