How can I export data from CDP 365 to Google Sheets?

I. Create a new Google Sheets destination

Navigate to the Destination menu and click Create.

After that, select an account that owns the new destination.

Find the 'Destination Export Google Sheets' connector and click Select to open the configuration interface.

Enter your destination name (e.g., 'GG Sheet Destination 1') and click Authenticate to connect to your Google account.

Next, click Authenticate at 3rd Party Authentication section.

The system will open a new tab. Click the Google Sheets icon to allow CDP 365 to connect to your Google account.

Select an account you want to connect to.

Click Continue to allow Google to share your name, email address, language preference, and profile picture with CDP 365.

Click Continue to confirm the services that CDP 365 will have access to.

Choose the sheet you want to receive data from CDP 365 and click OK to complete the connection process.

Finally, click Save to confirm the creation of the new destination.

II. Creat a new dataflow

Go to the Batch Stream menu and click Create.

Select an account that is assigned the owner role for the new dataflow. The source list below will update based on the account you selected. Choose a data source that contains data and click Create stream to enter the settings interface.

Set up the schedule for your dataflow to run automatically.

At 'Add data' node:

[1]: select fields you want to access
[2]: filter your data by adding conditions

After the 'Add Data' node, use a 'Destination Channel' node. If you want to export data to Google Sheets, select the Google Sheet destination you created earlier.

At 'Destination channel' node:

Sheet_id: select a sheet which will contains your data
Mode: including Append and Overwrite. Select Append mode if you want the new data to be added after the last row of the selected sheet. Choose Overwrite mode to delete or replace the existing data in the selected sheet
Owner: display the owner of the Google Sheet document