Create Shopify customers from a Google Sheet
Task Read a list of customers from a GoogleSheet and create them in Shopify using Shopify's Admin API (GraphQL). Why ? - Generate test users for development stores. - Migrate customers from other platforms. - Easy intro to Shopify's GraphQL API. Setup Setting up Google Sheets access Follow the instructions in the N8N Docs for granting Oauth2 access to Google services. You'll need to grant API access to Google Sheets and Google Drive (to list available sheets). Setting up Shopify access Shopify
At a glance
Create Shopify customers from a Google Sheet is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Shopify, Google Sheets, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Shopify, Google Sheets, Google Drive
- Modules
- 3
- Price
- Free
- Version
- v1.0

About this workflow
Task Read a list of customers from a GoogleSheet and create them in Shopify using Shopify's Admin API (GraphQL). Why ? - Generate test users for development stores. - Migrate customers from other platforms. - Easy intro to Shopify's GraphQL API. Setup Setting up Google Sheets access Follow the instructions in the N8N Docs for granting Oauth2 access to Google services. You'll need to grant API access to Google Sheets and Google Drive (to list available sheets). Setting up Shopify access Shopify's Admin API uses 'Header Auth' with a key of X-Shopify-Access-Token and a value of your shopify access token which starts with shpat . How to generate a Shopify Access Token To generate a Shopify Access Token create an app, grant the app the necessary scopes, then generate a token. From inside a store do the following : 1. click Settings (nav link) 2. click Apps and sales channels (nav link) 3. click Develop Apps (button) 4. click Create App (button) 5. give the app a name 6. click configure Admin API Scopes (button) 7. at a minimum grant readcustomers and writecustomers scope. Grant additional scopes if you plan on accessing other parts of the API. 8. click save To generate the token 1. click install app (button) 2. click install on the dialog that pops up (button) 3. click 'reveal token once' (button) 4. copy the token into a password vault or somewhere secure. Template Updates To test this out you'll need to make the following changes : 1) Create a header credential where the key is X-Shopify-Access-Token and the value is your Shopify Access Token (it starts with shpat 2) In the GraphQL node change the endpoint URL to your store. Something like store goes here}.myshopify.com/admin/api/2025-04/graphql.json Google Sheet Structure Columns can be in any order, because the rows will be mapped to fields in a json object. N8N will treat the first row in the sheet as a column name, so at a minimum use the column names below in row 1 of your sheet. - firstname : Any string - lastname : Any string - email : Valid email - mobilephone : International mobile phone format with no spaces eg. +61414708406 (Shopify will reject anything else). Example CSV "firstname","lastname","email","mobilephone" "Bob","Smith","bob@example.com","+61414999999"
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
AI-Powered Email Campaign using a Name-Email Database
Send Slybroadcast campaigns with audio URL created by Google Cloud TTS for new PrestaShop orders
Send country-based user & session report from Google Analytics to Google Sheets
Sync Youtube video URLs with Google Sheets
Queue Shopify orders for WhatsApp store review (Part 1 of 2)
Create AI YouTube SRT subtitles 📢 with ElevenLabs 🎧 and Google Drive
Sync Notion to Clockify including clients projects and tasks
Customer support & lead collection chatbot with RAG, GPT-4o, Sheets & Telegram
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you