Can I export existing customers, not just new ones?

You need a separate workflow with a Shopify regular node (not trigger) set to 'Get All Customers'. The trigger only captures new registrations going forward.

What happens if Google Sheets is down when a customer registers?

The workflow fails and you lose that customer data unless you add error handling. Set up a retry node or log failed exports to a backup sheet.

Can I filter out test customers from the export?

Add an IF node between Shopify and Google Sheets that checks if the email contains '+test' or matches your test domain pattern. Only continue to Google Sheets for real customers.

How do I handle customers who register without providing a name?

Shopify allows empty first_name fields. Add a default value expression like {{ $json.first_name || 'Unknown' }} to avoid blank cells in your spreadsheet.

Will this capture customers created through other channels like POS?

Yes, the Customer Created webhook fires for all registration sources including online, POS, and admin-created customers. You can filter by created source if needed.

Intermediate~20 min setupProductivity & E-commerceVerified April 2026

How to Export Shopify Customers to Google Sheets with N8n

Automatically log new Shopify customers with name, email, total orders, and total spent to Google Sheets for segmentation and outreach.

Steps and UI details are based on platform versions at time of writing — check each platform for the latest interface.

n8n

Also on:Make Zapier

Best for

Teams comfortable with light coding who need custom data formatting and high-volume customer exports.

Not ideal for

Non-technical users who prefer drag-and-drop field mapping without writing expressions.

Sync type

real-time

Use case type

export

Real-World Example

💡

A 25-person D2C skincare brand uses this to build email segments based on purchase behavior. Before automation, their marketing manager exported customer lists from Shopify weekly and manually cross-referenced order counts in Excel. Now they segment first-time buyers vs repeat customers automatically for targeted email campaigns.

What Will This Cost?

Drag the slider to your expected monthly volume.

Monthly workflow runs

/mo

505005K50K

Each platform counts differently — Zapier: 1 task per trigger. Make: 1 operation per module per record. n8n: 1 execution per run.

$30/mo if billed monthly

Pipedream

$29/mo

Basic plan

Prices shown for annual billing. Based on published pricing as of April 2026.

Estimated ROI

1000

min saved/mo

$583

labor value/mo

Free

no platform cost

Based on ~2 min manual effort per operation at $35/hr fully loaded labor cost.

Implementation

Skip the setup

Import this workflow directly into n8n

Copy the pre-built n8n blueprint and paste it straight into n8n. All modules, filters, and field mappings are already configured — you just need to connect your accounts.

Before You Start

Make sure you have everything ready.

Shopify store with Admin API access enabled

Google account with a spreadsheet ready for customer data

N8n account (cloud or self-hosted instance)

Admin permissions on your Shopify store

Field Mapping

Map these fields between your apps.

Field	API Name	Description
Required
Customer Name	`first_name + last_name`	Combines Shopify's separate first_name and last_name fields into a single column
Email Address	`email`	Primary email address from customer registration

4 optional fields▸ show

Total Orders	`orders_count`	Number of completed orders this customer has placed
Total Spent	`total_spent`	Lifetime order value as a string (convert to number if needed)
Customer ID	`id`	Shopify's unique customer identifier for lookups
Registration Date	`created_at`	When the customer account was created (ISO timestamp)

Step-by-Step Setup

Dashboard > + > Create workflow

Create New N8n Workflow

Start a blank workflow in N8n to build your customer export automation. This creates the canvas where you'll connect Shopify to Google Sheets.

1Click the + button in your N8n dashboard
2Select 'Create workflow' from the dropdown
3Name your workflow 'Shopify Customer Export'
4Click 'Create' to open the workflow editor

✓ What you should see: You should see an empty workflow canvas with a single gray 'Add first step' node in the center.

Workflow > Add Node > Shopify Trigger

Add Shopify Trigger Node

Configure N8n to listen for new customer registrations in your Shopify store. This webhook fires immediately when someone creates an account.

1Click the gray 'Add first step' node
2Search for 'Shopify' in the apps list
3Select 'Shopify Trigger'
4Choose 'Customer Created' from the event dropdown

✓ What you should see: A purple Shopify trigger node appears with 'Customer Created' selected in the Event field.

⚠

Common mistake — Don't pick 'Customer Updated' — that fires on every profile change and will spam your sheet with duplicates.

