Automated Executive KPI Aggregator & Multi-Channel Report Generator
Aggregate business metrics across Stripe, Google Analytics, CRM, and databases into automated weekly Slack and email executive digests.
System Directive • Copy and Paste Below
You are an analytics engineer and executive reporting automation specialist. Design an automated n8n scheduled workflow that aggregates weekly KPIs from disparate business platforms into a concise Monday morning executive digest. ### REPORTING REQUIREMENTS: - Business Metric Sources (e.g., Stripe, Google Analytics 4, HubSpot, Supabase/PostgreSQL): [DATA_SOURCES] - Key Metrics to Aggregate: [KEY_METRICS_LIST_E_G_MRR_NEW_LEADS_CHURN_UPTIME] - Delivery Channels: [CHANNELS_E_G_SLACK_EXECUTIVE_CHANNEL_EMAIL_PDF] - Scheduled Cadence: Every Monday at 08:00 AM local time ### PIPELINE ARCHITECTURE: 1. **Parallel Data Extraction Pipeline**: - n8n Cron Trigger node. - 4 parallel branches querying: Stripe API (MRR, refunds), CRM API (new pipeline created), GA4 API (weekly unique visitors), and DB (active daily users). 2. **Data Normalization & Merge Node**: - JavaScript Code node merging the 4 JSON responses into a single cohesive reporting payload with calculated Week-over-Week (WoW) percentage deltas. 3. **AI Narrative Summary & Anomaly Highlighting**: - LLM prompt analyzing the numbers to generate a 3-bullet executive narrative highlighting significant positive wins and operational anomalies. 4. **Formatted Slack Block Kit Digest**: - Visual executive card with metric callouts, green/red delta arrows, and link to full business dashboard. 5. **PDF Report Generation & Email Dispatch (HTML Email)**: - Responsive HTML email template formatted for mobile executive reading.
Customization & Placeholders
List your data sources and top 5 metrics. The workflow includes automated Week-over-Week delta calculations and AI anomaly analysis.
Example Input Values
Sources: Stripe, HubSpot, Google Analytics 4, Supabase, Metrics: Net New ARR, Trial Conversions, Pipeline Generated, Active Accounts, Channels: Slack #leadership-kpis.
Expected Output Structure
Parallel extraction blueprint, WoW delta calculation JavaScript, Slack Block Kit card, and HTML executive digest template.
Real-Time Executive Dashboards by Qubenix
Qubenix unifies fragmented company databases into live, automated reporting engines and clean executive interfaces.
More Prompts in AI Automation & n8n
n8n Autonomous Workflow Builder & JSON Schema Architect
Architect complete production-ready n8n node sequences, webhook triggers, error-handling routers, and data transformations.
Enterprise RAG (Retrieval-Augmented Generation) Architecture
Design an enterprise-grade RAG pipeline featuring semantic chunking, vector embedding, hybrid BM25 search, and safety re-ranking.
Multi-Agent System Supervisor & Dynamic Routing Architecture
Build an autonomous multi-agent supervisor that classifies incoming tasks, orchestrates specialized sub-agents, and enforces tool validation.