Browse categories
Explore
Fiverr Pro
English
$
USD
I will automate google sheets reports and dashboards with apps script
Noah Lee
About this gig
If your team lives in Google Sheets, a few small scripts can save hours every week. I'll set up the formulas, buttons, triggers and reports so the sheet does the boring part.
I build business tools for small companies, including work and settlement records for a photo-studio brand with 14 branches and order/inventory reports for a beauty brand. A lot of that work starts and ends in spreadsheets, so I know how messy they get.
Things I can help with:
- Apps Script: custom menus, buttons, scheduled triggers, emails from Sheets
- Pulling data from forms, other sheets or APIs into one place
- Clean summary tabs and charts (daily / monthly sales, stock, staff hours)
- Fixing broken formulas (QUERY, ARRAYFORMULA, VLOOKUP/XLOOKUP, IMPORTRANGE)
Please share a copy of your sheet (fake data is fine) and describe what you'd like to stop doing by hand. I'll reply with a plan and an honest estimate before you order.
Everything stays in your Google account. I'll leave notes in the script so you can see what each part does.
Get to know Noah Lee
Noah Lee
Inventory and daily sales web apps
- FromSouth Korea
- Member sinceApr 2024
Languages
English, Korean
I build web apps for store teams who need inventory and daily sales in one place. A signed-in user can enter items, record what sold, and look up the day's numbers.
The same kind of screen is in a fishery daily ledger and a photo-studio shift close. Figures in portfolio images are sample data. I confirm your fields before building. Basic is a single-user stock and sales list. A multi-store ledger, extra roles, and hosting are separate packages.
Based in Ansan, South Korea. I work in Korean and English.
My Portfolio
Other Software Development Services I Offer
FAQ
Do you need edit access?
A copy of the sheet is best; I'll hand back the finished file or apply changes to yours.
Excel too?
Yes for formulas; scripts are Google Sheets only (Excel VBA by request).
Can it connect to my shop or another app?
Often yes if it has an API (e.g. Shopify, cafe24). Ask first.
Will scripts keep working?
Triggers run in your Google account; I include notes on Google's daily limits.
