Sales Email Creator

Automatically generate personalized sales emails from company data in a spreadsheet - ready to review and send.

Stop writing outreach emails from scratch for every lead. Use this AI agent template to automatically read company information from a spreadsheet, generate personalized sales emails tailored to each company's context, and prepare them for review and sending.

Whether you're an SDR working through a prospecting list, a founder doing outbound, or a sales team scaling personalized outreach, this template generates research-backed, relevant emails for every lead in your list without manual writing.

How this template works

This agent reads lead data from a spreadsheet and generates personalized sales emails. Here's the process:

You provide a spreadsheet of leads with company information as the agent's data source.
The agent reads each company's details including name, industry, size, and any other fields you've included.
It generates a personalized sales email for each lead, incorporating the company-specific context to make the outreach relevant.
Each draft email is saved to Gmail drafts, Google Docs, or your preferred destination for review.
You review, adjust if needed, and send.

Once your Zaps are published, the workflow runs automatically - no manual steps needed.

Setup instructions

After clicking "Use template":

Connect your Google Sheets account to Zapier with your lead spreadsheet.
Connect your Gmail account or preferred email draft destination.
Configure the agent with your company's value proposition, key talking points, and email tone.
Map the spreadsheet columns to the company data fields the agent will use.
Run a test with a sample row to review the generated email before enabling for your full list.

Powered by Zapier Agents and AI

This template uses Zapier Agents to read structured lead data from a spreadsheet, apply your configured messaging framework, and generate uniquely personalized sales emails for each lead. The AI adapts the email content based on the specific company data available in each row.

Who should use this template

This template is a strong fit for:

SDRs working through prospecting lists who need personalized emails without writing each one manually
Founders doing outbound who want to scale personalized outreach without a sales team
Account executives preparing for targeted outreach campaigns to named accounts
Marketing teams running account-based outreach campaigns with personalized messaging
Sales operations teams building a scalable, systematic approach to outbound email generation

Customize and extend

This template is a starting point. You can extend it to fit your exact workflow:

Add additional columns to your spreadsheet (LinkedIn URL, recent news, funding status) for richer personalization
Configure the agent to use different email templates for different industries or company sizes
Connect to HubSpot or Salesforce to log generated emails directly on the CRM contact record
Add a Slack step to notify your team when a batch of emails is ready for review
Set up a follow-up email sequence generator for leads who don't respond to the first outreach

What's included in this template

Agent

Sales Email Creator - reads lead data and generates personalized outreach emails

Connected tools

Google Sheets - source of lead and company data
Gmail - where personalized email drafts are saved for review

Frequently asked questions

What company data should I include in my spreadsheet?

The more context the better. At minimum include company name, industry, and size. Additional fields like recent news, tech stack, funding status, or specific pain points will produce more personalized output.

Does it send the emails automatically?

No. The agent saves emails as drafts for your review. You control what gets sent, ensuring quality before any email reaches a prospect.

Can I use a different email platform besides Gmail?

Yes. You can configure the agent to save drafts to Outlook, create them in a Google Doc, or output them to any email platform available on Zapier.

How many emails can it generate at once?

The agent can process multiple rows from your spreadsheet. For large lists, you can configure batch processing or set the agent to run on new rows as they're added.

Get started in minutes

Click "Use template" to start generating personalized sales emails from your lead list. Connect your spreadsheet and Gmail, configure your messaging, and scale your outbound outreach.