n8n Workflow: Enrich Google Sheets Leads with OpenAI Agent

Enrich your Google Sheets lead list automatically with an OpenAI-powered agent

This production-ready n8n workflow pulls companies from Google Sheets, scrapes/reads relevant web content, and uses an OpenAI agent to deduce key business details—then writes the enriched results back into your spreadsheet.

What this workflow does

• Triggers via Webhook (Node 1): A Webhook call starts the workflow. You can replace this trigger with another option like form submission, new Google Sheets row, or a manual trigger.
• Reads companies from Google Sheets (Node 2): It fetches your company list from a provided Google Sheet template. The sheet requires these fields at minimum:
  • Company
  • Website
• Enriches using OpenAI: The workflow scrapes data from the companies’ websites and uses OpenAI to deduce:
  • Business Area
  • Offer
  • Value Proposition
  • Business Model

Important: The workflow involves scraping. Check the legal regulations around scraping in your country before running it. Also monitor OpenAI token usage—costs can add up quickly.

Use cases

• Turn a basic lead list (Company + Website) into enriched prospects for SaaS sales and outreach.
• Automatically research competitors and populate an n8n automation pipeline with business insights.
• Maintain a continuously updated prospect spreadsheet without manual research.

Technical details

• Trigger: Webhook
• Data source: Google Sheets (template provided in the workflow)
• Core nodes / components: Set, Webhook, HTTP Request, Markdown, and supporting nodes like Sticky Note
• Purpose: enrich rows with OpenAI-deduced business attributes

While the workflow is production-ready when all steps are followed, adding error handling is recommended to enhance robustness.