{"product_id":"n8n-workflow-extract-lead-emails-from-websites-to-google-sheets","title":"n8n Workflow: Extract Lead Emails from Websites to Google Sheets","description":"\u003ch3\u003eExtract lead email addresses from websites and automatically update your Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow visits each lead’s website, extracts the first plausible email address from the page HTML, and writes the \u003cstrong\u003eEmail\u003c\/strong\u003e and \u003cstrong\u003eStatus\u003c\/strong\u003e back into the same \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e row—run daily or on demand.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on schedule or manually:\u003c\/strong\u003e set to run daily at \u003cstrong\u003e10:00\u003c\/strong\u003e or start it yourself.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads leads from Google Sheets:\u003c\/strong\u003e pulls rows from your specified spreadsheet (including the correct tab \u003ccode\u003egid=0\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters eligible leads:\u003c\/strong\u003e only processes leads that have a \u003cstrong\u003eWebsite\u003c\/strong\u003e value and an \u003cstrong\u003eempty Email\u003c\/strong\u003e field.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses in batches with throttling:\u003c\/strong\u003e handles leads with a pause of \u003cstrong\u003e2 seconds\u003c\/strong\u003e between sites to reduce load.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches homepage HTML:\u003c\/strong\u003e uses an \u003cstrong\u003eHTTP request\u003c\/strong\u003e to retrieve each website’s HTML.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts an email + sets status:\u003c\/strong\u003e applies pattern matching to find the first plausible email address and assigns \u003cstrong\u003eStatus\u003c\/strong\u003e based on whether an email was found.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the sheet by PlaceId:\u003c\/strong\u003e writes \u003cstrong\u003eEmail\u003c\/strong\u003e and \u003cstrong\u003eStatus\u003c\/strong\u003e back to the matching lead row using \u003cstrong\u003ePlaceId\u003c\/strong\u003e as the unique identifier.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS lead enrichment:\u003c\/strong\u003e keep your CRM-like Google Sheet current by extracting contact emails from lead websites.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSales ops automation:\u003c\/strong\u003e fill missing emails for prospect lists without manual browsing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily data hygiene:\u003c\/strong\u003e run the workflow every day to capture newly available emails while skipping rows that already have an Email.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n nodes \u0026amp; integration)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets OAuth credential\u003c\/strong\u003e for reading and updating rows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used:\u003c\/strong\u003e code, no op, wait (2 seconds), filter, sticky note, HTTP request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements:\u003c\/strong\u003e ensure your sheet includes \u003cstrong\u003eWebsite\u003c\/strong\u003e, \u003cstrong\u003eEmail\u003c\/strong\u003e, \u003cstrong\u003eStatus\u003c\/strong\u003e, and \u003cstrong\u003ePlaceId\u003c\/strong\u003e (or update the matching column in the update step).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCustomization:\u003c\/strong\u003e adjust the \u003cstrong\u003ebad-pattern filter list\u003c\/strong\u003e in the “Extract Email” code node to exclude domains specific to your niche.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45862250709171,"sku":"N8N-18312","price":70.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/FfoqgSWJuxU9K7gEgHZ7T_9WGySxmU.png?v=1786957917","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-extract-lead-emails-from-websites-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}