Automated Company Research and Lead Enrichment — n8n, GPT-4, and Google Sheets

Trigger: New row added to Google Sheet with company name.

What this automates: Manual company research and lead enrichment for each new prospect added to a tracking sheet.

  1. New Google Sheet row with company name triggers n8n
  2. Web search run for company news and signals
  3. GPT-4 generates enrichment brief
  4. Structured output written back to Google Sheet