Skip to main content
Google Sheets Destination LimitationsDue 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 attempting to write more rows to a given sheet will fail. For such cases, we recommend using a different destination instead.
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 provided to you. Grant the Service Account Editor permission, and click Send.
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 identity 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 user credentials are required) and can be revoked at any time by removing the service account from the share.