Get all orders in Shopify to Google Sheets
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 workflow has 9 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects Google Sheets.
How it runs
Trigger: On a schedule (every day) (plus 1 other trigger).
- Get Orders (HTTP Request): calls an HTTP API
- Check page_info existence (If): checks a condition and branches into true / false
- Merge Loop items (Code): runs custom JavaScript code
- Extract page_info (Code): runs custom JavaScript code
- List Orders (Split Out): splits a list into separate items
- Assign page_info parameter (Edit Fields (Set)): sets 1 field: page_info
- Google Sheets: append or update
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)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Split Out
n8n-nodes-base.splitOut - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if
From the author
This workflow retrieves all Shopify Orders and saves them into a Google Sheets spreadsheet using the Shopify Admin REST API. It uses pagination to ensure all orders are collected efficiently. I originally built this workflow for my own use and found it…