I will automate google sheets invoices and reports with apps script
About this gig
Still copying rows into invoice templates, saving PDFs and emailing them one by one? I'll automate it inside the Google Workspace you already use.
I'm Mina, a Sydney pharmacist and pharmacy manager. I built my own invoicing tool in Google Apps Script: I enter my hours on my phone, and it fills my invoice template, saves it to Drive and emails it through Gmail. It uses safe invoice numbering, so nothing is sent twice.
What I can build for you:
- One automation in an existing Sheet: a button or trigger that creates a PDF, sends an email or moves data
- An invoice generator: Sheet row to your template to PDF in Drive to Gmail, with auto numbering and a sent log
- A scheduled summary: weekly or monthly totals and unpaid invoices, emailed to you
You get commented code in your own Google account, a short setup guide and a test run on sample data.
Message me with what you do now, step by step, before ordering, so we can agree the scope.
Not included: Xero, MYOB or QuickBooks integrations, payment processing, Excel VBA macros, data entry, or more than one invoice template, unless quoted separately.
Get to know Mina I.
Pharmacist and app builder: React, Supabase and Apps Script
- FromAustralia
- Member sinceOct 2021
- Avg. response time1 hour
Languages
English
Other Software Development Services I Offer
FAQ
Do I need Google Workspace?
A free Google account works for small volumes. Workspace has higher daily email and runtime quotas. I check your volume against Google's limits before we start.
Can it use my existing invoice design?
Yes, one Google Doc or Sheet template, matched rather than redesigned. Excel files are converted to Google Sheets first.
Where does the script live, and do you need my password?
It lives in your own Google account and you authorise it yourself. I never need your password: share a copy of your Sheet with sample data and I build and test there.
Can it connect to Xero, MYOB or QuickBooks, or take payments?
Not in these packages. Ask me first and I'll tell you honestly whether it's feasible, and quote it separately.
What if it breaks later?
Revisions cover defects in what I delivered. Changes to your sheet structure or new features are quoted separately.

