Overview
This guide walks you through connecting your Sona Audiences to Google Sheets for automated syncs. By completing this setup, your sheets will update in real time with Sona insights, enabling live dashboards, custom reporting, and effortless data exports.
Prerequisites
A Google Sheets account must be connected to Sona.
Access to Sona Audiences data.
Step 1: connect Google Sheets to Sona
Go to Connectors in the Sona sidebar.
Locate or add the Google Sheets Connector.
Authenticate and ensure the status reads Active.
Step 2: create a new destination
Navigate to the Destinations section.
Click + Add Destination.
Select Google Sheets from the list.
Step 3: Google Sheets-specific configuration
Spreadsheet ID: enter the ID from your target Google Sheet's URL.
Sheet Name: specify the exact sheet name, for example
CustomerData.Data Range: set the starting and ending range, for example A3 to AO.
Sync Time Options: check Incremental Sync to only send new rows, use Filters to limit the data sent (optional), and select a preferred sync time if needed.
Enable Real-Time Processing: located under Sync Settings, check this box if you want immediate data updates. When enabled, real-time processing will override the scheduled sync frequency, ideal for time-sensitive workflows and immediate lead follow-up.
For general destination configuration steps, such as selecting a Sona audience, setting sync frequency, record matching, field mapping, sync settings, and saving, follow the instructions in the Data: Destination Setup guide.
Google Sheets notes
The Spreadsheet ID is the string between
/d/and/editin your Sheet URL.Ensure the Google Sheet has proper headers starting in the row you are syncing to.
The sync will overwrite cells within the defined range unless using Incremental Sync.
Best practices
Use clear destination names like "Monthly Metrics: Google Sheets".
Use a dedicated worksheet for each audience to keep your Sheets clean and organized.
Enable Incremental Sync when you want to append new rows rather than replace old data.
If syncing frequently, choose a wide range, such as A3:AZ1000, to avoid data clipping.
Confirm field mappings align with your sheet's structure to prevent data misalignment.
FAQs
Where do I find my Spreadsheet ID?
Where do I find my Spreadsheet ID?
The Spreadsheet ID is the string between /d/ and /edit in your Google Sheet's URL. Copy that string into the Spreadsheet ID field when configuring the destination.
What does Incremental Sync do?
What does Incremental Sync do?
Incremental Sync sends only new rows to your sheet instead of overwriting the entire defined range on every sync. Without it enabled, the sync overwrites cells within the data range each time it runs.
Why should I use a wide Data Range?
Why should I use a wide Data Range?
If you sync frequently, choosing a wide range, such as A3:AZ1000, helps avoid data clipping as your row count grows. Make sure your Google Sheet has proper headers starting in the row you are syncing to, so mapped fields land in the right columns.