Skip to content
MSO CloudDocumentation

Connect Google Sheets

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.
Google Cloud ConsoleService account → Keys→ download JSON keyOne account serves GA4,Search Console and Sheets1Share the spreadsheetShare → add the service-account email as ViewerUnshared sheet: Test is green,rows come back empty2Thêm kết nối mới · Google SheetsBảng tính · SpreadsheetsNhãn hiển thị · Display labelHR workbookThương hiệu · BrandAcmeService Account JSON{ "client_email": "...@...iam.gserviceaccount.com" }ID bảng tính · Spreadsheet ID (between /d/ and /edit)1AbCdEfGhIjKlMnOpQrStUvWxYz01234567893Phân loại dữ liệu · Data classificationOrganization data (1st party)Third-party data (3rd party)Tần suất đồng bộ · Sync frequency15 minutesTab → data stream bindings · one row per tab (max 20)Marketing org: add rows here. Dataset org: save, then bind tabs (right).TestCreate4Marketing tab · binding rowon the connection formTab / range (A1)Ad Spend!A1:HData streamAd spendColumn mapping templateNo template+ Add bindingFirst row of the range is the header.5Dataset tab binderon the saved connector cardDataset sourceExisting datasetCreate from this tabDataset keyheadcount_monthlyRead the tabreads the header row and samples the tabProposed fields · tick the fields to keep and the ones that identify a rowColumnFieldKeepPart of the keyThangmonth (date)Phong bandepartmentSo nhan suheadcount (number)Ghi chunoteTime fieldmonthConfirm the schemaMap columns to fields · Source row id column: none (key columns are joined)Bind the tab to the datasetNext sync writes one record per row.6
Top left: the two Google-side steps. Bottom left: the Google Sheets connection form. Right: a marketing tab binding row and the dataset tab binder.

Steps#

  1. In Google Cloud Console create the service account and download its JSON key, unless you have one.
  2. Share the spreadsheet with the service account's email as Viewer.
  3. 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).
  4. Select Test, then Create.
  5. 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.
  6. 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.
  7. 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_email or private_key Download a fresh JSON key and paste the whole file.