Why don't existing customers appear in my sheet?

The 'New Customer' trigger only fires for customers created after activating your Zap. To export existing customers, use Shopify's customer export CSV and import it into your Google Sheet first.

Can I update customer rows when they place additional orders?

No, this workflow creates new rows only. To update existing customer data, you'd need a separate Zap with 'Updated Customer' trigger and Lookup/Update Row action in Google Sheets.

What happens if my Google Sheet gets deleted?

The Zap will fail and pause after 3 consecutive errors. Zapier will email you about the failures. Recreate the sheet with the same name and column headers, then unpause the Zap.

Why do some customers show $0.00 total spent?

This happens when Shopify creates the customer record before payment processing completes. Add a 5-minute delay action before the Google Sheets step to let payment finish processing.

Can I filter out customers who haven't spent a minimum amount?

Yes, add a Filter step between trigger and action. Set it to only continue if 'Total Spent' is greater than your minimum threshold like $50.

Beginner~8 min setupProductivity & E-commerceVerified April 2026

How to Export Shopify Customers to Google Sheets with Zapier

Automatically log new Shopify customers with name, email, order count, and total spent in Google Sheets for segmentation without CSV exports.

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

Zapier

Also on:Make N8n

Best for

E-commerce teams needing automated customer data collection without technical setup

Not ideal for

High-volume stores processing 1000+ new customers monthly or needing real-time exports

Sync type

polling

Use case type

export

Real-World Example

💡

A 12-person D2C jewelry brand uses this to automatically export new customers with purchase amounts to Google Sheets for email segmentation. Before automation, their marketing manager exported customer CSVs from Shopify twice weekly and manually sorted them by spend tier. Now customer data flows automatically, and they segment high-value customers within minutes for targeted 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

Before You Start

Make sure you have everything ready.

Active Shopify store with customer orders

Google account with access to Google Sheets

Zapier account (free tier works for basic volume)

Google Sheet set up with column headers for customer data

Field Mapping

Map these fields between your apps.

Field	API Name	Description
Required
Customer Name	`first_name + last_name`	Combine Shopify's separate name fields into single column for easier reference
Email Address	`email`	Primary email from customer account used for marketing and notifications
Total Spent	`total_spent`	Lifetime customer value including all completed orders in store currency
Order Count	`orders_count`	Total number of completed orders placed by this customer
First Order Date	`created_at`	Timestamp when customer first created account or placed order

2 optional fields▸ show

Phone Number	`phone`	Customer phone if provided during checkout (often empty)
Customer Tags	`tags`	Shopify customer tags for segmentation and automation rules

Step-by-Step Setup

Dashboard > Create Zap > Trigger

Create New Zap

Start a new Zap to connect Shopify customer data to Google Sheets. This automation will trigger every time a new customer places their first order in your store.

1Click 'Create Zap' from your Zapier dashboard
2Click in the trigger box that says 'When this happens...'
3Type 'Shopify' in the app search box
4Select 'Shopify' from the dropdown results

✓ What you should see: You should see Shopify selected as your trigger app with event options appearing below.

Trigger > Shopify > New Customer

Select New Customer Trigger

Choose the New Customer trigger to capture first-time buyers. This fires when someone completes their first purchase and creates a customer record.

1Click on 'New Customer' from the trigger event list
2Click 'Continue' to proceed to account connection
3Connect your Shopify store by entering your shop domain
4Click 'Yes, Continue to Shopify' and authorize the connection

✓ What you should see: You should see 'Connected' next to your Shopify account with a green checkmark.

⚠

Common mistake — Don't select 'Updated Customer' — that triggers on profile changes and will create duplicate rows for existing customers

Zapier

click +

search apps

Google Sheets

Select New Customer Trigger

Google Sheets

module added

Trigger > Configure > Test

Configure Trigger Settings

Set up the trigger to capture all new customers without filters. Zapier will pull customer data including order history from Shopify's API.

1Leave all trigger fields empty to capture all new customers
2Click 'Continue' to proceed to testing
3Click 'Test trigger' to pull sample customer data
4Review the sample data showing customer fields and order totals

