Quick Overview
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 invalid emails (using OpenAI to extract addresses). How it works Triggers when a lead page is updated in a selected Notion CRM database. Validates that the lead’s Email field looks like an email address and searches Gmail Sent for recent messages to that recipient to detect prior outreach. If the lead was already emailed and the current status is safe to overwrite, it updates the Notion lead status to “Emailed.” If the lead was not previously emailed, it downloads two PDF attachments from Google Drive, converts them to Gmail attachments, and either creates a Gmail draft for specific domains (optionally sending a Twilio SMS to a rep) or sends a generic vs personalized Gmail email based on whether a contact name exists. After sending, it waits briefly, searches Gmail for bounce messages mentioning “Address not found,” and updates the Notion record to “INVALID EMAIL” (or sets “Emailed” when the status indicates the lead is in an active outreach stage). In parallel, a Gmail trigger monitors incoming bounce notifications, uses OpenAI to extract the failed email address, matches it to a Notion CRM lead, and marks that lead as “INVALID EMAIL.” Setup Connect your Notion credentials and select your CRM database ID in the Notion Trigger and Notion update/get-all steps, ensuring it includes Email, Contact Name, Status, and (optionally) Notes properties. Connect your Gmail OAuth2 account and customize the email subject/body templates, including any domain rule used to route leads into draft review. Connect Google Drive OAuth2 and select the two PDF file IDs to download and attach to the Gmail draft/email. Add an OpenAI API credential and select a model for extracting the bounced email address from Gmail bounce snippets. (Optional) Connect Twilio and set the From/To phone numbers to receive an SMS when a Gmail draft is created for manual review. Align the Notion Status values used in the workflow (for example “Warm Lead,” “Interested,” “Emailed,” and “INVALID EMAIL”) with your pipeline so updates don’t overwrite critical stages. An n8n automation workflow template by Marc Soummer.
Marc Soummer
web
free
Others in the same category, ranked by how often they are opened.
