I will build a real time business dashboard connected to google sheets


About this gig
I build real-time, interactive business dashboards that connect directly to your Google Sheets no backend server, no database required.
What you get:
- Live data sync from Google Sheets
- 8+ core KPI metrics as clean summary cards (Total Projects, Contract Value, Outstanding, Avg Completion, etc.)
- Rich visualizations with Chart.js: bar, doughnut, line charts, and sortable data tables
- Dynamic cascading filters all charts update instantly
- Smart parsing of currency and date formats
- Dark theme, responsive UI
- CSV upload fallback if Sheets connection fails
Why this approach?
Pure frontend (HTML/CSS/vanilla JS) no server, no database costs, deploys in seconds via Vercel or Netlify. You get full ownership of a single HTML file you can host anywhere.
Ideal for:
- Construction/project tracking
- Sales pipeline dashboards
- Any business using Google Sheets that wants a professional visual dashboard
Message me with your Sheet structure before ordering so I can confirm field names and layout.
Get to know Likang Studio
Full Stack Developer, Next js, React Native, Supabase, AI Integration
- FromAustralia
- Member sinceAug 2026
- Avg. response time1 hour
Languages
Chinese, English
My Portfolio
FAQ
Do I need a server or database to use this dashboard?
No. This is a pure frontend solution built with HTML/CSS/JavaScript. It connects directly to your Google Sheets, so there's no backend or database required.
What format does my Google Sheet need to be in?
Your sheet needs specific header field names (I'll share the exact list before we start) and needs to be shared as "Anyone with the link – Viewer". I'll confirm your sheet structure with you before starting work.
What happens if my Google Sheets connection stops working?
The dashboard includes a built-in fallback — if the Sheets connection fails or you're offline, you can upload a local CSV file instead and the dashboard will still work.

