Google Sheets: Export Audience

Use this export job to populate Google Sheets with Lytics user profile and user fields.

• Integration Details
• Fields
• Configuration

• Implementation Type: Server-side.
• Implementation Technique: REST API.
• Frequency: Batch, configurable.
• Resulting data: User fields will be exported to Google Sheets.

This job utilizes Google Sheets API to create Google Sheet and write user profile fields. Once started, the job will:

1. Create a new Spreadsheet with the name Lytics {segment slug} {date}.
2. If configured, a header row with each field being exported is written.
3. For each user in to the Lytics audience, the values for the field being exported are written in the sheet row by row.
4. Once all the users are exported, the job will go to sleep for the configured amount of time.
5. On the next run, the job will create a new internal sheet in the main spreadsheet and repeat the export from step 2.

You can select any Lytics user fields to export to Google Sheets. Lytics allows you to select user fields as part of the workflow configuration described below.

Follow these steps to set up and configure an export job for Google Cloud in the Lytics platform. If you are new to creating jobs in Lytics, see the Jobs Dashboard documentation for more information.

1. Select Google Drive from the list of providers.
2. Select the export Google Sheets Export Audience from the list.
3. Select the Authorization you would like to use or create a new one.
4. Enter a Label to identify this job you are creating in Lytics.
5. (Optional) Enter a Description for further context on your job.
6. Select the audience to export.
7. Complete the configuration steps for your job.
8. (Optional) From the Fields to Export input, select the list of user fields to export. If none are selected then every user field will be included.
9. (Optional) Select the Include Headers checkbox to include the field names as the first row in the Google Sheets.
10. (Optional) Select the Audience Slug checkbox to add a column with the slug of the exported Lytics audience.
11. (Optional) Select the Continuous Export checkbox to continuously run the export job at the specified frequency.
12. (Optional) From the File Export Frequency input, select how often to export the new file.
13. (Optional) From the Time of Day input, select time of day to start export job each day.
14. (Optional) From the Timezone input, select timezone for time of the day for running the export job.
15. Click the Start job button to start the job.