Email List Growth & Engagement Tracker

Overview

What it does: Every morning at 6am, this workflow fetches email list statistics from Mailchimp (or ConvertKit, ActiveCampaign, etc.), logs daily metrics to a Google Sheet, and uses OpenAI to analyze growth trends, engagement health, and churn. The analysis highlights growth rate week-over-week, identifies engagement patterns, and recommends actions to improve list growth and retention. Business outcome: Track email list health systematically. Spot declining engagement early. Understand what drives growth vs. churn. Make data-backed decisions on email strategy. Average teams see 15-25% engagement improvements after applying recommendations. Nodes & apps: n8n schedule trigger, Mailchimp API (or equivalent), Google Sheets, OpenAI GPT-4o, Gmail for email delivery. Credentials needed: 1. Mailchimp API key (or equivalent email platform) 2. Google Sheets API key 3. OpenAI API key 4. Gmail account for report delivery Setup steps: 1. Create a Google Sheet with columns: date, total_subscribers, new_subscribers, unsubscribes, open_rate, click_rate, growth_rate_pct 2. Get Mailchimp API credentials from Account Settings 3. Configure worksheet ID in workflow 4. Add OpenAI key for analysis 5. Set report recipient email address 6. Test with manual run 7. Activate daily 6am schedule 8. Review insights weekly and implement recommendations Difficulty: Medium | Setup time: 12-15 minutes | Price: $21

What's included

Quickstart

1. 01

   Download the JSON

   With an active Library Pass, download the workflow file right from this page or your dashboard.

2. 02

   Import into n8n

   Choose Import from File and select the downloaded JSON. The full agent graph appears, ready to configure.

3. 03

   Plug in credentials

   Each integration node prompts for credentials on first run. The setup guide lists every credential the agent expects.

4. 04

   Activate and test

   Run once with sample input, confirm the expected output, then flip the activate toggle.

Sign in to leave a review.