Automated Lead Enrichment Workflow using OpenAI & Google Sheets (Free Starter Template)

Built with n8n
1

Hi everyone! :waving_hand:

I wanted to share a workflow I’ve been experimenting with to automatically enrich leads as soon as they are added to a Google Sheet or CRM.

What this workflow does:

  1. Trigger: Listens for new rows in a Google Sheet (New Leads).

  2. AI Enrichment: Sends the lead’s company domain/name to the OpenAI / Anthropic node to generate a quick summary, company size estimate, and potential pain points.

  3. Data Update: Updates the Google Sheet row with the enriched insights and flags potential high-value prospects.

  4. Notification: Sends a Slack/Telegram notification if a lead fits our target persona.

Why I built this:

To reduce manual research time for sales outreach and speed up response times.

Questions / Feedback:

  • Has anyone tried a similar setup using Vector Databases or Web Scraping (e.g., Firecrawl) inside n8n for deeper research?

  • How do you handle rate-limiting when processing bulk rows at once?

Would love to get your thoughts, improvements, or suggestions! :rocket: