This n8n KPI reporting template turns the numbers in one Google Sheet into a weekly digest with the change since the last period and whether each KPI is on target, and appends every KPI to a History tab you can chart in Looker Studio as a live dashboard.
One-time purchase. No retainer. Setup guide included.
The workflow file: n8n workflow (JSON)
A step-by-step setup guide (PDF) with a verified cost breakdown
Failure handling: error log with the raw data, a separate Slack failure alert, and a clean response
No credentials included. You connect your own accounts
Make version: coming soon
What this workflow does
Every Monday it reads your KPI definitions (name, how to total it, target, whether higher is better) and your Data sheet
Works out each KPI for this period and the one before it, the percentage change, and whether it is on target
Sends one digest to Slack and email, with a clear list of metrics that received no data and rows it had to skip
Appends every KPI to the History sheet each run, ready for Looker Studio or any dashboard tool
Writes a Log row each run, and alerts you if any step fails, so a missing report never goes unnoticed
If something fails
Every step retries three times automatically
If one channel fails the digest still goes out on the other, and if the history cannot be saved the digest still goes out and says so
Missing data and unreadable rows are reported in the digest, never hidden. Failures are logged to an Errors sheet and alerted in Slack
Apps and accounts you need
n8n
Google Sheets
An email account (SMTP)
Slack
Looker Studio (optional, for the dashboard)
What it costs to run
Item
Cost
n8n (self-hosted)
Free software plus roughly $5 to $7 per month for a small server.
n8n Cloud Starter
Roughly $20 to $24 per month for 2,500 executions.
Email sending
Use your own email provider. Resend, for example, is free up to 3,000 emails per month (100 per day).
Google Sheets and Slack
$0 on free plans.
It runs once a week, about four or five n8n executions a month. The report reflects whatever lands in the Data sheet, which you can feed from other workflows, a form, a spreadsheet formula or a pasted export.
Who it is for
Useful for founders and small teams who want one honest weekly number sheet without building a reporting stack. A Make version is coming soon.
Why a Conviq template
Each template is built to a production standard: failure handling is real, every cost is listed before you buy, and nothing ships with credentials. Browse all n8n workflow templates, learn about our n8n automation services, or have us tailor one as a custom automation project.
Frequently asked questions
Where do the numbers come from?
From a Data sheet with a date, a metric name and a value per row. Feed it from other workflows, forms, formulas or pasted exports.
What if a metric has no data this week?
The digest calls it out as no data instead of showing a misleading zero, so a broken feed gets noticed.
Is there a Make version?
A Make version is coming soon. The n8n version is available now.
We use a small amount of functional cookies to remember your preferences and recognize returning visitors. With your consent, we also use Google Analytics to understand site usage. See our Privacy Policy and Cookie Policy.