n8n

click +

search apps

Google Sheets

Add Shopify Trigger Node

Google Sheets

module added

Shopify Node > Credentials > Create New

Connect Your Shopify Store

Authenticate N8n with your Shopify admin account to access customer data. You'll need admin permissions to create webhooks.

1Click 'Create New' next to the Credential dropdown
2Enter your Shopify store URL (yourstore.myshopify.com)
3Paste your Admin API access token
4Click 'Save' then 'Test Connection'

✓ What you should see: Green checkmark appears with 'Connection successful' message, and the credential saves to your account.

⚠

Common mistake — Your access token needs 'read_customers' and 'write_webhooks' permissions — basic tokens won't work.

Shopify Node > Listen for Test Event

Test Shopify Webhook

Register the webhook with Shopify and capture a test customer record. N8n needs real data to map fields correctly in the next step.

1Click 'Listen for Test Event' in the Shopify node
2Go to your Shopify admin and create a test customer
3Fill in name, email, and save the customer
4Return to N8n and click 'Stop Listening'

✓ What you should see: The Shopify node shows '1 item' with customer data including id, email, first_name, last_name, and orders_count.

⚠

Common mistake — Test customers need an email address — Shopify won't fire the webhook for customers without email.

n8n

▶ Run once

executed

✓

Google Sheets

✓

Shopify

🔔 notification

received

Workflow > Add Node > Google Sheets

Add Google Sheets Node

Connect a Google Sheets node to write customer data to your spreadsheet. This handles the actual data export from Shopify.

1Click the + button after the Shopify node
2Search for 'Google Sheets' and select it
3Choose 'Append' as the operation
4Select 'By Name' for spreadsheet selection method

✓ What you should see: A green Google Sheets node appears connected to your Shopify trigger with 'Append' operation selected.

Google Sheets Node > Credentials > Sign in with Google

Authenticate Google Sheets

Link your Google account so N8n can write to your spreadsheets. Use the account that owns your customer tracking sheet.

1Click 'Sign in with Google' in the credentials section
2Grant N8n permission to access Google Sheets
3Select your Google account from the dropdown
4Click 'Save' to store the credential

✓ What you should see: Your Google email appears in the credential field with a green connected status indicator.

⚠

Common mistake — Make sure the Google account owns the target spreadsheet — shared access sometimes fails with append operations.

Google Sheets Node > Document Settings

Configure Target Spreadsheet

Point N8n to your customer tracking spreadsheet and specify which sheet tab to use. This determines where customer data gets written.

1Enter your spreadsheet name in the 'Document' field
2Type the sheet tab name (usually 'Sheet1' or 'Customers')
3Set 'Header Row' to 1 if your sheet has column headers
4Leave 'Range' empty to append to the bottom

✓ What you should see: The spreadsheet and sheet names appear in their respective fields with no error messages.

⚠

Common mistake — Sheet names are case-sensitive — 'customers' won't match a tab named 'Customers'.

Google Sheets Node > Columns

Map Customer Data Fields

Tell N8n which Shopify customer fields to write to which Google Sheets columns. This creates the actual data export mapping.

1Click 'Add Column' four times to create four mapping rows
2Set column A to map to {{ $json.first_name }} {{ $json.last_name }}
3Set column B to map to {{ $json.email }}
4Set column C to map to {{ $json.orders_count }}
5Set column D to map to {{ $json.total_spent }}

✓ What you should see: Four column mappings appear with Shopify field expressions in each value field.

⚠

Common mistake — Use double curly braces for expressions — single braces won't evaluate the Shopify data correctly.

Google Sheets fields

Column A

Column B

Status

Notes

available as variables:

1.props.Column A

1.props.Column B

1.props.Email

1.props.Status

1.props.Notes

Workflow > Execute Workflow

Test the Complete Workflow

Run the full automation to verify customer data flows correctly from Shopify to Google Sheets. This catches mapping errors before going live.

1Click 'Execute Workflow' in the top toolbar
2Check that both nodes show green success checkmarks
3Open your Google Sheets document
4Verify the test customer data appears in the correct columns

✓ What you should see: New row appears in Google Sheets with customer name, email, order count, and total spent from your test customer.

⚠

