{"product_id":"extract-ecom-products-to-google-sheets-n8n-gpt-4o","title":"Extract Ecom Products to Google Sheets (n8n + GPT-4o)","description":"\u003ch3\u003eAutomatically extract e-commerce products into Google Sheets using n8n + GPT-4o\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls product listings from your e-commerce category pages, captures the fully rendered HTML, uses \u003cstrong\u003eGPT-4o\u003c\/strong\u003e to extract structured product data, and \u003cstrong\u003eupserts\u003c\/strong\u003e the results into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—with error logging included.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily\u003c\/strong\u003e at \u003cstrong\u003e11:00 (UTC)\u003c\/strong\u003e via schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads category URLs\u003c\/strong\u003e one-by-one from the \u003cstrong\u003e“Store Sources”\u003c\/strong\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eFor each URL, it uses \u003cstrong\u003eSnapshot Site\u003c\/strong\u003e to fetch the \u003cstrong\u003efully rendered page HTML\u003c\/strong\u003e (with retry behavior on failures).\u003c\/li\u003e\n  \u003cli\u003eIf Snapshot Site fails, the workflow writes the \u003cstrong\u003eURL\u003c\/strong\u003e, \u003cstrong\u003eerror message\u003c\/strong\u003e, and \u003cstrong\u003etimestamp\u003c\/strong\u003e to the \u003cstrong\u003e“Extraction Errors”\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003eIf capture succeeds, it \u003cstrong\u003eremoves scripts\/styles\u003c\/strong\u003e, \u003cstrong\u003etrims the HTML\u003c\/strong\u003e, and sends the content to the \u003cstrong\u003eOpenAI chat model\u003c\/strong\u003e (via the Information Extractor) to return a \u003cstrong\u003elist of products\u003c\/strong\u003e with structured fields.\u003c\/li\u003e\n  \u003cli\u003eIt then \u003cstrong\u003esplits extracted products\u003c\/strong\u003e into individual rows and \u003cstrong\u003eappends or updates\u003c\/strong\u003e them in the \u003cstrong\u003e“Products”\u003c\/strong\u003e tab, with \u003cstrong\u003ededuplication by \u003cem\u003eproductUrl\u003c\/em\u003e\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMaintain an always-current \u003cstrong\u003eproduct catalog\u003c\/strong\u003e from category pages for internal ops or reporting.\u003c\/li\u003e\n  \u003cli\u003eExtract competitor or partner catalog data into Google Sheets for analysis and enrichment.\u003c\/li\u003e\n  \u003cli\u003eAutomate recurring e-commerce scraping workflows without manually exporting data.\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 include: \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003eno op\u003c\/em\u003e, \u003cem\u003esplit out\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSnapshot Site\u003c\/strong\u003e (community node: \u003cstrong\u003en8n-nodes-snapshot-site\u003c\/strong\u003e) for fully rendered HTML capture + API credentials.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e via OAuth2 to read\/write: “Store Sources”, “Products”, and “Extraction Errors”.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI chat model \/ GPT-4o\u003c\/strong\u003e to extract structured product fields from cleaned HTML.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eReady to install:\u003c\/strong\u003e connect Snapshot Site, Google Sheets, and your OpenAI API credential, then align your tab names to match your spreadsheet.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45758758912179,"sku":"N8N-17774","price":78.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/xU990pqoAljEFxqTfFo5Q_97HPURjJ.png?v=1785834826","url":"https:\/\/buyflowscripts.com\/products\/extract-ecom-products-to-google-sheets-n8n-gpt-4o","provider":"N8N Commerce","version":"1.0","type":"link"}