✓ What you should see: You should see sample customer data with fields like email, first_name, total_spent, and orders_count populated.

Action > Google Sheets > Create Spreadsheet Row

Add Google Sheets Action

Connect Google Sheets as your action app to write customer data. Each new customer will create one row with their details and order metrics.

1Click on the action box that says 'Then do this...'
2Type 'Google Sheets' and select it from the results
3Choose 'Create Spreadsheet Row' as the action event
4Click 'Continue' to connect your Google account

✓ What you should see: Google Sheets should show as connected with a green badge.

Action > Configure > Spreadsheet Selection

Select Target Spreadsheet

Choose which Google Sheet will store your customer data. Create a dedicated sheet for this automation to keep customer exports organized.

1Select your target Google Sheet from the dropdown
2Choose the specific worksheet tab (usually 'Sheet1')
3Click 'Continue' to proceed to field mapping
4Review the column headers if your sheet already has them

✓ What you should see: Your selected spreadsheet and worksheet should display with column headers visible.

⚠

Common mistake — Make sure the sheet exists and has column headers — Zapier won't create them automatically

Action > Configure > Field Mapping

Map Customer Name Fields

Map Shopify's customer name data to your sheet columns. Combine first and last names or keep them separate based on your segmentation needs.

1Click in the 'Name' or 'Customer Name' column field
2Select 'First Name' from the Shopify trigger data
3Add a space and click 'Last Name' to combine them
4Alternatively, map First Name and Last Name to separate columns

✓ What you should see: The name field should show dynamic data like 'John Smith' from your Shopify test customer.

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

Action > Configure > Field Mapping

Map Email and Contact Data

Add the customer's email address for outreach campaigns. This pulls from Shopify's primary email field which customers use for order notifications.

1Click in your 'Email' column field
2Select 'Email' from the Shopify customer data dropdown
3Optionally map 'Phone' if you have a phone number column
4Map 'Created At' to track when the customer first signed up

✓ What you should see: Email field should populate with the test customer's email address from Shopify.

⚠

Common mistake — Some customers don't provide phone numbers — this field may be empty for guest checkouts

Action > Configure > Field Mapping

Map Order Metrics

Connect total spent and order count fields for segmentation. These metrics update in real-time as customers place additional orders.

1Click in your 'Total Spent' column field
2Select 'Total Spent' from the Shopify trigger data
3Click in your 'Total Orders' column field
4Select 'Orders Count' from the dropdown options

✓ What you should see: Both fields should show numerical data like '$150.00' and '1' for a new customer.

⚠

Common mistake — Total spent shows lifetime value including the first order — it's not zero for new customers

Action > Configure > Field Mapping

Add Customer Acquisition Date

Track when each customer first purchased to analyze acquisition trends. This timestamp helps with cohort analysis and retention tracking.

1Click in your 'Acquisition Date' or 'First Order' column
2Select 'Created At' from the Shopify customer data
3Choose your preferred date format from the formatter options
4Click 'Continue' to finish field mapping

✓ What you should see: Date field should display the customer creation timestamp in your chosen format.

Action > Test & Review

Test the Complete Workflow

Run a full test to verify data flows correctly from Shopify to Google Sheets. This creates an actual row with real customer data.

1Click 'Test & Continue' to run the complete workflow
2Check your Google Sheet to confirm the new row was created
3Verify all mapped fields populated with correct data
4Review the timestamp and formatting of each column

✓ What you should see: A new row should appear in your Google Sheet with all customer data properly formatted.

⚠

Common mistake — This test creates a real row in your sheet — delete it if you don't want test data in production

Zapier

▶ Turn on & test

executed

✓

Google Sheets

✓

Shopify

🔔 notification

received

Settings > Error Handling

Configure Error Handling

Set up error handling for API failures or missing data. This prevents the Zap from breaking when Shopify or Google Sheets has connectivity issues.

1Click on the Zap settings gear icon
2Select 'Error Handling' from the menu
3Choose 'Pause Zap after 3 consecutive errors'
4Enable email notifications for failed runs

