Templates / Daily KPI Email Report from Google Sheets

Daily KPI Email Report from Google Sheets

Beginner   Apps: Schedule, Google Sheets, Gmail  ·  Setup: 10 minutes

Dashboards only work if someone opens them. A daily email is the report that actually gets read - but BI tools charge real money for scheduled email reports. If your numbers land in a Google Sheet, this workflow turns the latest row into a clean morning email for free.

Download workflow JSON (free) Setup guide

What this workflow does

  1. A Schedule Trigger fires every morning at 8:00.
  2. A Google Sheets node reads your KPI sheet.
  3. A Code node grabs the most recent row and builds a small HTML table from its columns.
  4. A Gmail node sends the report to you (or a whole team list).

Setup guide

  1. Import the JSON into n8n (Workflows > Import from File).
  2. Connect Google Sheets and select your spreadsheet and sheet - any columns work, the email builds itself from whatever is there.
  3. Connect Gmail and set the recipient address in the send node.
  4. Adjust the schedule to your preferred hour.
  5. Run once manually to see your first report, then activate.

Want this running 24/7?

Self-host n8n on a cheap VPS and this workflow runs around the clock for less than a coffee a month.

Get an n8n VPS from $5/month

FAQ

My data is one row per day - what if I want a weekly summary instead?Change the schedule to Mondays and edit the Code node to slice the last 7 rows and sum or average the numeric columns.
Can it email the report to several people?Yes - the Gmail node accepts a comma-separated list of recipients, or swap it for a Slack node to post the same table to a channel.
Can it include a chart?Not directly from this template, but you can add an HTTP Request node that renders a chart image via the free QuickChart API and attach it to the email.

Want the workflows this one is a warm-up for?

The Mega Bundle packs both WorkflowForge Pro volumes — 32 production-grade workflows: automations (cart recovery, lead scoring, invoice extraction) and AI agents (support agent, calendar assistant, research agent), each with a setup guide. $39 for both, instant download.

Get the Mega Bundle →

Need it customized for your exact process?

I build custom n8n automations and AI agents professionally: your tools, your edge cases, tested and documented.

Hire me on Fiverr →