Google Sheets

🚧

Google Sheets Destination Limitations

Due to inherent limitations of Google Sheets, this destination is capped at 400,000 rows (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.

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.