# Sync ONDC seller catalog between Google Sheets, seller app, and OpenAI

> Quick Overview This workflow syncs an ONDC seller catalog from Google Sheets to a seller app API on a schedule or via webhook, using OpenAI to clean product content, validating ONDC retail rules, checking image links, writing sync results back to the sheet, and emailing an error-focused run report. How it works 1. Runs every 30 minutes or when a POST request hits the n8n webhook endpoint. 2. Loads catalog rows from Google Sheets and fetches the current live catalog from the seller app API to detect changed, new, disabled, or drifting SKUs. 3. Sends only “full update” items that need content changes to OpenAI (gpt-4o-mini) to normalize titles, descriptions, categories, units, and attributes. 4. Verifies product image URLs with HTTP HEAD requests and flags broken links, non-image content types, or oversized files. 5. Validates each SKU against ONDC retail rules, applies a price-jump guard that holds large changes until the sheet confirms them, and builds batched upsert and inventory payl

- **Domain**: `n8n-workflow-20525.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/20525
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20525.n8n.io
- Documentation: https://n8n.io/workflows/20525