Sync new Shopify orders to Google Sheets with GPT-4.1-mini analysis
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 11 nodes and runs on a schedule (every minute). Along the way it connects OpenAI Chat Model, Shopify and Google Sheets.
How it runs
Trigger: On a schedule (every minute).
- Get Last Successful Sync Time (Code): runs custom JavaScript code
- Fetch Orders from Shopify (Shopify): get many
- Mark Orders as New or Old (Code): runs custom JavaScript code
- Is This a New Order? (If): checks a condition and branches into true / false
- AI Order Analysis (AI Agent): runs an AI agent, with model: OpenAI Chat Model
- Convert AI Response to Data (Code): runs custom JavaScript code
- Prepare Final Order Data (Edit Fields (Set)): sets 12 fields: id, order_number, order_created_at…
- Save Order to Google Sheet (Google Sheets): append
- Update Sync Time (Code): runs custom JavaScript code
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 (8)
- OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Shopify
n8n-nodes-base.shopify - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets
From the author
Shopify New Orders Auto-Sync to Google Sheets & AI Analysis This workflow automatically fetches new Shopify orders on a schedule, detects only newly created orders, enriches them using AI, and stores clean, structured data in Google Sheets for reporting and…