Sync KPI metrics from ClickUp and Google Sheets to Slack and Gmail
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Cron. 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 10 nodes and runs on a schedule (legacy Cron node) (plus 1 other trigger). Along the way it connects Slack, ClickUp, Google Sheets and Gmail.
How it runs
Trigger: On a schedule (legacy Cron node) (plus 1 other trigger).
- Google Sheets: uses Google Sheets
- ClickUp: get many
- Slack: uses Slack
- Merge: merges the data from its input branches
- Code: runs custom JavaScript code
- Set - Format Output Data (Edit Fields (Set)): sets 10 fields: tasks, tasks.overdue, tasks.overduePercentage…
- Slack: uses Slack
- Gmail: uses Gmail
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Cron in Daily Cron Trigger: replace with Schedule Trigger.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron Daily Cron Trigger | Schedule Trigger |
Nodes used (9)
- Error Trigger
n8n-nodes-base.errorTrigger - Slack
n8n-nodes-base.slack - Cron
n8n-nodes-base.cron - ClickUp
n8n-nodes-base.clickUp - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Gmail
n8n-nodes-base.gmail
From the author
Description Automate daily KPI tracking and reporting by integrating ClickUp tasks and Google Sheets lead data into a unified dashboard. This workflow computes performance metrics, analyzes sentiment, and delivers visualized reports to Slack and Gmail for…