Sync ONDC seller catalog between Google Sheets, seller app, and OpenAI
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 26 nodes and runs on a schedule (every 30 minutes) (plus 1 other trigger). Along the way it connects Google Sheets, OpenAI and Gmail.
How it runs
Trigger: On a schedule (every 30 minutes) (plus 1 other trigger).
- Set Catalog Config (Edit Fields (Set)): sets 29 fields: seller_name, sheet_id, catalog_sheet…
- Get Catalog Sheet (Google Sheets): uses Google Sheets
- Fetch Live Catalog from Seller App (HTTP Request): calls an HTTP API
- Detect Changed Rows (Code): runs custom JavaScript code
- Select Rows for AI Clean-up (Code): runs custom JavaScript code
- Skip AI? (If): checks a condition and branches into true / false
- Collect Image URLs (Code): runs custom JavaScript code
- AI Clean Product Attributes (OpenAI): uses OpenAI
- Skip Image Check? (If): checks a condition and branches into true / false
- Merge AI Output into Rows (Code): runs custom JavaScript code
…plus 14 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - OpenAI
@n8n/n8n-nodes-langchain.openAi - Switch
n8n-nodes-base.switch - Gmail
n8n-nodes-base.gmail
From the author
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,…