{"product_id":"n8n-lead-enrichment-openai-newsapi-gmail-sheets","title":"n8n Lead Enrichment: OpenAI + NewsAPI + Gmail + Sheets","description":"\u003ch3\u003eAutomatically enrich every new inbound lead with company news, AI-generated intelligence, and a ready-to-send outreach email—then log it to Google Sheets and notify sales via Gmail.\u003c\/h3\u003e\n\n\u003cp\u003eThis n8n workflow, \u003cstrong\u003en8n Lead Enrichment: OpenAI + NewsAPI + Gmail + Sheets\u003c\/strong\u003e, turns website contact form submissions into actionable sales-ready lead records. It pulls recent company news using NewsAPI, generates structured company intelligence and a personalized outreach draft with OpenAI, stores everything in Google Sheets, and emails a formatted HTML summary to your sales rep.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCaptures inbound submissions\u003c\/strong\u003e from your website using an n8n \u003cem\u003eForm trigger\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and scores the lead\u003c\/strong\u003e: cleans the submitted website domain and assigns a \u003cstrong\u003eHot\/Warm\/Cold\u003c\/strong\u003e score based on job title keywords.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates required inputs\u003c\/strong\u003e before enrichment.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches with recent company news\u003c\/strong\u003e by querying \u003cstrong\u003eNewsAPI\u003c\/strong\u003e and compiling a short research brief.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates company intelligence + outreach draft\u003c\/strong\u003e using \u003cstrong\u003eOpenAI Chat Completions\u003c\/strong\u003e, returning structured JSON (subject + body) for personalized outreach.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs the enriched lead\u003c\/strong\u003e to a Google Sheets spreadsheet (append to the \u003cstrong\u003e“leads”\u003c\/strong\u003e tab), including score, news summary, and the outreach draft.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails the sales rep an HTML summary\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e with all key details for review.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError handling:\u003c\/strong\u003e if any step fails, it sends a Gmail error alert containing the \u003cstrong\u003eerror message\u003c\/strong\u003e, \u003cstrong\u003efailed node name\u003c\/strong\u003e, and \u003cstrong\u003eexecution ID\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFast-turn inbound lead qualification for SaaS teams using n8n automation.\u003c\/li\u003e\n  \u003cli\u003ePersonalized sales outreach powered by current company news.\u003c\/li\u003e\n  \u003cli\u003eCentralized lead tracking in Google Sheets with an AI-ready email draft.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/workflow parts:\u003c\/strong\u003e Code, Form trigger, HTTP Request, OpenAI (Chat Completions), Google Sheets, Gmail, Error trigger (plus a Sticky Note for guidance).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e OpenAI API credentials, NewsAPI key (set in the HTTP request header), Google Sheets OAuth, and Gmail for notifications.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup required:\u003c\/strong\u003e configure OpenAI and NewsAPI credentials, provide your Google Sheets Spreadsheet ID, and ensure a spreadsheet with a \u003cstrong\u003e“leads”\u003c\/strong\u003e tab and the required columns.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45764324327603,"sku":"N8N-17853","price":18.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7EGdnVNrHjumCBvR8B1oZ_awJKFp5x.png?v=1786007352","url":"https:\/\/buyflowscripts.com\/products\/n8n-lead-enrichment-openai-newsapi-gmail-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}