ePrivacy and GPDR Cookie Consent by Cookie Consent Skip to main content

Connector Google Spreadsheet

Google Sheets is a 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 CDPs, ensuring seamless 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 

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

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. 

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.




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.