Archive and Track Metrics for Email Campaigns
Let AI gather your email data.
Every time I send an email broadcast, the content lives inside my email platform (Kit). I draft in Notion, but then tweak it when I add it to Kit. For my records, I want the final copy saved to my Google Drive.
If you want a searchable record — what you sent, when, how it performed — you have to manually copy content, pull stats, and log it somewhere. Over time, this might fall to the bottom of your to-do list.
What This Automation Does
A scheduled task runs weekly, checks for new broadcasts, and creates a document on your Google Drive. It also pulls send stats, and logs everything to Airtable.
Tools
- Kit (or your email platform)
- Airtable (or a Google Sheet)
- Zapier (to create the Google Doc)
- Google Drive (to store the Google Doc)
- Claude (scheduled task in CoWork)
Step 1: Check for new broadcasts
The scheduled task queries Kit using the Kit MCP for recently sent emails (called broadcasts in Kit). It pulls anything sent since the last run.
Before processing, the task queries Airtable for all existing broadcast IDs. Any broadcast already logged gets skipped. This prevents duplicates even if the task runs multiple times or overlaps with a manual run.
Step 2: Identify the broadcast type
Each new broadcast is checked against your email template names. The “type” (newsletter, announcement, etc.) is stored with the broadcast In Airtable.
Step 3: Create a backup document
The task creates a document in Google Drive, using the Zapier MCP. The Google Drive MCP has limitations on the documents that can be created in Claude, and the Zapier MCP is more flexible.
The task parses out the broadcast name, date, and cleaned HTML content. This gives you a full-text backup of the sent emails.
Step 4: Pull send stats
The task retrieves performance data for each broadcast — recipients, open rate, and click rate — and stores the values in Airtable. The Airtable record also includes the link to the backup document.
