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:
Create a Google Drive destination. Follow our step-by-step guide to establish this connection.
Create your DinMo model or segment representing the data you want to send to your Google Sheet.
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.
The name of your selected sheet cannot contain a colon ":", as it may create a bug in Google Sheet API calls.
Indicate the type of run you would like to do, based on the result you would like to see in your sheet.
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.
Run Types and Sync Modes
When configuring your sync, you will be asked to choose the Run Type and the Sync Mode.
For Google Sheet activations, here are the available options:
FULL ONLY
Every sync processes all records from the source and exports a complete file.
When Google Drive must always contain a full extract, and incremental updates are not required.
No delta logic
Every sync rebuilds the full export
FULL THEN DELTA
The first sync exports all records. All following syncs export only changed records, based on DinMo’s delta detection logic.
When exporting large datasets frequently and wanting to reduce file size or processing time.
Sync 1 → Full export
Next syncs → Only changed records (new, updated).
⚠️ Deleted records are not highlighted
Sync modes determine how data is synchronized between your data source and destination. They control whether to insert new records, update existing ones, or both, and how to handle the synchronization process.
For Google Drive, here are the available options:
SNAPSHOT
Generates a full snapshot file containing all records at each sync.
Useful for backups or systems expecting full “point-in-time” extracts.
Always exports the full segment / model
No incremental logic
UPSERT
Writes all incoming (updated or new) records into the exported file.
Ideal when you want Google Drive to always contain an up-to-date extract of the latest data, without managing incremental files.
New records → included in the exported file
Existing records → included if, and only if, there are updated values
Deleted records → simply not present in the file
In a nutshell:
Full Only + Snapshot will overwrite the whole sheet every time with every row in the segment.
Full then Delta + Upsert will do a first full run, then every next run will clear and re-write the modified rows, potentially inserting new rows.
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.
Last updated