✓ What you should see: Error handling settings should show as configured with notification preferences saved.

⚠

Common mistake — Don't set it to 'Continue on Error' — you'll miss failed customer exports and lose data

Zap Editor > Publish

Activate Your Zap

Turn on the automation to start capturing new customers automatically. The Zap will check for new customers every 15 minutes and export their data.

1Click 'Publish Zap' in the top right corner
2Confirm activation when prompted
3Monitor the Zap history for the first few runs
4Check your Google Sheet after the next customer order

✓ What you should see: Your Zap should show as 'On' with a green toggle switch and start processing new customers.

⚠

Common mistake — New customers only trigger after activation — existing customers won't be retroactively exported

Drop this into a Zapier Code step.

Copy this template{{first_name}} {{last_name}} | {{orders_count}} orders | ${{total_spent}}

▸ Show code

{{first_name}} {{last_name}} | {{orders_count}} orders | ${{total_spent}}

... expand to see full code

{{first_name}} {{last_name}} | {{orders_count}} orders | ${{total_spent}}

Scaling Beyond 500+ new customers/month+ Records

If your volume exceeds 500+ new customers/month records, apply these adjustments.

Switch to Shopify Webhooks

Upgrade to Zapier's premium Shopify triggers that use webhooks instead of polling. This reduces API calls and provides instant customer exports instead of 15-minute delays.

Add Rate Limit Buffers

Insert 30-second delay actions between trigger and Google Sheets to prevent hitting API limits during traffic spikes. This is essential during flash sales or marketing campaigns that drive customer bursts.

Going live

Production Checklist

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

Set error handling to pause Zap after 3 consecutive failures

Applies when: Always

Test with real customer order, not sample data from trigger setup

Applies when: Always

Verify Google Sheet column headers match mapped fields exactly

Applies when: Always

Set up Zap run notifications to catch API failures during high-traffic periods

Applies when: High volume

Add date formatting to timestamp fields for consistent data display

Applies when: Always

Check Shopify webhook endpoint limits if upgrading to premium triggers

Applies when: Enterprise

Troubleshooting

Common errors and how to fix them.

Frequently Asked Questions

Common questions about this workflow.

Analysis

VerdictWhy Zapier for this workflow

Use Zapier for this if you want customer data flowing to Google Sheets without coding. Setup takes 15 minutes and works reliably for stores processing under 1,000 new customers monthly. The visual field mapping beats writing Shopify API calls, and Google Sheets integration handles formatting automatically. Skip Zapier if you need real-time exports faster than 15-minute polling — use Shopify webhooks to a custom script instead.

Cost

This workflow costs 2 tasks per new customer (1 for trigger, 1 for sheet row). At 200 new customers monthly, that's 400 tasks fitting Zapier's Starter plan at $19.99/month. Make would cost $9/month for the same volume with 1,000 operations included. N8n is free but requires server hosting at $5-10/month. Make wins on pure cost, but Zapier's Google Sheets connector handles edge cases better.

Tradeoffs

Make offers superior Shopify triggers with webhook support for instant customer exports instead of 15-minute delays. N8n includes a customer deduplication node that prevents duplicate exports when customers update profiles. But Zapier's Google Sheets integration automatically handles data type conversion and column formatting that requires manual setup in other platforms. For non-technical users managing moderate volume, Zapier's reliability trumps the cost savings.

You'll hit Shopify's API rate limits at 500+ customers per hour, causing temporary delays but not failures. Google Sheets caps at 100 API calls per 100 seconds, so bursts of new customers may queue up during flash sales. Customer data can take 2-3 minutes to appear in Shopify after order completion, meaning your sheet sometimes logs customers before their first order shows in your Shopify admin.

Ideas for what to build next

→
Set up customer segmentation alerts — Create additional Zaps that send Slack notifications when high-value customers (over $500 spent) are added to your sheet.
→
Add order history tracking — Build a second automation that logs individual order details to a separate sheet, linking back to customer data via email address.
→
Create abandoned cart recovery — Set up a workflow that triggers email campaigns for customers who create accounts but don't complete their first purchase within 24 hours.