Import products from Google Sheets to Shopify with multi-variant support
Ready for 3.0What this workflow does
This workflow has 16 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and GraphQL.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- set shop url (Edit Fields (Set)): sets 1 field: myshop
- Shopify, GetLocations (GraphQL): uses GraphQL
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- single and multivariant products (Code): runs custom JavaScript code
- is variant? (Switch): routes items into 2 branches
- Shopify, CreateProduct (GraphQL): uses GraphQL
- CreateProduct (GraphQL): uses GraphQL
- adjust variants (Code): runs custom JavaScript code
- SetVariant (GraphQL): uses GraphQL
- Split Out: splits a list into separate items
…plus 5 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 (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - GraphQL
n8n-nodes-base.graphql - Split Out
n8n-nodes-base.splitOut - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - Edit Fields (Set)
n8n-nodes-base.set
From the author
Short Description (for listing) Import products from Google Sheets to Shopify with automatic handling of single products and multi-variant products (sizes, colors, etc.). Includes SKU management, inventory tracking, and image uploads via GraphQL API. Category…