{"product_id":"enrich-google-sheets-leads-with-gemini-web-crawling-in-n8n","title":"Enrich Google Sheets Leads with Gemini + Web Crawling in n8n","description":"\u003ch3\u003eEnrich Google Sheets leads automatically by crawling company websites and extracting details with Google Gemini in n8n\u003c\/h3\u003e\n\u003cp\u003eIf you maintain a lead list in Google Sheets, this workflow helps you turn an email address into a verified company website, crawl the site content, and then use \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to extract structured business information—writing the enriched fields back to your sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand\u003c\/strong\u003e (manual execution).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads Google Sheets rows\u003c\/strong\u003e and processes only the entries where the \u003cem\u003eEnrichment\u003c\/em\u003e column matches your configured filter.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDerives a website from each lead’s email\u003c\/strong\u003e (derives the company domain, builds a website URL).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCrawls the website\u003c\/strong\u003e via an \u003cstrong\u003eHTTP endpoint\u003c\/strong\u003e that returns cleaned HTML\/markdown. If the crawl errors, the workflow marks the row in Google Sheets accordingly.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Google Gemini for structured extraction\u003c\/strong\u003e from the cleaned content to obtain fields such as:\n    \u003cul\u003e\n      \u003cli\u003ecompany name\u003c\/li\u003e\n      \u003cli\u003eVAT number\u003c\/li\u003e\n      \u003cli\u003eaddress, city, state\u003c\/li\u003e\n      \u003cli\u003ephone\u003c\/li\u003e\n      \u003cli\u003esocial links\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies the business sector\u003c\/strong\u003e and generates an \u003cstrong\u003eItalian description\u003c\/strong\u003e from the markdown.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMerges results and updates the original row\u003c\/strong\u003e with the enriched fields (including sector, description, and website), then \u003cstrong\u003ewaits 60 seconds\u003c\/strong\u003e before continuing with the next batch.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses in batches of 10\u003c\/strong\u003e to keep execution controlled.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eUpdate B2B lead records in Google Sheets with company website, contact details, and VAT\/address data.\u003c\/li\u003e\n  \u003cli\u003eAuto-generate sector classification and Italian company summaries for sales enablement.\u003c\/li\u003e\n  \u003cli\u003eEnrich newly imported leads using only the email field—reducing manual research time.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e Set, Wait, Merge, Sticky Note, HTTP Request, Google Sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (OAuth) + \u003cstrong\u003eGoogle Gemini (PaLM) API\u003c\/strong\u003e for extraction\/classification\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow behavior:\u003c\/strong\u003e batch processing (10 rows), crawl via HTTP endpoint, update enriched columns back into the sheet\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eBuilt for n8n users, automation engineers, and SaaS operators who need reliable, SEO-relevant lead enrichment using web crawling and Gemini.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45916231893171,"sku":"N8N-18827","price":57.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/CpCHy9gjtTTPkyob411mc_SkHkRUAG.png?v=1788012707","url":"https:\/\/buyflowscripts.com\/products\/enrich-google-sheets-leads-with-gemini-web-crawling-in-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}