A Google Apps Script that loads the exchange rates you need into your Google Sheet from a source you choose

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

If your prices, invoices or reports depend on exchange rates, typing them in every morning is easy to forget. This Google Apps Script reads the rates from a public source you choose, such as the rates your central bank publishes or a rates service where you get your own key, and writes the currencies you need into your Google Sheet with the date. From Standard it keeps a history tab with a row per day, so your formulas can look up the rate for any date; Premium adds a second source if the first does not answer and fills in past dates. Google Sheets has its own GOOGLEFINANCE function for some currencies; this script is for when you need a particular source or a stored history. The rates are the source's; we give no financial advice.

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, allow access and set it to run daily; the code is also shown on the order page.
• Your sourceThe official or service rates you choose
• Your currenciesOnly the ones you need, against your base currency
• A dated historyFrom Standard, a row per day for lookups
• Key kept out of the codeIf the source needs one, you put it in yourself
• Readable codeWith comments, easy to add a currency later

How it works

1. 1
   SourceYou name the currencies and the source you trust
2. 2
   CodeWe write the script by the source's documentation and the install guide
3. 3
   Try itYou run it in a copy of the sheet and compare with the source's site
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

The currencies you need and your base currency, the source you want to use (a link to the page or documentation where it publishes rates, or let us suggest public ones to choose from), how often you need the rates and at what time, and where they should go in your sheet. If you need past dates (Premium), from which date. If the source asks for a key, create it in your account; never send it to us.

We will ask you:

• Which currencies do you need?
• Which source should it use?
• How often and by when?
• Do you need past dates?

Compare packages

Questions and answers

Did not find your answer? Ask us