I will automate google sheets with apps script for orders, invoices and emails


About this gig
Copying orders into Google Sheets, making invoices by hand, sending the same emails again and again? I can automate it with Google Apps Script.
I'm a developer based in Japan. I built Order to Invoice, an open-source Apps Script project that imports orders into Google Sheets, creates PDF invoices from a Docs template, emails them with Gmail, sends overdue reminders and tracks payments, from one menu or on a daily schedule. See it in my portfolio.
What I can help with:
- Google Sheets automation with Apps Script
- Importing data from an API (for example Shopify) or CSV files into Sheets
- Creating Google Docs and PDF files from a template
- Sending emails with Gmail, including attachments and reminders
- Custom menus, buttons, and time-based triggers
- Fixing an existing script
WHAT YOU GET
- Clean, commented script inside your own Google Sheet
- A short guide to set it up and use it
- 30 days of free bug fixes after delivery
HOW I WORK
Before ordering, please message me with what you do by hand today, a sample sheet (fake data is fine), and any deadline. I'll confirm the scope and the right package.
All communication happens here in Fiverr messages, in English.
Get to know Affect Inc.
Clear communication, careful testing, no surprises
- FromJapan
- Member sinceAug 2026
- Avg. response time1 hour
Languages
English, Japanese
My Portfolio
Other Software Development Services I Offer
FAQ
Do you need access to my Google account?
No. Please share a copy of your sheet with sample or fake data. I build and test on my own account, then send you the script and a guide, or add it to a sheet you share with me as an editor. Please don't share passwords.
Can you connect my store or another app?
Yes, if it has an API (for example Shopify). You create the API key in your own account and paste it into the script settings, so you never need to send it to me in a message.
Are there any limits?
Google limits how many emails and how much run time a script can use each day. For most small businesses this is plenty. I'll tell you up front if your volume needs a different approach.
What if I find a bug after delivery?
Message me within 30 days of delivery. If the script doesn't work as we agreed, I'll fix it for free. New features or changes to the agreed scope are quoted separately.
Do you offer calls?
I work through Fiverr messages only. Written messages keep everything clear and on record, and I reply within 24 hours.
Who owns the script?
You do. The script lives in your own Google Sheet.

