{"product_id":"n8n-workflow-google-sheets-catalog-to-product-posts","title":"n8n Workflow: Google Sheets Catalog to Product Posts","description":"\u003ch3\u003eTurn your approved Google Sheets catalog into ready product posts across 2–4 platforms\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow converts catalog facts from Google Sheets into draft product posts for multiple platforms—validating SKUs, prices, store links, and content before you review exact text in an authenticated form. It also produces an optional scheduler CSV without auto-publishing.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIngests catalog data:\u003c\/strong\u003e Reads up to \u003cstrong\u003e1,000\u003c\/strong\u003e rows, rejects duplicate product IDs, invalid prices, unsupported currencies, unapproved content, and links outside your \u003cem\u003eexact trusted store hosts\u003c\/em\u003e. Selects up to \u003cstrong\u003ethree\u003c\/strong\u003e ready, previously unapproved product snapshots.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads an authoritative pipeline record:\u003c\/strong\u003e Uses exactly \u003cstrong\u003eone\u003c\/strong\u003e versioned pipeline entry from an \u003cstrong\u003en8n Data Table\u003c\/strong\u003e, then stores an exclusive request intent via \u003cstrong\u003ecompare-and-swap\u003c\/strong\u003e to prevent conflicting runs. It makes \u003cstrong\u003eone\u003c\/strong\u003e OpenAI request with \u003cstrong\u003eautomatic HTTP retries disabled\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates drafts with strict controls:\u003c\/strong\u003e Applies a strict JSON schema to select a neutral hook and one or two evidence IDs for each requested product\/platform pair. The model is constrained to \u003cstrong\u003enot write prices, discounts, availability claims, or URLs\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds final drafts from source evidence:\u003c\/strong\u003e Drafts are assembled from selected exact source sentences, product title, catalog price and currency, catalog stock status, and the approved product URL. Validates platform length, missing pairs, unknown evidence, refusals, and incomplete responses.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves outputs for traceability:\u003c\/strong\u003e Writes posts, evidence snapshots, and a \u003cstrong\u003econtent hash\u003c\/strong\u003e back to the \u003cstrong\u003eData Table\u003c\/strong\u003e, and mirrors individual drafts to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e using RAW values (the mirror is \u003cstrong\u003enot\u003c\/strong\u003e an approval authority).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReview companion:\u003c\/strong\u003e Includes an authenticated review companion that lets you review exact generated content. It also supports downloading an optional scheduler CSV—without publishing automatically.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAuto-drafting product announcements from an approved \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e catalog for recurring marketing cycles.\u003c\/li\u003e\n  \u003cli\u003eConsistent brand-safe messaging using evidence-based sentences and controlled OpenAI output.\u003c\/li\u003e\n  \u003cli\u003ePre-scheduling posts for multiple channels while keeping human approval in the loop.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow\/logic:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003cstrong\u003eData Table\u003c\/strong\u003e, \u003ccode\u003esticky note\u003c\/code\u003e, \u003cstrong\u003ecompression\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore integrations:\u003c\/strong\u003e \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (input + RAW mirroring) and \u003cstrong\u003eOpenAI\u003c\/strong\u003e (single constrained request)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReliability controls:\u003c\/strong\u003e versioned pipeline record, compare-and-swap intent lock, and HTTP retry behavior disabled\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46326527787187,"sku":"N8N-21778","price":42.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/HpWDwDy22MT2ltBa34hHg_mxQhg1ic.png?v=1793351906","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-catalog-to-product-posts","provider":"N8N Commerce","version":"1.0","type":"link"}