{"product_id":"n8n-workflow-extract-business-directory-listings-to-google-sheets","title":"n8n Workflow: Extract Business Directory Listings to Google Sheets","description":"\u003ch3\u003eAutomatically extract business directory listings into Google Sheets (daily)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls business-directory listing URLs from Google Sheets, captures fully rendered pages with \u003cstrong\u003eSnapshot Site\u003c\/strong\u003e, uses \u003cstrong\u003eOpenAI (n8n Information Extractor)\u003c\/strong\u003e to extract structured business records, and writes the results back to your sheet—while logging any capture or extraction failures.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 12 PM\u003c\/strong\u003e using a scheduled trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads input URLs\u003c\/strong\u003e from the \u003cstrong\u003e“Directory Sources”\u003c\/strong\u003e tab in your Google Sheets spreadsheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses URLs one at a time\u003c\/strong\u003e to fetch data reliably and steadily.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCaptures fully rendered HTML\u003c\/strong\u003e for each directory page via \u003cstrong\u003eSnapshot Site\u003c\/strong\u003e, routing API errors to an error-log flow.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCleans captured HTML\u003c\/strong\u003e by removing scripts\/styles and trimming content before extraction.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts structured listings\u003c\/strong\u003e by sending the cleaned HTML to \u003cstrong\u003eOpenAI through n8n’s Information Extractor\u003c\/strong\u003e, returning an array of business records.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites to “Businesses” tab\u003c\/strong\u003e by splitting extracted businesses into rows and \u003cstrong\u003eappending\/updating\u003c\/strong\u003e while \u003cstrong\u003ededuplicating by directoryUrl\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs failures\u003c\/strong\u003e by appending capture\/extraction errors to the \u003cstrong\u003e“Extraction Errors”\u003c\/strong\u003e tab and continuing with remaining URLs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuild and refresh a \u003cstrong\u003elead database\u003c\/strong\u003e from multiple business directory sources on a schedule.\u003c\/li\u003e\n  \u003cli\u003eMaintain a clean \u003cstrong\u003eGoogle Sheets CRM\u003c\/strong\u003e by deduplicating results using \u003cstrong\u003edirectoryUrl\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eContinuously audit directory pages by tracking errors in \u003cstrong\u003e“Extraction Errors”\u003c\/strong\u003e for failed captures\/extractions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSnapshot Site\u003c\/strong\u003e: uses the community node \u003cstrong\u003en8n-nodes-snapshot-site\u003c\/strong\u003e and Snapshot Site credentials to fetch fully rendered HTML.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e: configured via an \u003cstrong\u003eOpenAI (Chat Model) credential\u003c\/strong\u003e used by n8n’s \u003cstrong\u003eInformation Extractor\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: reads URLs and writes extracted businesses plus error logs to dedicated tabs.\u003c\/li\u003e\n  \u003cli\u003eWorkflow nodes include \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eno op\u003c\/strong\u003e, \u003cstrong\u003esplit out\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45738639884467,"sku":"N8N-17515","price":3.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/kKLrBOZegDm_l62FUb9on_CUZjByGq.png?v=1785230525","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-extract-business-directory-listings-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}