Export data to Google Sheet

Sync your model profiles and attributes into a Google Sheet to enable personalization and rapid data retrieval in your apps and websites.

Overview

This destination service allows DinMo to update existing sheets in a Google Sheet, based on your DinMo models or segments.

To use this service, follow these three steps:

1. Create a Google Drive destination. Follow our step-by-step guide to establish this connection.

2. Create your DinMo model or segment representing the data you want to send to your Google Sheet.

3. Activate your model or segment with the Google Drive destination to start synchronization.

Every time the activation runs, DinMo will overwrite the sheet and populate it with all the rows in the query results.

Google spreadsheets are limited to 10 million cells. As a consequence, activations will fail if the limit is reached.

Activation Setup

Once the Google Drive destination is configured, create an activation to begin syncing your data. To do so, go to the Activations tab and click on "New activation".

You will be asked to choose the model or segment you want to send to your Google Sheet and select the destination you've just created

The, you can configure your activation:

• Specify the sheet in which you want to save your file, either by selecting the sheet from the drop-down list or by entering the URL.

DinMo does not currently support the creation of a new sheet in a Google Sheet.

The name of your selected sheet cannot contain a colon ":", as it may create a bug in Google Sheet API calls.

• Map all the DinMo attributes that you want to include in your file. You can of course rename any column you're syncing by specifying your "custom attribute name".

The example above shows how to export the age, name, phone_number and boolean is_active.

These columns are mapped as age, last name , phone and is_active , which will correspond to the headers in the Google Sheet.

DinMo will ignore all other columns from your model/segment.

Scheduling

Define how frequently your data is exported to your Google Sheet.

Each time activation is launched, the sheet will be updated to contain only the people from the model or segment, with only the attributes that have been mapped.

Warnings

In this section, specify if you want to receive warning for your Google Sheet activation.

Consult the specific section to learn more about sync warnings.