Generate Personalized Gmail Outreach Drafts from Google Sheets

This automation creates and manages a personalized email outreach campaign, ensuring all communications are on-brand and compliant. Here’s how it works:

• Connects to Your Data: The automation starts by reading lead information from a specified Google Sheet. It's designed to work with two tabs: one for individual leads (e.g., 'people') and an optional one for company details (e.g., 'companies').
• Qualifies Leads: It intelligently filters your lead list, processing only those who are ready for outreach. You can set rules to skip leads based on their status, a minimum qualification score, or whether their email address has been verified.
• Consults Your Knowledge Base: Before writing, the automation consults two of your Knowledge Base documents. The first is a Campaign Brief containing the approved subject line, body copy, and compliance rules. The second is a Tone of Voice guide to ensure the AI's writing style matches your brand.
• Generates Personalized AI Copy: Using the information from your Google Sheet and Knowledge Base, an AI model generates a unique email for each lead. It personalizes the message by filling in placeholders like {{first_name}} and {{company_name}} while strictly adhering to the constraints you've defined.
• Creates Gmail Drafts: The personalized email is saved as a draft in your Gmail account. This gives you a chance to review, approve, or make final tweaks before sending. You can also configure the automation to send emails directly.
• Updates Your Sheet: Finally, it updates the Google Sheet, marking the lead's status as 'drafted' and saving a copy of the generated subject and body for your records. This creates a closed-loop system for tracking outreach.

Usage Ideas

• Automate Sales Prospecting: Run scalable cold outreach campaigns to a list of prospects, ensuring each email is personalized and on-brand.
• Send Event Follow-ups: After a conference or webinar, use a list of attendees to send personalized follow-up messages by receiving attendee data through a webhook, n8n, Make, or Zapier event.
• Announce New Products: Launch a targeted marketing campaign to introduce a new product or feature to a segmented list of customers.
• Re-engage Dormant Leads: Create a re-engagement campaign to connect with old leads who have gone cold, using a fresh, personalized offer.

Customization Ideas

This template provides a powerful foundation for your outreach that you can easily tailor to your specific needs. You can:

• Use Your Own Lead List: Connect any Google Sheet by simply providing its URL.
• Define Your Sheet's Structure: Customize the names of the tabs and the column headers the automation uses to find lead and company data.
• Control the Message: Provide your own Campaign Brief and Tone of Voice documents from your Knowledge Base. This gives you full control over the email's content, structure, and style.
• Customize the AI's Instructions: Modify the core AI prompt to define the target audience, product details, and specific "do's and don'ts" for email generation.
• Set Your Own Rules: Adjust the qualification criteria for leads, such as requiring a minimum score or a verified email address, to ensure you're only contacting the best prospects.
• Choose Your Workflow: Decide whether to save emails as drafts in Gmail for a final human review or to have the automation send them immediately.
• Manage Outreach Volume: Set a limit on how many emails are generated in each run, allowing you to scale your campaign at a comfortable pace.