Follow Up Email Drafting

    1

    Automated personalized email drafting from CSV/Excel sheets with a Word-based review and approval workflow.

    Free

    Security scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    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

    MetricCount
    Contacts Found12
    Drafts Created10
    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

    1. Open drafts_review.docx to proofread the 10 generated emails.
    2. Tell me which IDs to approve (e.g., "Approve all" or "Approve all except 4").
    3. 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

    Generated

    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 .csv or .xlsx files 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

    1. Identify the source by pointing the agent to your contacts file and specifying the target group or label.
    2. Configure the template using standard placeholders like {{First Name}} or custom tags for event-specific context.
    3. Execute the draft script to create a reviewable .docx file and a tracking .csv record.
    4. 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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 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

    Python

    Permissions

    Terminal / Shell
    Read Files
    Write Files
    Listed3 days ago

    What's inside

    Frequently Asked Questions

    This skill bridges the gap between bulk automation and manual writing by generating personalized drafts based on your spreadsheet data and consolidating them into a single Word document for a quick, one-page review.

    The purchase includes the core Python scripts, pre-configured email templates, and a detailed setup guide to help you connect your CSV/Excel files to your mail provider.

    The skill uses a validation script that automatically skips any contacts missing essential fields like 'First Name' or 'Email,' preventing embarrassing placeholder errors in your outreach.

    Yes, you will need a Python 3.9+ environment installed on your machine, along with the `openpyxl` library to process Excel files and a connection to your Gmail or Outlook account.

    While the skill generates the drafts and manages the approval state, you maintain final control; the agent will only push messages to your mail tool once you have reviewed the generated Word document.

    New in Sales & Lead Gen