I will build an automated google sheets dashboard with apps script

M
mykola_krotov
M
mykola_krotov
Krotov Mykola

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

Krotov Mykola

Data Analyst, Google Sheets Dashboards, Apps Script Automation

  • FromUkraine
  • Member sinceAug 2025
  • Languages

    Ukrainian, Polish, English
Financial & data analyst who turns messy spreadsheets into reports that update themselves. I build Google Sheets & Excel dashboards with Apps Script automation: merging data from ad platforms, CRMs and bank statements, cleaning it and delivering KPI dashboards, P&L, cash-flow and sales commission reports with email/Telegram alerts. Background in accounting, budget reconciliation and sales KPI systems. Tools: Google Sheets, Apps Script, SQL, Power BI, Excel. Every number is double-checked. Send me your spreadsheet and I’ll show you what can be automated.

My Portfolio