{"product_id":"n8n-lead-qualification-openai-gmail-personalized-outreach","title":"n8n Lead Qualification: OpenAI + Gmail Personalized Outreach","description":"\u003ch3\u003eQualify leads and send personalized OpenAI + Gmail outreach from Google Sheets (automatically, every day)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads your leads from Google Sheets, analyzes each target’s website with OpenAI to produce a 0–100 fit score, and then drafts or sends personalized first-contact and follow-up emails through Gmail—while writing scores, evidence, and send results back to the same sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily on a schedule:\u003c\/strong\u003e Loads configuration values such as the Google Sheet, scoring thresholds, limits, email copy, and \u003cem\u003edry-run mode\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads and cleans lead rows:\u003c\/strong\u003e Normalizes emails, suppresses opt-outs and duplicates, and routes each row to either \u003cem\u003einitial outreach\u003c\/em\u003e or \u003cem\u003efollow-up eligibility\u003c\/em\u003e checks.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eResearch + scoring with OpenAI:\u003c\/strong\u003e For new leads, fetches the company website via HTTP, extracts usable text, and sends it to OpenAI to generate a grounded company analysis with a \u003cstrong\u003e0–100 fit score\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets:\u003c\/strong\u003e Writes company analysis, evidence quotes, score breakdown, and a \u003cstrong\u003eQUALIFIED \/ UNQUALIFIED\u003c\/strong\u003e (or error) status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePersonalized outreach via Gmail:\u003c\/strong\u003e For qualified new leads, uses OpenAI to draft a first-contact email, validates it, and then either saves an \u003cstrong\u003eOUTREACH_PREVIEW\u003c\/strong\u003e (dry run) or reserves the row and sends the email via Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTracks sends + follow-ups:\u003c\/strong\u003e Records Gmail message\/thread IDs, timestamps, and follow-up due dates in Google Sheets. If outcomes are uncertain, it flags \u003cstrong\u003eSEND_REVIEW\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFollow-up automation:\u003c\/strong\u003e When contacted leads are due, reads the original Gmail thread to detect replies, drafts a single follow-up with OpenAI if no reply is found, and either saves a \u003cstrong\u003eFOLLOWUP_PREVIEW\u003c\/strong\u003e (dry run) or sends via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams qualifying inbound lead lists and automating first outreach + follow-ups.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building OpenAI-assisted lead scoring and personalized email workflows in n8n.\u003c\/li\u003e\n  \u003cli\u003eOperators who want auditable results: scores, evidence quotes, and send statuses written back to Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/nodes:\u003c\/strong\u003e Schedule Trigger, Google Sheets, HTTP Request (company website fetch), OpenAI (scoring + email drafting), Gmail (send and reply detection), plus logic nodes such as \u003cem\u003eif\u003c\/em\u003e and \u003cem\u003ecode\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow behavior:\u003c\/strong\u003e Dry-run previews for outreach\/follow-ups, daily scheduled processing, and status tracking back into Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46123202347187,"sku":"N8N-20098","price":20.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/sCdP6oc4ljbc0jcdxJasK_6qFJlTJr.png?v=1790673491","url":"https:\/\/buyflowscripts.com\/products\/n8n-lead-qualification-openai-gmail-personalized-outreach","provider":"N8N Commerce","version":"1.0","type":"link"}