A Google Apps Script that sends personal emails from your Gmail to the people in your Google Sheet

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

When you need to write the same email to 80 clients, students or partners with their name, date or amount in it, copying and pasting takes hours. This Google Apps Script lives in your Google Sheet and sends each row a personal email from your own Gmail: it fills {{Name}}, {{Date}} and any other column into your template, writes Sent and the time into the row and skips rows already sent, so you can run it again safely. It is meant for your own list of people who expect your emails, not for bought lists or cold mass mailing. Google limits how many emails a script can send a day, lower for a free Gmail than for Google Workspace; the script stops at the limit and carries on later. You install and run it in your account.

What is included

• What you getA ZIP archive with the Apps Script code and a README that shows how to paste it into your sheet, allow access and send; the code is also shown on the order page.
• Personal fieldsAny column of the sheet in the subject and the text
• From your own GmailReplies come back to you, like any email you send
• Sent marksEach row shows when it was sent, so nothing goes twice
• Within Google's limitsStops at the daily limit and carries on later
• Readable codeWith comments, easy to change the template later

How it works

1. 1
   TaskYou send the sheet's columns and the email you want to send
2. 2
   CodeWe write the script and the guide to installing it
3. 3
   Try itYou paste it into a copy of the sheet and send to your own address first
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

The column names of your sheet and two or three rows with made-up names and addresses, the subject and text of the email with the places where columns go, and whether it is plain text or with formatting from a Gmail draft. Who the people on the list are and how they came to it (your clients, members, students), roughly how many rows, and whether you use a free Gmail or Google Workspace. Attachments, if any, and where they are on your Drive.

We will ask you:

• Who are you writing to?
• What are the sheet's columns?
• What should the email say?
• Free Gmail or Google Workspace?

Compare packages

Questions and answers

Did not find your answer? Ask us