Monitor KPI thresholds and alert Slack or PagerDuty when metrics breach targets.
This automation starts when scheduled hourly KPI metric pull. It slack watch, then yellow Slack #kpi-watch, red PagerDuty on-call for revenue drop >15% WoW or churn spike >2σ, includes sparkline image QuickChart URL and link to dashboard in al.
Read-only visualization of how data moves from trigger to final result.
Scheduled hourly KPI metric pull
yellow Slack #kpi-watch, red PagerDuty on-call for revenue drop >15% WoW or churn spike >2σ, includes sparkline image QuickChart URL and link to dashboard in al
yellow Slack #kpi-watch, red PagerDuty on-call for revenue drop >15% WoW or churn spike >2σ, includes sparkline image QuickChart URL and link to dashboard in al
Pull
Watch
Remove repetitive steps from KPI Alerts so your team focuses on high-value work.
Connected apps sync data automatically instead of copy-paste between dashboards.
Standardized logic runs the same way every time, with retries on failure.
Automation runtime
Connect required apps via OAuth or API keys. Credentials are encrypted server-side. Dev test runs mock external actions when connections are missing.
Est. setup time: ~3 min
Schedule trigger
Activate this workflow to provision the trigger endpoint.
No runs yet. Install the template and run a test, or activate to receive webhook/schedule runs.
Hourly BigQuery or Sheets KPI pull compares revenue, churn, CAC, inventory days to thresholds in config—green/yellow/red bands—yellow Slack #kpi-watch, red PagerDuty on-call for revenue drop >15% WoW or churn spike >2σ, includes sparkline image QuickChart URL and link to dashboard in alert.
BigQuery/Sheets KPIs, Slack, PagerDuty, QuickChart sparklines.
Per KPI yellow and red thresholds with hysteresis to prevent flapping.
WoW, MoM, vs target budget variance in alert text.
Sparkline 7-day trend image and dashboard deep link.
Mock threshold breach fires PagerDuty test incident.
| Variable | Type | Default | Required |
|---|---|---|---|
| Business Name | text | Your Business | Yes |
| Notification Email | — | Yes | |
| Timezone | select | — | Yes |
| Slack Channel | text | #general | No |
| Google Sheet ID | text | No | |
| Sheet Range | text | Sheet1!A:Z | No |
Yellow alerts respect quiet hours; red always fires.
Separate threshold sets per business unit.
Max one red alert per KPI per 4 hours unless worsening.
Add SQL query row in config sheet; validated before enable.
Our team can adapt this template to your exact workflow, apps, and brand requirements.
355 total reviews
We deployed this across three locations and saw immediate time savings. The KPI Alerts workflow handles edge cases we didn't expect it to.
+ Saved our team 10+ hours weekly · Reliable triggers every time
− Took longer than estimated for advanced config
Solid template. We duplicated and tweaked variables for our brand. Would recommend for teams starting automation.
+ Setup was straightforward · Great documentation
Clean workflow design. Connected our stack in one afternoon. Minor learning curve on variables.
+ Integrations worked on first try · AI quality exceeded expectations
Hourly BigQuery or Sheets KPI pull compares revenue, churn, CAC, inventory days to thresholds in config—green/yellow/red bands—yellow Slack #kpi-watch, red PagerDuty on-call for revenue drop >15% WoW or churn spike >2σ, includes sparkline image QuickChart URL and link to dashboard in alert.
Activate KPI Alerts with default variables and run a sandbox test.
Scenario: New user installs template and validates output in under 15 minutes.
Connect live apps, map business rules, enable monitoring alerts.
Scenario: Team deploys to workspace after QA sign-off on test runs.
Version 1.2.0 — Improved reliability and Slack notifications for KPI Alerts.
Current version: 1.2.0
CSV Upload Dashboard Update — orchestrates Google Sheets, Google Analytics, Stripe, HubSpot to automate this workflow with field mapping, notifications, and audit logging.
Auto-build Looker Studio or Google Sheets dashboards from connected data sources.
KPI Threshold Alert — orchestrates Google Sheets, Google Analytics, Stripe, HubSpot to automate this workflow with field mapping, notifications, and audit logging.
Executive Metrics Monday Brief — orchestrates Google Sheets, Google Analytics, Stripe, HubSpot to automate this workflow with field mapping, notifications, and audit logging.
KPI Threshold Alert — orchestrates Google Sheets, Google Analytics, Stripe, HubSpot to automate this workflow with field mapping, notifications, and audit logging.
HubSpot Pipeline Snapshot — orchestrates Google Sheets, Google Analytics, Stripe, HubSpot to automate this workflow with field mapping, notifications, and audit logging.
Distill lengthy board decks and financials into one-page executive summaries.
Canva Asset Approval Flow — orchestrates LinkedIn, X, Instagram, Buffer to automate this workflow with field mapping, notifications, and audit logging.
Consolidate tasks from Slack, email, and voice into prioritized Google Tasks and Asana.
Pull Request Review Summary — orchestrates GitHub, Slack, Jira, Linear to automate this workflow with field mapping, notifications, and audit logging.
Inbox Priority Briefing — orchestrates Gmail, OpenAI, Google Calendar, Slack to automate this workflow with field mapping, notifications, and audit logging.
