On this page
Each tab of a shared spreadsheet becomes one synced source read on the connector's schedule; nobody re-uploads the file.
Who can do this: an owner or admin.
Before you start#
- The organization has at least one brand.
- A Google service account, or the means to create one (Shared Google service account).
- Marketing tabs (ad spend, budget plan) bind on the connection form; organization datasets (people, finance, warehouse) bind on the saved connector.
Steps#
- In Google Cloud Console create the service account and download its JSON key, unless you have one.
- Share the spreadsheet with the service account's email as Viewer.
- Open Connectors ("Kết nối"), select Add connector, pick Google Sheets and enter the label, brand, Service Account JSON, Spreadsheet ID and data classification (third-party for a vendor's market sheet).
- Select Test, then Create.
- Marketing tab: add a binding row with the tab or range (
Ad Spend!A1:H, header in the first row), the data stream and, for non-canonical columns, a mapping template; up to 20 rows. - Organization dataset: on the saved connector open the tab binder and pick Existing dataset (its fields must already be confirmed) or Create from this tab, then select Read the tab. Only Create from this tab shows Proposed fields: tick the fields to keep and the key fields, choose the time field and select Confirm the schema. Then map the columns and select Bind the tab to the dataset.
- After the first sync, check the card shows a last-sync time. A third-party sheet is badged 3rd party and stays out of first-party totals.
If it fails#
| Symptom | Cause | Fix |
|---|---|---|
| Test is green but no rows come back | The spreadsheet was not shared with the service account | Share it as Viewer, then run a manual sync. |
| "The tab has no header row" | The range points at the wrong tab or below the header | Correct the range to Tab name!A1:. or pick the tab from the list. |
| "This dataset has no confirmed field yet" | The dataset's schema was never confirmed | Create the dataset from this tab and confirm its schema, or pick a dataset that already has one. |
| Numbers appear but are shifted by one period | The wrong column was chosen as the time field | Read the tab again, choose the correct time field, confirm again. |
| Invalid service-account JSON | The pasted key lacks client_ or private_ |
Download a fresh JSON key and paste the whole file. |