Generate Weekly Cold Email Performance Reports with ManyReach, GPT-4.1 & Slack

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.