Generate personalized cold outreach emails with Apify, OpenAI, and Google Sheets

Automated Cold Email Personalization

This workflow automates the creation of highly personalized cold outreach emails by extracting lead data, scraping company websites, and leveraging AI to craft unique email components. This is ideal for sales teams, marketers, and business development professionals looking to scale their outreach efforts while maintaining a high degree of personalization.

---

How It Works

1. Generate Batches: The workflow starts by generating a sequence of numbers, defining how many leads to process in batches. 2. Scrape Lead Data: It uses an external API (Apify) to pull comprehensive lead information, including contact details, company data, and social media links. 3. Fetch Client Data: The workflow then retrieves relevant client details from your Google Sheet based on the scraped data. 4. Scrape Company Website: The lead's company website is automatically scraped to gather content for personalization. 5. Summarize Prospect Data: An OpenAI model analyzes both the scraped website content and the individual's profile data to create concise summaries and identify unique angles for outreach. 6. Craft Personalized Email: A more advanced OpenAI model uses these summaries and specific instructions to generate the "icebreaker," "intro," and "value proposition" components of a personalized cold email. 7. Update Google Sheet: Finally, these generated email components are saved back into your Google Sheet, enriching your lead records for future outreach.

---

Google Sheet Structure

Your Google Sheet must have the following exact column headers to ensure proper data flow: