Host a static HTML KPI dashboard from Google Sheets with CustomJS
Hosting a static HTML KPI dashboard with CustomJS This workflow demonstrates how to automatically generate a weekly KPI dashboard from Google Sheets and host it as a live static HTML page using CustomJS. Instead of manually building and updating dashboards, the workflow fetches KPI data, transforms it into JSON, and generates charts, tables, and KPI cards automatically. The hosted HTML page can be connected to a custom domain with one click. The result
At a glance
Host a static HTML KPI dashboard from Google Sheets with CustomJS is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets
- Modules
- 8
- Price
- Free
- Version
- v1.0

About this workflow
Hosting a static HTML KPI dashboard with CustomJS This workflow demonstrates how to automatically generate a weekly KPI dashboard from Google Sheets and host it as a live static HTML page using CustomJS. Instead of manually building and updating dashboards, the workflow fetches KPI data, transforms it into JSON, and generates charts, tables, and KPI cards automatically. The hosted HTML page can be connected to a custom domain with one click. The result is a fully interactive, production-ready KPI dashboard that updates weekly with minimal effort. --- Why This Workflow? Creating dashboards manually or passing raw sheet data to visualization tools is: - time-consuming - error-prone - hard to automate This workflow automates the process by converting sheet data into structured JSON and feeding it directly into a CustomJS HTML template, generating charts and tables automatically. --- What This Workflow Does - Fetches KPI metrics (Visitors, Leads, Demo Booked, Proposal Sent, Won) from Google Sheets - Aggregates metrics by week and channel - Converts the structured data into JSON for dashboard consumption - Generates a static HTML page with KPI cards, charts, and tables - Hosts the HTML page on CustomJS, optionally connected to a custom domain All without manual intervention. --- Key Features - Automated KPI Dashboards Generate charts, tables, and KPI cards from Google Sheets data - Static HTML Hosting Live dashboards are instantly deployable and accessible anywhere - Custom Domains Connect your own domain with a single click - Interactive Charts Uses Chart.js for bar and line charts, fully responsive - QR Code Ready Optional QR code generation for sharing dashboard links - Token-Efficient Only structured JSON is processed, no large unnecessary payloads --- How It Works 1. Manual or Scheduled Trigger Run the workflow on demand or weekly 2. Load Data from Google Sheets - Pull metrics for the desired period - Aggregate weekly or by channel 3. Prepare Structured JSON Format sheet rows into structured JSON for the dashboard 4. Generate HTML Dashboard Feed JSON into a CustomJS HTML template node Automatically builds KPI cards, charts, and tables 5. Host Static HTML - Deploy instantly via CustomJS - Optional: connect a custom domain - Each update overwrites the previous dashboard 6. Optional Enhancements - Generate QR codes for the dashboard link - Include multiple charts, historical trends, or multiple sheets
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Track New and Lost Referring Domains in Bulk with DataForSEO and Google Sheets
Export Celoxis timesheets to Google Sheets
Chatbot appointment scheduler with Google Calendar for dental assistant
Generate & auto-post AI videos to social media with Veo3 and Blotato
Automate employee date tracking & reminders for HR with JavaScript
Watch for new CDR records and store in Google Sheet
Extract and decode Google News RSS URLs to clean article links
Scrape property listings from Zillow with Olostep API and store in data tables
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you