Google Sheets
Keep adtribute data in a self-updating Google Sheet.
Set up
Section titled “Set up”You must be an Admin or Editor. A destination is one spreadsheet; an action is one tab.
- In Activation, click Add Action, then Create New Destination.
- Enter a Name and a Description. The spreadsheet is named “adtribute - Name”.
- Under Type, select Google Sheets, then click Next.
- Enter a Name for the tab and a Description.
- Under Dimensions, select at least one. You get one row per combination of values, summed over the Time Range. For one row per day, add Date.
- Under Attribution Models, select at least one for attributed metrics. (Conversion) credits the conversion day, (Click) the click day.
- Under Metrics or Fields, select at least one. Custom metrics are under Fields.
- Under Sync Type, select Full Replace or Incremental.
- Set the Time Range: Dynamic or Fixed.
- Optional: Under Filter, limit the data.
- Click Add Action.
The tab stays empty until its first update. For another tab, click Add Action and select this destination.
Open the spreadsheet
Section titled “Open the spreadsheet”In Activation, click the action, then the arrow next to the spreadsheet’s link. Sign in to Google with your adtribute email.
Admins and Editors get edit access; other roles get none. A renamed tab stops updating.
Time Range and updates
Section titled “Time Range and updates”| Time Range | Days in the tab | Updates |
|---|---|---|
| Dynamic, Include Today checked | Last X Days, including today | Every 30 minutes |
| Dynamic, Include Today unchecked | Last X Days before today | Overnight |
| Fixed, End Date Today | Start Date to today | Every 30 minutes |
| Fixed, End Date Custom Date | Start Date to End Date | Overnight |
Days follow your organization’s timezone.
Sync Type
Section titled “Sync Type”| Full Replace | Incremental | |
|---|---|---|
| Each update | Rewrites the tab | Adds rows with new dimension values |
| Existing rows | Show the newest numbers | Keep their numbers |
| Use it for | Reports and scheduled automations | Automations that start on a new row |
Keep your own formulas and charts in another tab. Full Replace clears what you type into the action’s tab.
Change or stop an action
Section titled “Change or stop an action”You cannot edit a saved action or destination. For other settings, add an action.
To stop an action and delete its tab:
- In Activation, click the action.
- Click … at the top of the sidebar, then Delete, and confirm.
To delete the spreadsheet, delete its destination the same way under Destinations.
Can I pause an action? No. Delete it and add it again later.
How do I get weekly or monthly totals? Add Date and sum the days in another tab.
How do I export my whole history? Use Fixed: your first day of data as Start Date, Today as End Date.
The spreadsheet hits a limit or times out. Google allows 20 million cells per spreadsheet. Delete the action and add one with fewer dimensions, a shorter Time Range or a new destination.
There is no destination for my CRM or webhook. Let your automation tool read the spreadsheet, or use the MCP.
How do I bring spreadsheet data into adtribute? See custom channels or custom events.