- Home
- Skills
- Sales & Lead Gen
- Follow Up Email Drafting
Follow Up Email Drafting
Automated personalized email drafting from CSV/Excel sheets with a Word-based review and approval workflow.
Free
Works with the AI Agents you already use
Follow Up Email Drafting
Example session with this skill installed
I have a list of people I met at the 'TechExpo 2024' in tech_leads.csv. Use the follow_up.txt template to draft emails from me, Alex at DevSystems. Skip anyone I've already emailed.
- Read your context and instructions
- Compiled the follow up email
- Generated the data export
I have inspected tech_leads.csv and found 12 contacts labeled 'TechExpo 2024' with a status of 'New'. I have generated the drafts and a review document.
Outreach Drafts Summary
| Metric | Count |
|---|---|
| Contacts Found | 12 |
| Drafts Created | 10 |
| Skipped (Missing Email) | 1 (John Doe) |
| Skipped (Duplicate) | 1 (Sarah Smith) |
Sample Draft (ID: 1)
To: julia.v@innovate.io
Subject: Great meeting you at TechExpo 2024
Body:
Hi Julia,
It was a pleasure meeting you at TechExpo 2024. I enjoyed our conversation about DevSystems and how we are approaching backend scaling.
I'd love to continue our discussion when you have a moment next week.
Best regards,
Alex
DevSystems
I have saved the full set of drafts to drafts.csv and created drafts_review.docx for your review.
Next steps
- Open
drafts_review.docxto proofread the 10 generated emails. - Tell me which IDs to approve (e.g., "Approve all" or "Approve all except 4").
- Confirm if you want me to sync these to your Gmail drafts folder or if you will send them manually.
tech_leads.csv
CSV · data export
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
About this skill
Manual follow-up is slow, and bulk mailers feel like spam. This skill manages the delicate gap between a raw contact list and a personalized inbox. It takes your event spreadsheets or business card exports and generates individual, tailored drafts for review.
What it does
- Parses contact sheets by reading
.csvor.xlsxfiles and mapping columns like Name, Company, and Email. - Filters by segment to target specific groups, such as leads from a specific networking event or trade fair.
- Generates personalized drafts using a template engine that skips contacts with missing data to avoid embarrassing "Hi [Name]" errors.
- Produces review files in Word format so you can proofread every message on a single page before anything is sent.
- Manages approval states by tracking which drafts are cleared for sending and blocking any that were modified after approval.
- Synchronizes status by marking contacts as "Emailed" in your master sheet once the process is complete.
How it works
- Identify the source by pointing the agent to your contacts file and specifying the target group or label.
- Configure the template using standard placeholders like
{{First Name}}or custom tags for event-specific context. - Execute the draft script to create a reviewable
.docxfile and a tracking.csvrecord. - Approve and send by authorizing the agent to push drafts to your connected mail tool or by performing a manual mail merge.
Frameworks & tools
Python 3.9+, openpyxl for Excel support, and your preferred mail connector (Gmail, Outlook).
Why this beats prompting it yourself
Generic prompts often hallucinate details or fail to handle large batches reliably. This skill uses local Python scripts to ensure data integrity, enforces a strict approval gate, and maintains a log to prevent duplicate emails if a run is interrupted.
Use cases
- Following up with leads collected at a specific conference or trade show.
- Drafting personalized introduction emails for a new segment of prospects.
- Preparing a refined mail merge source for high-stakes outreach.
- Moving scanned business card data into a verified outreach workflow.
Known limitations
Requires a Python environment to run the underlying scripts. The skill does not support HTML email formatting or automated attachments.
Requires Python 3.9 and openpyxl for .xlsx files. Only produces plain text emails. Sending requires a pre-connected mail tool; it cannot send via SMTP directly.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Free forever
No account required to browse
Trust & safety
Security scan
Security scan passed 3 days ago
- Free with an Agensi account
Requires