How to import from Google Sheets?

The Data import wizard supports a one-time load from a public Google Sheets spreadsheet. Data is not synced automatically — after import, Google changes require a new import.

When you need this

  • Your directory already lives in Google Sheets.
  • The team updates the sheet in Google and you need a one-time copy in Custom Data.
  • You have a sheet URL but no local CSV/Excel.

Key terms

  • Google Sheets — source on Choose import source.
  • The spreadsheet must be shared: Anyone with the link → Viewer.
  • Select sheet — when the file has multiple tabs.
  • Next steps match file import: Where to import, Mapping, Write mode, Preview before import.

Before you start

  • Google Sheets is published for link viewing.
  • First row is column headers.
  • You have the spreadsheet URL.

Step-by-step

  1. Open Data import in Custom Data.
  2. On Choose import source:
    • Select Google Sheets.
    • Paste the URL (Paste Google Sheets URL).
    • Wait for Loading sheets… and pick Select sheet.
  3. Complete Where to import, Match file columns to model fields, Write mode (for existing tables).
  4. On Preview before import, review rows and confirm Import {count} records.
  5. On Import result, click View data.

What happens next

Data from the chosen sheet is written to the Custom Data table. Later Google edits do not appear until you run a new import.

How to verify

  • Import completed with no access errors.
  • Row count matches the sheet (minus empty or invalid rows).
  • If Cannot access this spreadsheet — check Google share settings.