Creating a Google Sheet Export

To start, navigate to the project you wish to create the export in. Once there, select the 'Exports' tab in the top bar.

From here, press the "New Export" button.Enter a name for the source and select the type "Google Sheet", then press continue in the bottom right of the popup.

You will then be redirected to the export configuration page. Which consists of three different sections that must be completed.

The first section is where you select the source or query that you would like to export.

In the second section, you must select the columns you would like to export. Leaving this section blank will result in all columns being included.

After selecting the columns, you have the option to apply filters to further limit the date that will be exported.

In the third section, you must input the name of the spreadsheet where the data will be exported. The service account must have editor permissions to the spreadsheet, and the sheet cannot exceed the size limit shown in the configuration.

Finally, the name for the worksheet must be given. If there is no worksheet by that name, then one will be created within the spreadsheet. Activating the wildcard feature will allow every export to create a new worksheet with a timestamp attached.

Once the configuration has been completed, press the 'Save' button in the bottom right and your export will be ready to run.