Using Components: Google Sheets Destination

Use the Google Sheets destination component to write data from your Integrate.io ETL pipeline into a Google Sheets spreadsheet.

The destination component is configured in Step 02 of the component editor.

Select the spreadsheet to write to. The dropdown lists all spreadsheets that have been shared with the service account. Use the search field to filter by name.

Select the sheet (tab) within the spreadsheet to write to. You have two options:

• Select existing sheet — Choose a sheet from the dropdown. The dropdown is populated automatically after a spreadsheet is selected.
• Create new sheet — Type a new sheet name in the text field. If the typed name does not match any existing sheet, a 'Create' option will appear in the dropdown. Click it to confirm. The connector will create the sheet tab automatically when the job runs. If a sheet with the same name already exists, the connector will write to the existing sheet.

Select how records are written to the sheet on each pipeline run:

• Append — New rows are added after the last row of existing data. Existing data is preserved. This is the default.
• Overwrite — All existing data in the sheet is cleared before writing. Only the new data from the current job run will remain.

The Column Mappings section (Step 03) allows you to map fields from the upstream pipeline to columns in the Google Sheets spreadsheet.

For each mapping, configure:

• Google Sheets API quotas: Google applies rate limits to the Sheets API. For large datasets, consider using a database or cloud storage destination instead. See Google Sheets API usage limits for details.
• Cell limit: Google Sheets has a maximum of 10 million cells per spreadsheet. Jobs that exceed this limit will fail.