Overview
This n8n workflow automatically generates weekly performance reports for completed email campaigns from ManyReach, converts them to Google Docs, and shares them via Slack.
Workflow Trigger
- Schedule : Runs every Monday (weekly)
- Automates the entire reporting process without manual intervention
Process Flow
1. Data Collection
- Fetch All Campaigns : Retrieves up to 100 campaigns from ManyReach API
- Split Out : Breaks down the campaign list into individual items
- Filter : Selects only campaigns that are both:
- Active (
active = true)
- Completed (
campStatus = "completed")
2. Campaign Processing Loop
The workflow processes each filtered campaign individually:
- Fetch One Campaign : Retrieves detailed data for the specific campaign
- Campaign Report Agent : AI-powered analysis using GPT-4.1 that generates:
- Executive summary with key highlights
- Performance metrics (open rate, click rate, reply rate, conversion rate)
- Email content analysis
- Configuration insights
- Actionable recommendations
- Next steps
3. Report Generation
- Markdown → HTML : Converts the AI-generated markdown report to HTML format
- Set Details : Prepares document metadata (name, content)
- HTML → Magic 🪄 : Formats the HTML content for Google Drive upload with proper styling
4. Distribution
- Upload Doc : Creates a new Google Doc in the connected Drive account
- Send a Doc Link : Posts the document link to the
#manyreach Slack channel with campaign name
Key Features
- Automated Analysis : AI evaluates campaign performance against industry benchmarks
- Comprehensive Metrics : Tracks prospects, opens, clicks, replies, conversions, and interested leads
- Professional Reports : Generated as formatted Google Docs for easy sharing
- Team Notifications : Automatic Slack alerts keep the team informed
Required Credentials
- ManyReach API (HTTP Query Auth)
- OpenAI API (for GPT-4.1)
- Google Drive OAuth2
- Slack OAuth2
Output
Each completed campaign receives a detailed performance report posted to Slack with a direct link to the Google Doc for review and collaboration.
