⚙️ Generate Weekly Workflow Analytics Reports with n8n API & Email Delivery
⚡ 407 views · ⚙️ DevOps & CI/CD
Description
Generate Weekly n8n Execution Report and Email Summary
**Description:**How it works
- Automatically runs every 7 days to pull all n8n workflow executions from the past week
- Merges execution data with workflow information to provide context
- Generates a professional HTML report with execution statistics (errors, successes, waiting status)
- Sends the formatted report with Outlook or Gmail
Set up steps
1. Configure n8n API Credential
- Go to your n8n instance → Settings → API
- Create a new API token with read access to workflows and executions
- In this workflow, add a new “n8n” credential and paste your API token
- This credential is used by two nodes: “Get all Workflows” and “Get all previous executions”
2. Connect Email Services
- Configure your Outlook credential in the “Send a message outlook” node
- Configure your Gmail credential in the “Send a message gmail” node
- Set your preferred email recipients in both nodes
3. Adjust Schedule (Optional)
- By default, the workflow runs every 7 days
- Edit the “Schedule Trigger” node to change the interval if needed
Key features
- Tracks workflow execution status and runtime metrics
- Calculates average and total runtime for each status type
- Provides visual HTML report with color-coded status indicators
- Dual email delivery (Outlook + Gmail options)
- Requires only n8n API credentials (no external API keys needed)
-
Need Help
🔗 Nodes Used
Gmail, Microsoft Outlook, n8n, Schedule Trigger, Filter
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File