A Google Apps Script that copies records between your Airtable base and a Google Sheet, one way or two-way

Example result

python merge_sales.py --month 2026-10

2026-11-02 09:14:03 INFO  Folder: sales/2026-10, 9 files found
2026-11-02 09:14:03 INFO  shop-01.csv: 1,284 rows
2026-11-02 09:14:04 INFO  shop-02.xlsx: 967 rows
2026-11-02 09:14:04 WARN  shop-07.csv: 3 rows without a price skipped (lines 88, 412, 913)
2026-11-02 09:14:05 INFO  Done: 10,412 rows -> report-2026-10.xlsx (sheets "Sales" and "Totals")

[columns]
date = Date, Sale date, Day
product = Product, Item, Name
quantity = Qty, Quantity, Pcs
price = Price, Unit price

def read_shop_file(path: Path, columns: dict[str, list[str]]) -> pd.DataFrame:
    """Reads one shop's file and gives it the report's column names."""
    table = pd.read_excel(path) if path.suffix == ".xlsx" else pd.read_csv(path, encoding="utf-8-sig")
    renamed = {}
    for name, variants in columns.items():
        found = next((c for c in table.columns if c.strip() in variants), None)
        if found is None:
            raise ReportError(f"{path.name}: no column for '{name}' (looked for {', '.join(variants)})")
        renamed[found] = name
    table = table.rename(columns=renamed)[list(columns)]
    table["shop"] = path.stem
    return table

About this service

Some people on a project work in Airtable, others only in Google Sheets, and copying records between the two goes wrong sooner or later. This Google Apps Script reads your Airtable base through its official API with your own personal access token and writes the records you choose into a sheet: one table or a view, the fields you need as columns. From Standard it keeps the record ID in each row, so a second run updates rows instead of doubling them, and shows linked records as names. Premium sends edits from the sheet back to Airtable by the rule you set for which side wins. Your token goes into the script's properties, which you fill in, never into the code. It runs at the pace Airtable's API allows; attachments come over as links.

What is included

• What you getA ZIP archive with the Apps Script code and a README that shows how to add it to your sheet, put in your token and run it; the code is also shown on the order page.
• Official APIAirtable's own Web API with your token
• Fields you chooseA table or a view, only the fields you need
• No doublesFrom Standard, rows matched by record ID
• Token out of the codeYou put it into the script's properties
• Readable codeWith comments, easy to add a field later

How it works

1. 1
   TaskYou describe the base, the tables and the direction
2. 2
   CodeWe write the script by Airtable's documentation and the install guide
3. 3
   Try itYou run it on a copy of the base or a test view
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

The Airtable tables or views to sync and a screenshot of their fields with their types (text, number, date, single select, linked record, attachment), the sheet they go to and how the columns should be named and ordered. Which direction you need and, for two-way sync (Premium), which side wins when the same record changes in the two places. How often it should run. Create the personal access token in your Airtable account; never send it to us.

We will ask you:

• What is in the Airtable base?
• Which direction do you need?
• Which fields should come over?
• How often should it run?

Compare packages

Questions and answers

Did not find your answer? Ask us