Send CRM lead outreach emails with Notion, Gmail, Google Drive and OpenAI
Ready for 3.0What 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).
- Check Valid Email Format (If): checks a condition and branches into true / false
- If: checks a condition and branches into true / false
- Fetch Sent Mail from Account (Gmail): get many
- Fetch Sent Mail from Account (Gmail): get many
- Extract Bounced Email Address (OpenAI): uses OpenAI
- Merge: merges the data from its input branches
- Fetch All CRM Leads (Notion): get many (database page)
- Flag as Previously Emailed (Code): runs custom JavaScript code
- Find Matching Bounced Lead (If): checks a condition and branches into true / false
- If: checks a condition and branches into true / false
…plus 20 more steps. See the full node list below.
Services it uses
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)
- Notion Trigger
n8n-nodes-base.notionTrigger - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Notion
n8n-nodes-base.notion - Google Drive
n8n-nodes-base.googleDrive - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - Wait
n8n-nodes-base.wait - Twilio
n8n-nodes-base.twilio - Gmail Trigger
n8n-nodes-base.gmailTrigger - OpenAI
@n8n/n8n-nodes-langchain.openAi
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…