# 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

- [x] Google Sheets is published for link viewing.
- [x] First row is column headers.
- [x] 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.

## Related guides

- [Import data from a file](./import-data-from-file.md)
- [Create a table](./create-model.md)
- [View table records](./view-model-records.md)