Skip to main content
Row and cell limitsDue to inherent limitations of Google Sheets, this destination is capped at 400,000 rows or 10 million cells for the entire spreadsheet (across all tabs). Any transfer that would write more rows to a given sheet fails. For larger datasets, use a different destination instead.

Step 1: Create a new Google Sheet and share with the generated Service Account

  1. Navigate to the your Google Drive or the Google Sheets homepage and create a new Google Sheet in a folder of your choice.
  2. In the Google Sheet menu, click Share in the top right corner, and enter the Service Account email address generated in the destination onboarding form. Grant the Service Account Editor permission, and click Send.

Step 2: Add your destination

Test your connection and save the destination to complete the connection. During the initial sync, data tables will be loaded as individual tabs, and refreshed at the designated frequency.

FAQ

The integration uses a dedicated service account to access your spreadsheet. You grant access by sharing the specific Google Sheet (or a restricted folder) with the generated service account email. Access is controlled by Google Drive sharing permissions — no personal credentials are required — and you can revoke it at any time by removing the service account from the share.