{"product_id":"ondc-catalog-sync-workflow-sheets-to-seller-app-api-n8n-openai","title":"ONDC Catalog Sync Workflow: Sheets to Seller App API (n8n + OpenAI)","description":"\u003ch3\u003eKeep Your ONDC Seller Catalog in Sync—Automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically syncs an ONDC seller catalog from your Google Sheets to your Seller App API—on a 30-minute schedule or via webhook—while using OpenAI to clean product content, validate ONDC retail rules, check image links, and email a detailed error report.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns on schedule or demand:\u003c\/b\u003e executes every 30 minutes or whenever a POST request hits the n8n webhook endpoint.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDetects catalog changes:\u003c\/b\u003e reads catalog rows from the Google Sheets “Catalog” tab and fetches the current live catalog from the Seller App API to identify \u003ci\u003echanged\u003c\/i\u003e, \u003ci\u003enew\u003c\/i\u003e, \u003ci\u003edisabled\u003c\/i\u003e, or \u003ci\u003edrifting\u003c\/i\u003e SKUs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUses OpenAI for ONDC-ready content:\u003c\/b\u003e sends only items needing content updates to \u003cb\u003egpt-4o-mini\u003c\/b\u003e to normalize titles, descriptions, categories, units, and attributes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eValidates images:\u003c\/b\u003e checks product image URLs using HTTP \u003cb\u003eHEAD\u003c\/b\u003e requests and flags broken links, invalid content types, or oversized image files.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eApplies ONDC retail rule validation:\u003c\/b\u003e validates each SKU against ONDC retail rules, includes a \u003cb\u003eprice-jump guard\u003c\/b\u003e to hold large changes until the sheet confirms them, then builds batched upsert and inventory payloads.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSync + reporting:\u003c\/b\u003e pushes updates to the Seller App API, writes sync results (including hashes\/timestamps and AI-cleaned fields) back to Google Sheets, logs failures into a \u003cb\u003e“Sync Errors”\u003c\/b\u003e tab, and emails a summary via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate frequent catalog updates without manual API calls.\u003c\/li\u003e\n  \u003cli\u003eEnsure ONDC-compliant product data with OpenAI-assisted cleanup and rule checks.\u003c\/li\u003e\n  \u003cli\u003eReduce failed onboarding due to broken\/invalid image URLs.\u003c\/li\u003e\n  \u003cli\u003eProvide operators with an error-focused run report after each sync cycle.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n workflow nodes:\u003c\/b\u003e if, set, code, gmail, switch, webhook\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eTrigger:\u003c\/b\u003e scheduled every 30 minutes or POST to the webhook\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAI:\u003c\/b\u003e OpenAI gpt-4o-mini for content normalization\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eData sources\/targets:\u003c\/b\u003e Google Sheets (“Catalog” tab + “Sync Errors”), Seller App API\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eImage verification:\u003c\/b\u003e HTTP HEAD requests for URL and content validation\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192864198835,"sku":"N8N-20525","price":42.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/rZNIHtYhaWyFswYeaqNEM_CgpWiqZj.png?v=1791537708","url":"https:\/\/buyflowscripts.com\/products\/ondc-catalog-sync-workflow-sheets-to-seller-app-api-n8n-openai","provider":"N8N Commerce","version":"1.0","type":"link"}