I will build an automated google sheets dashboard with apps script


About this gig
Tired of copying data between spreadsheets every week? I'll turn your raw exports into a Google Sheets dashboard that updates itself.
What I do:
- Merge data from ad platforms, CRM, bank statements or any CSV/Excel exports
- Clean messy data: different date formats, duplicates, typos, numbers stored as text
- Build a clear dashboard with KPIs, charts and plan-vs-actual
- Automate it with Apps Script: one-click refresh, scheduled updates, email/Telegram alerts
Typical projects:
- Marketing dashboard: spend, revenue, ROAS, CPA by channel
- Sales KPI and commission calculation
- Cash flow report and forecast
Why me:
I'm a financial analyst with an accounting background. I check every number against the source data, so your report is not just good-looking but correct.
Please message me before ordering with a sample of your data (it can be anonymized), and I'll tell you exactly what can be automated.
Get to know Krotov Mykola
Data Analyst, Google Sheets Dashboards, Apps Script Automation
- FromUkraine
- Member sinceAug 2025
Languages
Ukrainian, Polish, English
My Portfolio
FAQ
Do I need to share my real data?
No. An anonymized sample is enough to start; you can paste in the real data later.
Will it work in Excel?
The automation is built for Google Sheets. I can also deliver a static Excel version of the dashboard.
What if my data changes format?
The script finds columns by their headers, so new rows or columns in a different order won’t break it.
Who owns the spreadsheet?
You do. Everything is built in your own Google account or copied to it.

