Autonomous Apollo Lead Outreach n8n: OpenAI + Gmail + Sheets

Autonomous Apollo Lead Outreach: daily cold emails powered by OpenAI, Gmail, Sheets, and reply intent handling

This n8n workflow automatically finds fresh leads in Apollo, generates personalized cold outreach using OpenAI (gpt-4o-mini) with recent company context, sends emails via Gmail, and then intelligently processes incoming replies—updating Google Sheets and optionally scheduling meetings on Google Calendar.

What this workflow does

• Runs daily to apply your ICP filters and search Apollo for matching prospects.
• Splits results into individual leads and checks Google Sheets to avoid emailing prospects already tracked in your CRM sheet.
• Enriches each new lead using the Apollo Organizations Enrich endpoint, then pulls recent company news via the Serper news search API.
• Drafts personalized cold email copy by sending lead + news research context to OpenAI (gpt-4o-mini), then sends the email through Gmail and logs the lead to Google Sheets.
• Monitors Gmail replies for new unread messages, finds the sender in Google Sheets, and uses OpenAI to classify reply intent.
• Routes replies by intent: create a Google Calendar meeting and send a confirmation email, send an answer for questions, or update lead status in Google Sheets for “not interested” and other outcomes.

Use cases

• Daily SaaS prospecting: automatically outreach to new Apollo leads matched to your ICP.
• CRM-aligned lead tracking: prevent duplicate emails by checking Google Sheets before sending.
• Lower response handling time: automatically classify reply intent and update lead status or schedule calls.

Technical details

• Integrations/credentials: Apollo (HTTP headers), Serper (X-API-KEY header), OpenAI, Gmail OAuth2, Google Sheets OAuth2, and Google Calendar OAuth2.
• Core n8n nodes mentioned: if, set, code, gmail, switch, split out.
• Key setup step: add/replace placeholders like YOUR_APOLLO_API_KEY and YOUR_SERPER_API_KEY, and configure Gmail settings (including the sendTo value).