Weekly KPI Report Compiler
Pulls numbers from several sources (analytics, CRM, ad platforms) into one spreadsheet and posts a formatted summary to a team channel every Monday, replacing a manual copy-paste ritual.
What this template does
Pulls numbers from several sources (analytics, CRM, ad platforms) into one spreadsheet and posts a formatted summary to a team channel every Monday, replacing a manual copy-paste ritual. It's categorized in our directory under Ops Automation — internal operations: invoicing, reporting, data sync, and the glue work that keeps a business running between tools that don't talk to each other natively.
Integrations
- Google Sheets
- Slack
Setup steps
- 1Pull last week's numbers from each source via API.
- 2Write them into a running spreadsheet for historical tracking.
- 3Compute week-over-week deltas.
- 4Post a formatted summary to the team channel on a fixed schedule.
More Ops templates
Other ops automation templates in our directory.
Custom n8n Workflow Build Process
Our own production process for building client n8n workflows: mapped processes, idempotent builds so re-runs don't duplicate data, Slack alerts on failure, and a documented handover instead of a black box.
Slack Error Alerting for Automations
A wrapper pattern that catches failures in any workflow and posts a formatted alert to Slack with the error message and the run link, so a broken automation gets noticed the same day instead of silently failing for weeks.
Overdue Invoice Reminder Automation
Checks accounting software daily for invoices past their due date and sends a polite, staged reminder sequence by email, so collections don't depend on someone remembering to chase.
New Customer Onboarding Checklist Trigger
Fires when a deal is marked won in the CRM and creates the onboarding checklist, kicks off a welcome email sequence, and notifies the account owner — so onboarding starts the same day a deal closes.