# Sync a table from Google Sheets

> Keep a table in step with a Google Sheet: it refreshes every hour, adds new rows, updates changed ones and removes deleted ones.

Source: https://artavolo.com/page/sync-google-sheets

A synced table follows a tab of a Google Sheet. The people who keep the sheet go on working in Google Sheets, and the base has the same rows as a table: to link to from your other tables, to show in a view, a form or an interface, and to start automations from. Every hour Artavolo reads the sheet again and brings the table in line with it.

![A table called Clients synced from a Google Sheet, with the fields Client, Plan, Seats, Renewal and Active and seven records](https://artavolo.com/site/templates/default/assets/img/help/synced-table.webp)

## 1. Share the sheet

1. In Google Sheets, open the tab you want to sync.
2. Click **Share**. Under **General access** choose **Anyone with the link**, with the role **Viewer**, and click **Done**.
3. Copy the address from your browser's address bar. It ends with `#gid=` and a number, which names the tab. A link without it syncs the first tab.

## 2. Sync it into the base

1. Open the base, click its name at the top left and choose **Synced tables**. Only the owners of a base see it.
2. Pick **Google Sheets**, paste the sheet's address and, if you like, type a name for the table.
3. Click **Sync this table**. The base opens again with the new table among its tables.

![The Synced tables window: the Clients table synced from Google Sheets with 7 records, synced just now, Sync now and Stop syncing, and below it Sync a new table with tabs for Google Sheets, Jira and Salesforce](https://artavolo.com/site/templates/default/assets/img/help/synced-tables-panel.webp)

## How the sheet becomes a table

- The first row names the fields. Each column becomes a field with the column's name.
- Field types are worked out from what the column holds: numbers (with as many decimals as the sheet shows), dates written as `2026-11-30`, `TRUE` and `FALSE` as a checkbox, long text, and text for the rest.
- When the first column names every row once, such as a client's name or an order number, it is each record's key: a row keeps its record when rows are sorted or added above it. Otherwise each row is matched by its place in the sheet, so put a column of unique names or numbers first.
- Up to 20,000 rows. Empty rows are left out.

## Keeping in step

- Every hour the table is brought in line with the sheet: new rows are added, changed ones updated, and rows deleted from the sheet go to the table's trash. **Synced tables**, **Sync now** does it straight away.
- A column added to the sheet later becomes a new field. A column removed from it stays as a field with the last values it had; delete the field if you do not need it.
- The synced table is read only in Artavolo, so nothing typed here is overwritten by the next sync. Change the rows in Google Sheets.
- **Stop syncing** keeps the table and its records as they are, and makes it an ordinary table you change in Artavolo.
- If a sync fails, for example because the sheet is no longer shared, **Synced tables** says why next to the table, and the table keeps the records it had.

## Good to know

- "Anyone with the link" means exactly that: anyone who has the sheet's address can read it. Do not sync a sheet with personal or confidential data this way; import it once instead ([Move from Excel or Access](https://artavolo.com/page/move-from-excel-or-access)) or keep the data in Artavolo.
- Dates written another way, such as `30/11/2026`, come over as text. Format the column as `yyyy-mm-dd` in Google Sheets (**Format**, **Number**, **Custom date and time**) to get a date field.
- Formulas in the sheet come over as the values Google Sheets shows.

## Related

- [Synced tables: another base, Google Sheets, Jira and Salesforce](https://artavolo.com/page/synced-tables)
- [Link records between tables](https://artavolo.com/page/link-to-another-record)
- [Automate routine work](https://artavolo.com/page/automations)
