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.

n8nRead on 2026-11-166 steps

Steps

  1. Trigger: Receives a website contact submission via n8n formn8n Form
  2. Normalizes fields and assigns a lead score
    Hot/Warm/Cold from job title keywords.
  3. Queries NewsAPI for recent company articlesNewsAPI
  4. Sends the lead context to OpenAIOpenAI
    Company intelligence and an outreach email in JSON.
  5. Output: Appends the enriched lead to Google SheetsGoogle Sheets
  6. 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