Templates / Send CRM lead outreach emails with Notion, Gmail, Google Drive and OpenAI

Send CRM lead outreach emails with Notion, Gmail, Google Drive and OpenAI

Ready for 3.0

by Marc Soummer ✓ · 42 views · created 2026-07-18 · Lead Nurturing, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 32 nodes and runs on Notion events (paged updated in database) (plus 1 other trigger). Along the way it connects Notion, Gmail, Google Drive and Twilio and 1 more.

How it runs

Trigger: On Notion events (paged updated in database) (plus 1 other trigger).

  1. Check Valid Email Format (If): checks a condition and branches into true / false
  2. If: checks a condition and branches into true / false
  3. Fetch Sent Mail from Account (Gmail): get many
  4. Fetch Sent Mail from Account (Gmail): get many
  5. Extract Bounced Email Address (OpenAI): uses OpenAI
  6. Merge: merges the data from its input branches
  7. Fetch All CRM Leads (Notion): get many (database page)
  8. Flag as Previously Emailed (Code): runs custom JavaScript code
  9. Find Matching Bounced Lead (If): checks a condition and branches into true / false
  10. If: checks a condition and branches into true / false

…plus 20 more steps. See the full node list below.

Services it uses

NotionGmailGoogle DriveTwilioOpenAI

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (11)

From the author

Quick Overview This workflow watches a Notion CRM for leads ready to contact, checks Gmail to avoid duplicate outreach, then sends or drafts an email with Google Drive PDF attachments and updates the lead status in Notion, with bounce detection that marks…

Excerpt from Marc Soummer's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.