I will automate google sheets with formulas and apps script
About this gig
Spending hours each week copying data, fixing broken formulas or building the staff rota by hand? I turn those spreadsheets into tools that do the work for you.
I'm Thiago, a developer in Dublin with over 5 years in tech operations. I help small businesses solve everyday operational problems in Google Sheets and Apps Script, and I have built a multi-store retail staff rota that checks contract hours, rest periods and peak-hour cover automatically.
What I build:
- Staff rotas and shift planners with your rules built in
- Multi-tab trackers and KPI dashboards
- Complex formulas, data validation and conditional formatting
- Apps Script automation: custom menus, triggers and email alerts
- Browser web apps on top of your sheet, so staff can view or submit data without editing the spreadsheet
How I work:
- We agree the scope before you order, so the package fits the job
- You get a clean, documented file that you own
- Standard and Premium include a short video walkthrough
- I reply during EU business hours, in English or Portuguese
Message me with a short description of what you track today. A screenshot or a copy with dummy data helps me quote accurately.
Get to know Thiago De Souza
Developer building websites and Google Sheets tools for small businesses
- FromIreland
- Member sinceDec 2020
Languages
English, Portuguese
FAQ
Do you work in Excel?
I specialise in Google Sheets and Apps Script. I don't offer Excel VBA macros.
Will the rota guarantee legal compliance?
I build in the rules you give me, such as maximum hours, minimum rest and contract hours. Please confirm the legal requirements with your HR team or adviser.
Do I need to pay for extra software?
No. It runs on your own Google account, within Google's standard usage limits.
Can you fix or improve a sheet I already have?
Yes. Share a copy with dummy data and I'll confirm the scope and price before you order.
What if something breaks after delivery?
Every package includes 7 days of fixes for anything I built.
How do you handle my data?
I work on a copy with dummy or anonymised data, then hand over the finished file or script to your account.

