Google Sheets as a destination

1. Add your Google Sheets access

In the Destinations tab, click on the “Add destination” button located on the top right of your screen. Then, select the Google Sheets option from the list of connectors.
Click Next and you’ll be prompted to add your access:

First, inform the spreadsheet ID
Then, make sure you grant ‘Editor’ permission on your spreadsheet for the provided email
If you have one, inform the Tab Name where you want your data to be placed. If you let it blank, a new tab will be created for the data.

The next step is letting us know which data you want to send to the spreadsheet. Select the layer and then the desired table.

Tip: The table can be found more easily by typing its name.

Describe your destination for easy identification within your organization. You can inform things like what data it brings, to which team it belongs, etc.
To define your Trigger, consider how often you want data to be extracted from this source. This decision usually depends on how frequently you need the new table data updated (every day, once a week, only at specific times, etc.).
Click Done.

Once completed, you’ll receive confirmation that your new destination is set up!
You can view your new destination on the Destinations page. Now, for you to be able to see it on your Spreadsheet, you have to wait for the pipeline to run. You can monitor it on the Destinations page to see its execution and completion. If needed, manually trigger the pipeline by clicking on the refresh icon. Once executed, your data should be seen on the Spreadsheet.

If you encounter any issues, reach out to us via Slack, and we’ll gladly assist you!