A Google Apps Script that labels, archives and tidies your Gmail by rules that ordinary filters cannot do

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

Gmail filters act only on new mail and only by simple conditions. This Google Apps Script tidies the mail already in your inbox too, by rules such as: label everything from your suppliers' domains, archive newsletters older than 14 days, mark receipts as read and put them under Accounts, or star unanswered messages from clients after three days. It works by Gmail search, the same words you type in the search box, so a rule is easy to read and change. From Standard the rules sit on a Google Sheet tab you edit, and a log shows what it did. It does not delete mail: it labels, archives and marks; moving to Trash is added only if you give that rule. You install and run it in your own Google 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 account, allow access and run it; the code is also shown on the order page.
• Old mail tooWorks on what is already in your inbox
• Gmail search rulesfrom:, subject:, older_than: and the rest
• Labels, archive, read, starThe actions you choose for each rule
• No deleting by defaultTrash only if you give that rule
• Readable codeWith comments, easy to add a rule later

How it works

1. 1
   RulesYou list the rules in plain words
2. 2
   CodeWe write the script and the guide to installing it
3. 3
   Try itYou run it on one rule first and check the labels
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

Your rules in plain words: which mail (sender or domain, words in the subject, age, has an attachment), what to do with it (label, archive, mark as read, star) and the label names you use. Roughly how much mail is in the box and how often new mail should be sorted. Whether you use a free Gmail or Google Workspace. No passwords and no screenshots of private mail: example senders like shop.example are enough.

We will ask you:

• What should be sorted?
• What should happen to each kind?
• Old mail as well, or only new?
• Anything it must never do

Compare packages

Questions and answers

Did not find your answer? Ask us