I will build an automated google sheets dashboard


About this gig
Your data is already in Google Sheets. What is missing is one screen that turns it into decisions and updates itself when the numbers change.
I build that dashboard: your brand colors, metrics that calculate from your data, color coded status, and charts that refresh on their own. No manual updates, no broken formulas.
WHAT YOU GET
A clean dashboard, not a plain spreadsheet
Formulas that grow with new rows, with zero #REF! or #DIV/0! errors
Dropdowns and status colors (done, in progress, late)
Input cells kept separate from locked formulas
A short how to use guide
Premium: Apps Script automation (auto refresh, email alerts or scheduled data pulls) and a reusable template
HOW IT WORKS
1. You share your data or describe it, plus brand colors if you have them.
2. I map the logic, build it, and send screenshots for your OK before finalizing.
3. You get the live Sheet and the guide.
Not sure which package fits? Message me your use case before ordering and I will tell you.
Get to know Blacksmith Yi
Automation Specialist for Google Sheets, n8n and Make
- FromChina
- Member sinceMar 2026
Languages
English
FAQ
Can you pull data from another app or an API into the sheet?
Yes. With the Premium package I can add Apps Script that pulls from a REST API on a schedule, removes duplicates and logs errors.
I have a messy sheet already. Can you work from that?
Yes. Send it over and I will build the dashboard on top of it, or rebuild it cleanly.
Will it break when I add new rows?
No. Everything uses dynamic formulas that expand with your data.
Can you do Excel instead of Google Sheets?
Yes. I can deliver the same in Excel.

