Automation library · Lead generation

Send CRM lead outreach emails with Notion and Gmail

Started by an arriving email, and works across Gmail, Google Drive, Notion and Twilio. It hands the judgement calls to OpenAI. 32 steps, 9 branches, 2 loops or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

Download free
32 stepsLarge: read it before trusting it with anything live
9Branches: places the flow splits
2Loops or waits
4Services it connects to

The flow

Starts it 2Model 1Logic 15Service 14

The steps in the order they run, from what starts it.

  1. 1When CRM Lead Added to NotionNotion triggerStarts it
  2. 2When Gmail Bounce DetectedGmail triggerStarts it
  3. 3Check Valid Email FormatIfLogic
  4. 4If Bounce Notification ExistsIfLogic
  5. 5Fetch Sent Mail from Account 3GmailService
  6. 6Fetch Sent Mail from AccountGmailService
  7. 7Extract Bounced Email AddressOpen AiModel
  8. 8Merge Sent Emails ResultsMergeLogic
  9. 9Fetch All CRM LeadsNotionService
  10. 10Flag as Previously EmailedCodeLogic
  11. 11Find Matching Bounced LeadIfLogic
  12. 12If Previously EmailedIfLogic
  13. 13Update Notion for Bounced LeadNotionService
  14. 14Process Already Emailed LeadIfLogic
  15. 15Wait 7 SecondsWaitLogic
  16. 16Update Notion for Already EmailedNotionService
  17. 17Download Proposal PDF from DriveGoogle DriveService
  18. 18Download Specs PDF from Google DriveGoogle DriveService
  19. 19Merge Attachment PDFsMergeLogic
  20. 20Convert to Attachment BinariesCodeLogic
  21. 21Check Draft Review DomainIfLogic
  22. 22Create Gmail Draft for ApprovalGmailService
  23. 23Determine Contact NameIfLogic
  24. 24Notify Rep via TwilioTwilioService
  25. 25Send Generic Email via GmailGmailService
  26. 26Send Personalized Email via GmailGmailService
  27. 27Wait for Bounce NotificationWaitLogic
  28. 28Fetch Bounce Emails in GmailGmailService
  29. 29If Bounce DetectedIfLogic
  30. 30Update Notion for Invalid EmailNotionService
  31. 31If Can Update Lead StatusIfLogic
  32. 32Update Notion for Emailed LeadNotionService

How it's built

Starts on
An arriving email
Steps
32, with 9 branches, 2 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Drive, Notion, Twilio
Model
OpenAI

Questions

What does it need to run?

An n8n account, plus your own Gmail, Google Drive, Notion and Twilio accounts, and a key for OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on an arriving email.

Does it use AI?

Yes. It calls OpenAI. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 32 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 32 steps before you point it at anything that matters.