Generate Personalized Cold Outreach Emails with Apify, OpenAI, and Google Sheets

This workflow automates the creation of highly personalized cold outreach emails for sales, marketing, and business development. It starts by generating batches of leads, scrapes comprehensive data including contacts, company info, and social links using Apify. It then fetches client details from Google Sheets, scrapes the company website for content, and uses OpenAI to summarize prospect data and identify unique outreach angles.

Next, advanced OpenAI models craft key email components: icebreaker, intro, and value proposition, tailored to each lead. Finally, it updates the Google Sheet with these components, enriching lead records for seamless outreach campaigns. Requires a Google Sheet with columns: Email, Full Name, Headline, LinkedIn.

Benefits include massive time savings on manual research and writing, higher response rates from genuine personalization, and scalability for hundreds of leads. Perfect for B2B sales teams, agencies, or solopreneurs aiming to boost conversion without generic templates.