{"product_id":"n8n-workflow-enrich-google-sheets-leads-with-openai-agent","title":"n8n Workflow: Enrich Google Sheets Leads with OpenAI Agent","description":"\u003ch3\u003eEnrich your Google Sheets lead list automatically with an OpenAI-powered agent\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers via Webhook\u003c\/strong\u003e (Node 1): A \u003cem\u003eWebhook\u003c\/em\u003e call starts the workflow. You can replace this trigger with another option like form submission, new Google Sheets row, or a manual trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads companies from Google Sheets\u003c\/strong\u003e (Node 2): It fetches your company list from a provided Google Sheet template. The sheet requires these fields at minimum:\n    \u003cul\u003e\n      \u003cli\u003e\u003cstrong\u003eCompany\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eWebsite\u003c\/strong\u003e\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches using OpenAI\u003c\/strong\u003e: The workflow scrapes data from the companies’ websites and uses OpenAI to deduce:\n    \u003cul\u003e\n      \u003cli\u003e\u003cstrong\u003eBusiness Area\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eOffer\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eValue Proposition\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eBusiness Model\u003c\/strong\u003e\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eImportant:\u003c\/strong\u003e 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.\u003c\/p\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTurn a basic lead list (Company + Website) into enriched prospects for \u003cstrong\u003eSaaS\u003c\/strong\u003e sales and outreach.\u003c\/li\u003e\n  \u003cli\u003eAutomatically research competitors and populate an \u003cstrong\u003en8n automation\u003c\/strong\u003e pipeline with business insights.\u003c\/li\u003e\n  \u003cli\u003eMaintain a continuously updated prospect spreadsheet without manual research.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrigger:\u003c\/strong\u003e Webhook\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData source:\u003c\/strong\u003e Google Sheets (template provided in the workflow)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore nodes \/ components:\u003c\/strong\u003e \u003cem\u003eSet\u003c\/em\u003e, \u003cem\u003eWebhook\u003c\/em\u003e, \u003cem\u003eHTTP Request\u003c\/em\u003e, \u003cem\u003eMarkdown\u003c\/em\u003e, and supporting nodes like \u003cem\u003eSticky Note\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePurpose:\u003c\/strong\u003e enrich rows with OpenAI-deduced business attributes\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eWhile the workflow is production-ready when all steps are followed, adding error handling is recommended to enhance robustness.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45764332060851,"sku":"N8N-2463","price":42.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/wzQz1t9QmahJVTR0MR1Fg_fiss6JAo.png?v=1786007605","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-enrich-google-sheets-leads-with-openai-agent","provider":"N8N Commerce","version":"1.0","type":"link"}