Common mistake — If you see #ERROR# in cells, your field expressions are wrong — go back and fix the column mappings.

Workflow > Activate Toggle

Activate the Workflow

Turn on the automation so it runs automatically when new customers register. The webhook will stay active until you deactivate it.

1Click the toggle switch in the top right corner
2Confirm activation when prompted
3Click 'Save' to store the workflow settings
4Test with a real customer registration

✓ What you should see: Toggle shows 'Active' status and the workflow name has a green dot indicator in your dashboard.

⚠

Common mistake — Active workflows count toward your execution limit even when not triggering — monitor your usage if you're on the free plan.

Drop this into an n8n Code node.

JavaScript — Code Node// Clean customer name formatting

▸ Show code

// Clean customer name formatting
{{ $json.first_name.trim().charAt(0).toUpperCase() + $json.first_name.trim().slice(1).toLowerCase() }} {{ $json.last_name.trim().charAt(0).toUpperCase() + $json.last_name.trim().slice(1).toLowerCase() }}

... expand to see full code

// Clean customer name formatting
{{ $json.first_name.trim().charAt(0).toUpperCase() + $json.first_name.trim().slice(1).toLowerCase() }} {{ $json.last_name.trim().charAt(0).toUpperCase() + $json.last_name.trim().slice(1).toLowerCase() }}

Scaling Beyond 200+ customers/day+ Records

If your volume exceeds 200+ customers/day records, apply these adjustments.

Add Google Sheets Rate Limiting

Insert a 1-second delay node before Google Sheets to avoid hitting their 100 requests per 100 seconds limit. Without this, rapid customer signups will cause write failures.

Switch to Batch Processing

Replace the direct Google Sheets append with a queue system that batches multiple customers into a single sheet write. This reduces API calls and improves reliability during traffic spikes.

Going live

Production Checklist

Before you turn this on for real, confirm each item.

Set Google Sheets credential to use a service account instead of personal Google login

Applies when: Enterprise

Add error handling to continue workflow even if Google Sheets write fails

Applies when: Always

Configure webhook retry settings in case Shopify delivery fails

Applies when: High volume

Test with customers that have special characters in names or email addresses

Applies when: Always

Verify the target spreadsheet has column headers matching your mapped fields

Applies when: Always

Set up execution monitoring alerts for failed customer exports

Applies when: High volume

Troubleshooting

Common errors and how to fix them.

Frequently Asked Questions

Common questions about this workflow.

Analysis

VerdictWhy n8n for this workflow

Use N8n for this if you want full control over the data mapping and don't mind writing expressions manually. The webhook triggers instantly when customers register, and you can transform Shopify's nested JSON however you need. N8n also handles high volumes better than Zapier without hitting rate limits. Skip N8n if your team doesn't touch code at all — Zapier's point-and-click field mapping is genuinely easier for non-technical users.

Cost

This workflow uses 1 execution per new customer. At 100 customers/month, that's 100 executions monthly. N8n's free plan covers 5,000 executions, so you're well within limits. The $20 Starter plan handles 20,000 executions. Zapier would cost $20/month for the same volume since customer webhooks need their premium trigger. Make offers 1,000 operations free, then $9/month for 10K — cheaper if you stay under that threshold.

Tradeoffs

Zapier handles the Google Sheets integration more smoothly with better error handling when sheets are renamed or moved. Make's Shopify connector pulls more customer fields by default, including tags and marketing consent. But N8n gives you the most flexibility for data transformation — you can calculate customer lifetime value, format names properly, or skip test customers with custom logic that the others can't match.

Shopify's total_spent field comes as a string, not a number, so Google Sheets might not calculate correctly until you add a parseFloat() expression. The webhook delivers immediately but Google Sheets can lag 10-30 seconds on writes during peak hours. If customers register faster than 1 per second, you'll need to add a delay node to avoid hitting Google's 100 requests/100 seconds limit.

Ideas for what to build next

→
Add Order Details Export — Create a second workflow that captures order line items to a separate sheet when customers make purchases.
→
Build Customer Segmentation — Use Google Sheets formulas or a follow-up N8n workflow to automatically tag high-value vs new customers based on the exported data.
→
Connect Email Marketing — Extend the workflow to also add new customers to Mailchimp or Klaviyo lists for immediate welcome email sequences.