AutomationMart
Home/Browse/Host a static HTML KPI dashboard from Google Sheets with CustomJS
n8n

Host a static HTML KPI dashboard from Google Sheets with CustomJS

n8nn8n8 modulesv1.0
Google Sheets

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
Host a static HTML KPI dashboard from Google Sheets with CustomJS workflow diagram

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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

With this automation, you can easily track referring domain changes across multiple target domains just in one click. On each run, the scenario reads your target domains from the Google Sheet, aggregates them into a single batch request, and sends it to the DataForSEO Bulk New & Lost Referring Domains endpoint. The endpoint returns the number of newly acquired and recently lost referring domains for up to 1000 domains, subdomains, or pages, including separate counts for newly acquired and recen

Free

Export Celoxis timesheets to Google Sheets

This templates shows how to export a list of Celoxis time entries in Google Sheets. The scenario can be set at regular intervals to export Celoxis timesheets based on a specific condition.

Free

Chatbot appointment scheduler with Google Calendar for dental assistant

This workflow template is designed for dental assistants and anyone looking to automate appointment scheduling. It integrates Google Calendar for booking appointments and Google Sheets as a database to store patient information. How It Works The user interacts with the chatbot to schedule an appointment. The chatbot collects necessary details and checks availability via Google Calendar. If the requested time is available, the AI books the appointment. If unavailable, the AI suggests alternative

Free

Generate & auto-post AI videos to social media with Veo3 and Blotato

Automate video creation with Veo3 and auto-post to Instagram, TikTok via Blotato Who is this for? This template is ideal for content creators, social media managers, YouTubers, and digital marketers who want to generate high-quality videos daily using AI and distribute them effortlessly across multiple platforms. It’s perfect for anyone who wants to scale short-form content creation without video editing tools. Wha

Free

Automate employee date tracking & reminders for HR with JavaScript

HR Date Management Automation - Complete Setup Guide 🎯 How It Works This n8n workflow transforms your HR department from reactive to proactive by automatically monitoring 5 critical employee timelines and generating smart alerts before deadlines hit. Core Components 1. Data Input → Employee information (hire dates, contracts, certifications) 1. Date Analysis Engine → Calculates days until critical events 1. Smart Categorization → Sorts employees by urgency level

Free

Watch for new CDR records and store in Google Sheet

Use this automation to automatically store Cloudonix call detail records to Google Sheets. You may modify this template to store more information and perform pre-storage processing.

Free

Extract and decode Google News RSS URLs to clean article links

The workflow performs tasks that would normally require human intervention on Google News links, transforming the RSS feeds into data that can be used by an automated system like n8n, thus creating a solid foundation for further applications Who is this for? This workflow is ideal for developers, journalists, and content aggregators who need to extract and clean Google News URLs from its RSS feed. What problem does this workflow solve? Google News RSS provides encoded URLs that contain addition

Free

Scrape property listings from Zillow with Olostep API and store in data tables

Zillow Property Scraper Using Olostep API This n8n template automates Zillow property data collection by scraping Zillow search results using the Olostep API. It extracts property price, link to listing, and location, removes duplicates, and stores everything in a Google Sheet or Data Table. Who’s it for - Real estate analysts and investors researching property markets. - Lead generators needing structured Zillow data. - Freelancers and automation builders collecting housing listings. - An

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free