{"product_id":"shopify-variant-price-stock-check-to-google-sheets-n8n","title":"Shopify Variant Price \u0026 Stock Check to Google Sheets (n8n)","description":"\u003ch3\u003eMonitor Shopify variant prices and buyability—then register every variant in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003eShopify Variant Price \u0026amp; Stock Check to Google Sheets (n8n)\u003c\/strong\u003e workflow automatically turns a known public Shopify snapshot into a \u003cstrong\u003evariant-level price and availability register\u003c\/strong\u003e. Instead of manually comparing sizes, formats, and SKUs, you get a structured \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e feed that reflects what’s publicly buyable per variant.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls a bounded Apify snapshot\u003c\/strong\u003e that supplies products with their variants.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWaits for the same run\u003c\/strong\u003e and performs coverage checks, then verifies the complete dataset before writing results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts one Sheet row per variant\u003c\/strong\u003e using stable keys—previous observations update on repeat runs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLeaves unobserved rows intact\u003c\/strong\u003e (so you can check observation dates before making decisions).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDefines availability as public buyability\u003c\/strong\u003e (not inventory quantity). A blank compare-at price is kept as unknown.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStops delivery when source data is incomplete\u003c\/strong\u003e. If results are verified empty, it produces \u003cem\u003eno rows\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack \u003cstrong\u003evariant-level price and availability\u003c\/strong\u003e for a known Shopify collection or product without copying details manually.\u003c\/li\u003e\n  \u003cli\u003eCompare formats\/SKUs across sizes (e.g., “Size 8” vs “Size 9”) and record what’s publicly purchasable.\u003c\/li\u003e\n  \u003cli\u003eSupport e-commerce research teams with a repeatable \u003cstrong\u003evariant monitoring\u003c\/strong\u003e process and observation dates.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eUses n8n nodes: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, plus supporting \u003cstrong\u003eHTTP request\u003c\/strong\u003e and notes.\u003c\/li\u003e\n  \u003cli\u003eWorkflow inputs: import the JSON into an n8n canvas, then apply \u003cstrong\u003eApify Header Auth\u003c\/strong\u003e credentials to all HTTP nodes.\u003c\/li\u003e\n  \u003cli\u003eOutputs: \u003cstrong\u003eGoogle Sheets OAuth2\u003c\/strong\u003e for the “Variant Review” tab and an imported sheet with the \u003cstrong\u003eexact CSV header\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eData handling: \u003cstrong\u003eCOMPLETE vs CAPPED\u003c\/strong\u003e source windows are respected; incomplete sources prevent delivery.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eNote:\u003c\/strong\u003e The n8n template is free, while \u003cstrong\u003eApify usage is paid per product\u003c\/strong\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978924548275,"sku":"N8N-19344","price":27.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/oPnc6UqX0CL2aSBhbn5w_hTr4Yfz7.png?v=1788859041","url":"https:\/\/buyflowscripts.com\/products\/shopify-variant-price-stock-check-to-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}