A Google Apps Script that loads data from a service's API into your Google Sheet and keeps it up to date

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

Orders from your shop platform, tasks from a project service, entries from a booking system: if the service has a public API, the data can land in your Google Sheet without exporting files by hand. This Google Apps Script sends a request to the API with your own key, takes the fields you need and writes them as rows, page after page. From Standard the key sits in the script's properties, which you fill in, not in the code, and errors go to a Log tab; Premium adds only new or changed rows and a guide to running it every hour or day with a trigger. Send us a link to the API's documentation and the fields you want. A single run is limited to about six minutes, so very large imports go in parts.

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 key and run it; the code is also shown on the order page.
• By the documentationWritten from the API's own documentation
• Fields you chooseOnly the columns you need, in your order
• All pagesResults that come in pages are read to the end
• Key kept out of the codeYou put it in the script's properties yourself
• Readable codeWith comments, easy to add a field later

How it works

1. 1
   TaskYou send the API documentation and the fields you need
2. 2
   CodeWe write the script by the documentation and the guide to installing it
3. 3
   Try itYou add your key in a copy of the sheet and run it
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

The service and a link to its API documentation, the request you need (for example orders for the last 30 days) and the fields that should become columns. An example of the API's answer helps a lot: copy it from the documentation or from a test call with private values removed. How often the data should refresh and whether new rows are added or the sheet is rewritten. Never send your real API key: the README shows where you put it.

We will ask you:

• Which service, and where is its API documentation?
• What data do you need?
• How often should it refresh?

Compare packages

Questions and answers

Did not find your answer? Ask us