A Google Apps Script that saves attachments from your Gmail into Google Drive folders by sender, date or type

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

Invoices from suppliers, signed documents, reports sent every week: when attachments stay in Gmail, finding one later means searching through threads. This Google Apps Script goes through the mail you pick with a Gmail search, such as from your suppliers with a PDF, and saves each attachment into a Google Drive folder: one folder, or subfolders by sender, month or file type, with names that include the date and sender. It then labels the mail as saved, so nothing is saved twice, and from Standard writes each file to a log. Small pictures in signatures can be left out. Files take space in your Drive. A run is limited to about six minutes, so a big backlog goes in parts. You install and run it in your 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.
• Mail by Gmail searche.g. from:@supplier.example has:attachment
• Folders your wayOne folder, or by sender, month or type
• Clear file namesDate and sender added to the name
• Nothing twiceSaved mail gets a label and is skipped next time
• Readable codeWith comments, easy to add a folder later

How it works

1. 1
   TaskYou say which mail to take and how to lay out the folders
2. 2
   CodeWe write the script and the guide to installing it
3. 3
   Try itYou run it on a narrow search first and check the folder
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

Which mail to take: senders or domains, words in the subject, file types, a date range, or a Gmail search you already use. How the Drive folders should be laid out and named, how files should be named, and what to skip (signature pictures, files under a certain size). Roughly how many emails with attachments there are now and how often new ones arrive, and whether you use a free Gmail or Google Workspace.

We will ask you:

• Which attachments do you need?
• How should the folders be laid out?
• How should files be named?
• Old mail too, and how often?

Compare packages

Questions and answers

Did not find your answer? Ask us