AutomationMart
Home/Browse/Create Shopify customers from a Google Sheet
n8n

Create Shopify customers from a Google Sheet

n8nn8n3 modulesv1.0
ShopifyGoogle SheetsGoogle Drive

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
Create Shopify customers from a Google Sheet workflow diagram

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"

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

This HARPA AI + MAKE.COM scenario enriches your name-email database and creates personalized outreach emails to promote your offerings. You only need a name-email database that works with Google Sheets. Don't have one? You can export contacts from services like Hunter.io, Tomba.io, Dropcontact.io, findymail.com, or Instantly. If Google Sheets isn't your preferred tool, feel free to use Airtable or another CRM solution. Here's how it works: - HARPA scans company websites after receiving an ema

Free

Send Slybroadcast campaigns with audio URL created by Google Cloud TTS for new PrestaShop orders

Make will watch your PrestaShop orders at regular intervals and synthesize speech for order detail values designated by you via Google Cloud Text-to-Speech, upload them to your Google Drive, create a Google Drive share link and send the audio file as a campaign to a list of mobile phones via Slybroadcast.

Free

Send country-based user & session report from Google Analytics to Google Sheets

Gain deeper insights into your website’s traffic with our automated report that sends country-specific user and session data to Google Sheets every Friday. Easily adjust the scheduling to align with your analytical needs. The scenario is scheduled to execute every Friday at 17:00 which you can change in the schedule setting by clicking the clock icon on the first module.

Free

Sync Youtube video URLs with Google Sheets

Sync Youtube Videos with Google Sheets (Part 1 of Youtube comments sentiment analyze automation along with detailed dashboard) This workflow is the first part of a multi-part automation system designed to perform large-scale YouTube comment sentiment analysis alongwith detailed dashboard. It solves the problem of manually tracking new videos across multiple YouTube channels by automatically fetching and organizing video URLs in a Google Sheet, setting the stage for deeper analysis in Part 2. Wha

Free

Queue Shopify orders for WhatsApp store review (Part 1 of 2)

Queue fulfilled Shopify orders for delayed WhatsApp store review requests. Part 1 of 2 - requires Part 2 template to send messages. HOW IT WORKS: - Triggers when Shopify order is fulfilled - Checks if customer already received a store review request (via CRM tag) - If not, queues order in Data Store with scheduled send date REQUIRES: - Part 2 template: "Send scheduled WhatsApp store review requests" - WhatsScale account - Make.com Data Store (create one named "Store Review Queue") DATA STORE

Free

Create AI YouTube SRT subtitles 📢 with ElevenLabs 🎧 and Google Drive

This workflow is a simple yet brilliant automation designed to generate time-coded SRT subtitles starting directly from a video URL using ElevenLabs. With just a single video link, the workflow automatically extracts the audio, transcribes it using AI speech recognition, and converts the transcription into a properly formatted SRT subtitle file with accurate timestamps. This workflow automates the creation of SRT subtitle files for YouTube videos using AI speech recognition, eliminating the need

Free

Sync Notion to Clockify including clients projects and tasks

Purpose This workflow synchronizes three entities from Notion to Clockify, allowing tracked time to be linked to client-related projects or tasks. Demo & Explanation []( How it works - On every run active Clients, Projects and Tasks are retrieved from both Notion and Clockify before being compared by the Clockify ID, which is again stored in Notion for reference - Potential differences are then applied to Clockify - If an item has been archived or closed in Notion, it is also marked as archived

Free

Customer support & lead collection chatbot with RAG, GPT-4o, Sheets & Telegram

Who’s it for This template is designed for small and medium businesses, startups, and agencies that want to automate customer inquiries, provide instant support, and capture leads without losing valuable conversations. It’s especially useful for teams that get many repetitive questions about products, services, or locations but don’t want to miss out on collecting contact details for follow-up. What it does / How it works The workflow creates a 24/7 AI-powered chatbot that answers company-relate

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free