Leaving Airtable? Bring your bases to Artavolo, checked record by record. See how

Sync a table from Google Sheets

Updated

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

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

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) 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