I will build an automated google sheets dashboard

M
milesyi
M
milesyi
Blacksmith Yi

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

Blacksmith Yi

Automation Specialist for Google Sheets, n8n and Make

  • FromChina
  • Member sinceMar 2026
  • Languages

    English
I automate the busywork in small businesses. I build AI workflows where your team approves before anything goes out, plus Google Sheets and Notion systems your staff will actually use. I spent 10+ years building enterprise software (chatbots, RPA, CRM, system integrations) and work in the UTC+8 time zone. Every delivery comes with a short how to use guide, and you will know the monthly running costs before we start.