n8n Lead Enrichment: OpenAI + NewsAPI + Gmail + Sheets

Automatically 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.

This n8n workflow, n8n Lead Enrichment: OpenAI + NewsAPI + Gmail + Sheets, 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.

What this workflow does

• Captures inbound submissions from your website using an n8n Form trigger.
• Normalizes and scores the lead: cleans the submitted website domain and assigns a Hot/Warm/Cold score based on job title keywords.
• Validates required inputs before enrichment.
• Enriches with recent company news by querying NewsAPI and compiling a short research brief.
• Generates company intelligence + outreach draft using OpenAI Chat Completions, returning structured JSON (subject + body) for personalized outreach.
• Logs the enriched lead to a Google Sheets spreadsheet (append to the “leads” tab), including score, news summary, and the outreach draft.
• Emails the sales rep an HTML summary via Gmail with all key details for review.
• Error handling: if any step fails, it sends a Gmail error alert containing the error message, failed node name, and execution ID.

Use cases

• Fast-turn inbound lead qualification for SaaS teams using n8n automation.
• Personalized sales outreach powered by current company news.
• Centralized lead tracking in Google Sheets with an AI-ready email draft.

Technical details

• n8n nodes/workflow parts: Code, Form trigger, HTTP Request, OpenAI (Chat Completions), Google Sheets, Gmail, Error trigger (plus a Sticky Note for guidance).
• Integrations: OpenAI API credentials, NewsAPI key (set in the HTTP request header), Google Sheets OAuth, and Gmail for notifications.

Setup required: configure OpenAI and NewsAPI credentials, provide your Google Sheets Spreadsheet ID, and ensure a spreadsheet with a “leads” tab and the required columns.