I will automate google sheets sales reports with apps script

South Korea

I speak Korean

Google Sheets and Apps Script Automation

I create straightforward Google Sheets automations in Apps Script, including daily sales summaries, data validation, and simple custom menu actions. Each delivery includes the script and setup notes, ...
About this Gig

I build small, clearly scoped Google Sheets automations with Apps Script: daily sales summaries, input checks, and simple custom menu actions. Each order includes Apps Script code and setup notes. I test the agreed result with sample rows.


Sample: Add order lines to Orders and choose Sales report > Build from Orders. The demo groups sales by date, counts repeated order IDs once, and shows orders, units, gross sales, average order value, and a total. It checks required headers, real dates, positive whole quantities, and prices with up to two decimals. It asks before replacing an existing summary.


Basic: one small action in one Sheet (for example, a menu action or safe formatting). Standard: one workflow with up to 2 steps. Premium: one workflow with up to 4 steps, input checks, and a sample test.


All packages cover one Google Sheet. To start, share the repeatable steps, column names, rules, and desired result, plus a copy with fake or anonymized data. Never send passwords or real customer/payment details. Paid APIs, external services, subscriptions, and ongoing support are excluded. I confirm scope before starting. The demo uses synthetic data.

Technology:

Google Sheets

Expertise:

Data manipulation

•

Data validation

My Portfolio