Form leads enriched with NewsAPI
Adds company news and an OpenAI outreach draft to form leads. This n8n template captures website contact submissions through an n8n Form trigger. It normalizes the fields, extracts the website domain and assigns a Hot, Warm or Cold score from job title keywords. After validation, it queries NewsAPI for recent articles about the company and builds a short research brief. OpenAI Chat Completions returns company intelligence and an outreach email subject and body in JSON. The enriched lead is appended to a Google Sheets leads tab, and the sales rep receives a Gmail message with the lead details and the outreach draft to review. It suits sales teams that answer website contact forms.
Steps
- Trigger: Receives a website contact submission via n8n formn8n Form
- Normalizes fields and assigns a lead score
Hot/Warm/Cold from job title keywords. - Queries NewsAPI for recent company articlesNewsAPI
- Sends the lead context to OpenAIOpenAI
Company intelligence and an outreach email in JSON. - Output: Appends the enriched lead to Google SheetsGoogle Sheets
- Output: Sends the sales rep a Gmail messageGmail
Limits
- Needs a NewsAPI key in the HTTP request header.
- The Hot, Warm or Cold score comes from job title keywords, not from the AI step.
What it does well
- The outreach draft goes to the sales rep for review.
- Sends an error alert by Gmail when a step fails.
Before you import
After the import, add OpenAI, Google Sheets and Gmail credentials and a NewsAPI key, then embed the n8n Form on your contact page.
Similar templates
Hot lead alerts in Slack from a form
Also for sales and leads, 6 steps.
Lead scoring with Apify company data
Also for sales and leads, 4 steps.
Sales meeting prep sent to WhatsApp
Also for sales and leads, 5 steps.
Gmail and OpenAI: 29 templates compared
Same two apps, different steps.
Google Sheets and OpenAI: 24 templates compared
Same two apps, different steps.
Gmail and Google Sheets: 22 templates compared
Same two apps, different steps.
Gmail and n8n Form: 6 templates compared
Same two apps, different steps.
Google Sheets and n8n Form: 6 templates compared
Same two apps, different steps.
n8n Form and OpenAI: 5 templates compared
Same two apps, different steps.
NewsAPI and OpenAI: 2 templates compared
Same two apps, different steps.
Capture a lead
Other templates that do this task.