Create Shopify Customers from Google Sheets

This n8n workflow reads a list of customer data from a Google Sheet and creates corresponding customer records in Shopify using the Shopify Admin API with GraphQL queries. It handles the full process from data extraction to API calls, making it seamless to populate your Shopify store with customer information.

Key use cases include generating test users for development stores, migrating customers from legacy platforms or spreadsheets, and serving as an easy introduction to Shopify's powerful GraphQL API. Whether you're onboarding clients, testing e-commerce features, or scaling your customer base, this workflow saves hours of manual data entry.

Setup is straightforward: configure OAuth2 credentials for Google Sheets (with access to Sheets and Drive) and a Header Auth credential for Shopify (using X-Shopify-Access-Token header with your shpat_ token). Generate the Shopify token via the store's app development settings by creating an app with read/write_customers scopes. Update the GraphQL node with your shop's details.

Benefits include error reduction, scalability for bulk operations, and extensibility for additional fields or scopes. It's perfect for e-commerce automation, client management, and rapid prototyping, delivering high business value with minimal configuration.