A custom script in Python, JavaScript or Google Apps Script that does your routine work: files, tables, emails and reports

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

A script that does a task you now do by hand: renames and sorts files, merges or cleans tables, turns one file format into another, sends emails from a Google Sheet, makes invoices or reports, or checks a list of web pages. Describe the task, what goes in and what should come out, and attach example files if you have them (CSV, Excel, text files, JSON or screenshots). We write the code in the language that suits the task: Python, JavaScript (Node.js), Google Apps Script for Google Sheets, Docs and Gmail, PowerShell or Bash. You get an archive with the code and a README that explains in plain words what to install and how to set it up and run it, and you can read the code on the order page too. We do not run the script on your computer or in your accounts: you run it yourself, on your own data, so it is worth trying it on a copy first. Passwords and keys stay out of the code: the script reads them from a settings file you fill in yourself. Scripts that get into accounts without permission, get around protection or collect personal data are not made.

What is included

• What you getA ZIP archive with the code, a README with step-by-step instructions and, where needed, an example settings file; the code is also shown on the order page.
• The language that suits the taskPython, JavaScript, Apps Script, PowerShell or Bash
• A plain guideWhat to install and how to run it, step by step
• Settings in one placeFolders, addresses and keys in a file you fill in
• Works on your dataFiles on your computer, CSV, Excel or Google Sheets
• Readable codeWith comments, easy to change later

How it works

1. 1
   TaskYou describe what the script should do and attach example files
2. 2
   CodeWe write the code and the guide to running it
3. 3
   Try itYou run it on a copy of your data
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

What the script should do, step by step: what it takes (files, a folder, a Google Sheet, a list of links), what it should produce and any rules it must follow. Where it will run: Windows, macOS or Linux, Google Sheets, or a server you have, and the language if you need a particular one. Example files help a lot: a few rows of your table as CSV or Excel, a sample text or JSON file, or screenshots. Never send real passwords or keys: the guide explains where you put them yourself.

We will ask you:

• What should the script do?
• What does it take, and what should it produce?
• Where will it run?
• A language or tools you need
• Anything it must never do

Compare packages

Questions and answers

Did not find your answer? Ask us