A Google Apps Script that emails you each new Google Forms answer, laid out clearly and sent to the right person

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

Google Forms can tell you that a new answer arrived, but not what it says, and not to the colleague who handles that city or service. This Google Apps Script runs each time someone submits your form and sends an email with the answers laid out clearly: the questions in bold, the answers under them and a link to the response sheet. From Standard it chooses who gets the email by an answer, such as sending London requests to one address and Paris requests to another. Premium can send the person who filled the form a confirmation, if the form asks for their email, and a daily summary to you. Emails go from your own Google account, within the daily limit Google sets. You install it in your account.

What is included

• What you getA ZIP archive with the Apps Script code and a README that shows how to add it to your form, allow access and set the trigger; the code is also shown on the order page.
• The whole answerEvery question and answer in the email itself
• A clear subjecte.g. New request: Name, Service
• To the right personFrom Standard, the address chosen by an answer
• From your accountSent from your Google account, within Google's limits
• Readable codeWith comments, easy to change the email later

How it works

1. 1
   TaskYou send the form's questions and who should get what
2. 2
   CodeWe write the script and the guide to installing it
3. 3
   Try itYou add it to a copy of the form and send a test answer
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

The questions of your form (a screenshot or the list), the addresses that should get the alerts and, from Standard, the rule for who gets what, such as by city or service. The subject and any text you want in the email. For a confirmation to the person who filled the form (Premium), the text of that email and the question that asks for their address. Whether your form saves answers to a Google Sheet.

We will ask you:

• What is the form for?
• Who should get the alerts?
• What should the email look like?
• Anything else to send?

Compare packages

Questions and answers

Did not find your answer? Ask us