The Rundown: Create a Zapier agent that automatically researches companies from your spreadsheet and drafts personalized sales emails, saving hours of manual outreach work.

🧰 Who is this useful for:

• Sales professionals managing large lead lists
• Business development teams scaling their outreach efforts
• Entrepreneurs looking to automate their sales pipeline
• Marketing teams personalizing email campaigns

STEP 1: Create Your Sales Agent

Navigate to Zapier and select "New Agent" from the dashboard. Choose "Create a custom agent" to build from scratch rather than using a template. This gives you full control over the agent's behavior and instructions.

Name your agent something descriptive like "Sales Email Agent" and set the trigger to "On demand" so you can control when the automation runs rather than having it trigger automatically.

STEP 2: Write Detailed Instructions

In the instructions section, provide clear step-by-step guidance for your agent. Here's an effective framework:

"For each row in the spreadsheet, do the following steps:

1. Search the provided company for information about it
2. Use the name and email from the spreadsheet to populate the contact information
3. Use information gathered from the website and any available details about the contact to draft an email
4. Generate the body and subject for the email based on the information obtained"

Include your preferred email format with placeholders like: "Hey [Contact Name], Just checked out your platform and I'm impressed with [specific feature or achievement]. I'd love to connect and explore how our product could help you unlock more potential."

STEP 3: Connect Your Data Source

Click "Insert Tools" and select "Add tools from 7,000+ apps." Search for Google Sheets and choose "Data Integration (optimized for AI search)." Connect your Google account and select the specific spreadsheet containing your leads.

Make sure your spreadsheet has columns for company name, contact name, and email address at minimum. The agent will use this data to personalize each outreach email.

STEP 4: Set Up Email Integration

Insert another tool by clicking "Insert Tools" again and search for Gmail. Select "Create Draft" rather than "Send Email" - this allows you to review each generated email before sending.

Connect your Gmail account when prompted. The agent will create drafts in your Gmail that you can review, edit if needed, and send manually for maximum control over your outreach.

Click "Test Agent" to run a trial with your spreadsheet data. The agent will process each row, research the companies online, and create personalized email drafts based on the information it finds.

Pro tip: Start with a small test batch of 5-10 leads to fine-tune your instructions and email template before processing larger lead lists.