This n8n workflow turns website contact form submissions into sales-ready lead records. It pulls recent company news from NewsAPI and uses OpenAI to generate company intelligence and a personalized outreach draft. The enriched lead is logged to Google Sheets, and a formatted HTML summary is emailed to a sales rep through Gmail.
A Form trigger captures each inbound submission. The workflow cleans the submitted website domain and assigns a Hot, Warm or Cold score based on job title keywords. It validates required inputs before enrichment, then compiles a short research brief from the news results. OpenAI Chat Completions returns structured JSON with an email subject and body for the outreach draft.
If any step fails, the workflow sends a Gmail error alert. The alert includes the error message, the failed node name and the execution ID.
- Trigger
- n8n Form trigger for website contact form submissions
- Lead scoring
- Hot, Warm or Cold, based on job title keywords
- News source
- NewsAPI, queried through an HTTP Request node
- AI output
- Company intelligence and an outreach email draft (subject and body) as structured JSON
- Logging
- Appends to the "leads" tab in Google Sheets, including score, news summary and outreach draft
- Notification
- HTML summary emailed to the sales rep via Gmail
- Error handling
- Gmail alert with error message, failed node name and execution ID
- n8n nodes
- Code, Form trigger, HTTP Request, OpenAI (Chat Completions), Google Sheets, Gmail, Error trigger, Sticky Note
- Integrations
- OpenAI API, NewsAPI (key set in the HTTP request header), Google Sheets OAuth, Gmail
- Setup
- Configure OpenAI and NewsAPI credentials, enter your Google Sheets Spreadsheet ID, and prepare a spreadsheet with a "leads" tab and the required columns
- Use cases
- Inbound lead qualification for SaaS teams, personalized outreach based on current company news, centralized lead tracking in Google Sheets