Share the Google Sheets file with Maven
Share the file with Maven’s service account, then add it as a source in the client’s workspace.
Custom data integration
Keep a client’s budget plans, targets and manual mappings from Google Sheets in their Maven workspace.
What you can do with Sheets in Maven
Maven connects Google Sheets so the spreadsheets an agency already keeps for a client, such as budget plans, targets and manual mappings, sit in the client’s workspace next to their ad, analytics and CRM data. Share the sheet with Maven’s service account, and each sync takes a fresh copy of the tab.
Connection and sync
You connect Google Sheets by sharing the file with Maven’s service account, so no personal sign-in is stored. Each Google Sheets sync takes a fresh copy of the current records, so the workspace always reflects what is in Google Sheets now.
Snapshot of a spreadsheet tab.
Fields: row number, sheet name, spreadsheet title
How it works
No sign-in to store. Share the file with Maven’s service account and add it as a source.
Share the file with Maven’s service account, then add it as a source in the client’s workspace.
Maven takes a fresh copy of the shared Google Sheets data on each sync and keeps it with the rest of the client’s sources.
Budget plans, targets and manual mappings sit in the same workspace as the client’s ad, analytics and CRM data.
Works well with
FAQ
Not yet. Google Sheets doesn’t have modeled metrics in Maven yet, so it isn’t available for metric answers, report templates or alerts until it does. The synced records stay in the client’s workspace.
Maven refreshes Google Sheets on a schedule after the source is connected, and shows each source’s last sync time in the client’s workspace, so you can check the data is current before a report goes out.
Yes. Maven encrypts integration credentials and tokens, scopes access to the workspace, and uses the connection only to sync the reporting data needed for governed analytics.
Set up your first client, build their report by asking Claude or ChatGPT, and publish it to their portal.
Nothing is charged unless you subscribe.