Why does total_spent show $0 for new customers?

Shopify only updates total_spent after completed purchases. New registrations show $0 until their first order processes. Use orders_count > 0 to identify paying customers.

Can I export existing customers, not just new ones?

The New Customer trigger only captures registrations after activation. Use Shopify's 'Get Customers' action in a separate scenario to backfill existing customer data.

How do I handle duplicate customers in my sheet?

Add a Google Sheets 'Search Rows' module before 'Add Row' to check if the email exists. Use a Router to branch between adding new rows or updating existing ones.

What happens if my scenario is offline when customers register?

Those customers won't be captured since Make doesn't queue missed triggers. Run a one-time 'Get Customers' action to backfill any gaps from downtime periods.

Can I filter customers by purchase amount or location?

Add a Filter module between Shopify and Google Sheets. Set conditions like total_spent > 100 or check the default_address.country field to only export customers meeting your criteria.

Beginner~12 min setupProductivity & E-commerceVerified April 2026

How to Export Shopify Customers to Google Sheets with Make

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

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

Make

Also on:Zapier N8n

Best for

E-commerce stores wanting automatic customer segmentation data in spreadsheets without manual CSV exports.

Not ideal for

Stores needing instant export or complex customer lifecycle tracking beyond basic purchase history.

Sync type

polling

Use case type

export

Real-World Example

💡

A 12-person Shopify store selling outdoor gear uses this to build email segmentation lists in Google Sheets. Before automation, their marketing manager exported customer CSVs weekly and manually sorted by purchase history — missing new high-value customers for 7 days. Now customer data flows automatically for immediate outreach to big spenders.

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 Make

Copy the pre-built Make blueprint and paste it straight into Make. 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.

Active Shopify store with admin access

Google account with Google Sheets access

Make account (free tier works for testing)

At least one existing customer in Shopify for testing

Field Mapping

Map these fields between your apps.

Field	API Name	Description
Required
First Name	`first_name`	Customer's first name from Shopify account registration
Last Name	`last_name`	Customer's last name from Shopify account registration
Email	`email`	Primary email address used for customer account login

3 optional fields▸ show

Total Orders	`orders_count`	Lifetime number of completed orders by this customer
Total Spent	`total_spent`	Lifetime amount spent including taxes and shipping in store currency
Created Date	`created_at`	ISO timestamp when customer account was first created

Step-by-Step Setup

Dashboard > Create scenario > Add module

Create new scenario in Make

Set up a new scenario that will monitor for new Shopify customers. This creates the foundation for your customer export automation.

1Click the orange 'Create a new scenario' button on your Make dashboard
2Click the large '+' icon in the center of the scenario builder
3Search for 'Shopify' in the app search bar
4Select 'Shopify' from the results list

✓ What you should see: You should see the Shopify app icon in your scenario with a list of available triggers and actions.

Scenario > Shopify module > New Customer

Configure Shopify New Customer trigger

Select the trigger that fires whenever someone creates an account on your store. This captures all new customer registrations in real-time.

1Click on 'New Customer' from the Shopify trigger options
2Click 'Create a connection' to link your Shopify store
3Enter your Shopify store URL (yourstore.myshopify.com)
4Click 'Continue' and authorize Make to access your Shopify data

✓ What you should see: The connection should show a green 'Connected' status and the trigger module should display 'Shopify - New Customer'.

⚠

Common mistake — Don't confuse 'New Customer' with 'New Order' — the latter triggers on purchases, not account creation.

Make

click +

search apps

Google Sheets

Configure Shopify New Custom…

Google Sheets

module added

Shopify module > Run once

Test Shopify connection

Run a test to pull sample customer data from your store. This ensures the connection works and shows you what data fields are available.

1Click the 'Run once' button at the bottom of the Shopify module
2Wait for the test to complete (usually 5-10 seconds)
3Review the sample customer data that appears
4Click 'OK' to confirm the test worked

✓ What you should see: You should see customer data including fields like first_name, last_name, email, and total_spent displayed in the test panel.

⚠

Common mistake — If no data appears, create a test customer in your Shopify admin first — the trigger needs existing data to pull from.

Make

▶ Run once

executed

✓

Google Sheets

✓

Shopify

🔔 notification

received

Scenario > Add module > Google Sheets > Add a Row

Add Google Sheets module

Connect Google Sheets to receive the customer data. This will create new rows in your spreadsheet for each new Shopify customer.

1Click the '+' icon to the right of your Shopify module
2Search for 'Google Sheets' in the app list
3Select 'Google Sheets' from the results
4Choose 'Add a Row' as your action

✓ What you should see: A Google Sheets module should appear connected to your Shopify trigger, showing 'Google Sheets - Add a Row'.

Google Sheets module > Create connection

Connect Google Sheets account

Link your Google account so Make can write to your spreadsheets. This establishes the authentication needed to add customer rows.

1Click 'Create a connection' in the Google Sheets module
2Select your Google account from the list or add a new one
3Click 'Allow' to grant Make permission to access your Google Sheets
4Verify the connection shows as 'Connected'

✓ What you should see: The connection dropdown should display your Google account email with a green connected indicator.

⚠

Common mistake — Make sure you're connecting the Google account that owns or has edit access to your target spreadsheet.

Make settings

Connection

Choose a connection…Add

click Add

Google Sheets

Authorize Make

popup window

✓

Connected

green checkmark

Google Sheets module > Spreadsheet > Sheet

Select target spreadsheet and worksheet

Choose which specific Google Sheet and tab will receive your customer data. You can create a new sheet or use an existing one.

1Click the 'Spreadsheet' dropdown and select your target sheet
2If creating new, click 'Add' and name it 'Shopify Customers'
3Select 'Sheet1' from the 'Sheet' dropdown (or your preferred tab name)
4Set 'Values input option' to 'User entered'

✓ What you should see: Both dropdowns should show your selected spreadsheet name and worksheet tab.

⚠

Common mistake — Don't select 'Raw' for values input — this prevents proper formatting of numbers and dates.

Google Sheets module > Values > Column A/B

Map customer name fields

Connect Shopify's customer name data to specific columns in your sheet. This creates the first part of your customer record.

1Click in the first 'Value' field under Column A
2Select 'first_name' from the Shopify data dropdown
3Click in the Column B value field
4Select 'last_name' from the Shopify data dropdown

✓ What you should see: Column A should show '1. first_name' and Column B should show '1. last_name' as the mapped values.

⚠

Common mistake — The numbers (1.) indicate which step's data you're using — make sure they all show '1.' from your Shopify trigger.

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

Google Sheets module > Values > Column C/D

Map email and order data

Add the customer's email address and purchase history to complete their profile. This gives you the key data for segmentation and outreach.

1Click in the Column C value field
2Select 'email' from the Shopify data options
3Click in the Column D value field
4Select 'orders_count' from the available fields

✓ What you should see: Column C should display '1. email' and Column D should show '1. orders_count' in the value fields.

⚠

Common mistake — orders_count shows lifetime orders, not just recent ones — this gives you total purchase history.

Google Sheets module > Values > Column E

Map total spent amount

Add the customer's total spending to track their value. This completes your customer profile with financial data for segmentation.

1Click in the Column E value field
2Select 'total_spent' from the Shopify data dropdown
3Verify all five columns have mapped data
4Check that the values show the correct Shopify field names

✓ What you should see: Column E should display '1. total_spent' and all five columns should have blue-highlighted mapped values.

⚠

Common mistake — total_spent includes taxes and shipping — if you need product-only amounts, you'll need additional calculations.

Scenario > Run once

Test the complete scenario

Run your full automation to verify customer data flows correctly from Shopify to Google Sheets. This confirms everything works before going live.

1Click 'Run once' button at the bottom left of the scenario
2Watch both modules execute (they'll show green checkmarks when complete)
3Open your Google Sheet to verify a new row was added
4Check that all customer data appears correctly formatted

✓ What you should see: Your Google Sheet should have a new row with the test customer's name, email, order count, and total spent properly filled in.

⚠

Common mistake — If the sheet row is empty, check that your columns are mapped correctly — blank fields usually mean wrong field selection.

Google Sheets > Insert row > Add headers

Add column headers

Create clear headers in your spreadsheet so you can easily identify each data column. This makes your exported data readable and organized.

1Open your Google Sheet in a new browser tab
2Right-click on row 1 and select 'Insert 1 above'
3Add headers: First Name, Last Name, Email, Total Orders, Total Spent
4Bold the header row for easy identification

✓ What you should see: Row 1 should contain clear headers, with your customer data starting in row 2.

Scenario > Schedule > Toggle ON

Schedule and activate scenario

Turn on automatic execution so new customers are exported without manual intervention. This makes your customer export run continuously.

1Click the clock icon next to 'Run once'
2Set scheduling to 'Every 15 minutes' for near real-time updates
3Click 'OK' to save the schedule
4Toggle the scenario 'ON' using the switch in the bottom left

✓ What you should see: The scenario should show 'ON' status with a green indicator and 'Every 15 minutes' scheduling active.

⚠

Common mistake — Don't set it to run every minute — Shopify's API has rate limits and you'll waste operations on empty checks.

Drop this into a Make custom function.

JavaScript — Custom Function{{if(1.orders_count > 0; 1.total_spent; "New Customer")}}

▸ Show code

{{if(1.orders_count > 0; 1.total_spent; "New Customer")}}

... expand to see full code

{{if(1.orders_count > 0; 1.total_spent; "New Customer")}}

Scaling Beyond 200+ new customers/month+ Records

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

Add duplicate prevention

Use Google Sheets 'Search Rows' module before adding new rows. Search by email field to prevent duplicate entries if customers update their profiles multiple times.

Implement batch processing

Switch from individual row adds to batch operations using 'Add Multiple Rows'. This reduces API calls and prevents Google Sheets rate limiting at high volumes.

Add retry logic for rate limits

Configure error handling with 2-minute retry intervals for 429 errors. Google Sheets API has quotas that can be hit during traffic spikes.

Going live

Production Checklist

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

Add column headers to your Google Sheet before going live

Applies when: Always

Set error handling to 'Break' not 'Ignore' to catch API issues

Applies when: Always

Test with a real new customer registration, not sample data

Applies when: Always

Verify total_spent currency matches your store's base currency

Applies when: Always

Add duplicate detection using Search Rows before Add Row

Applies when: High volume

Set up email notifications for scenario failures

Applies when: Enterprise

Troubleshooting

Common errors and how to fix them.

Frequently Asked Questions

Common questions about this workflow.

Analysis

VerdictWhy Make for this workflow

Use Make for this if you want near real-time customer export with detailed purchase history. The visual builder makes field mapping obvious, and Make's 1,000 operations/month free tier handles most small stores. Unlike Zapier's basic customer triggers, Make pulls total_spent and orders_count in the initial trigger. Skip Make if you need instant export — go with a webhook-based solution instead.

Cost

This workflow uses 1 operation per new customer. At 50 customers/month, that's 50 operations monthly — well within Make's free 1,000 limit. At 500 customers/month, you'll need Make's Core plan at $9/month for 10,000 operations. Zapier charges $20/month for their Starter plan at this volume, while n8n's cloud costs $50/month. Make is clearly cheaper here.

Tradeoffs

Zapier's Shopify integration includes more pre-built customer fields like marketing_opt_in_level without custom mapping. N8n offers better bulk import options if you need to backfill thousands of existing customers at once. But Make's router system handles duplicate detection better than either platform — you can easily branch logic to update existing rows instead of creating duplicates.

You'll discover that Shopify's total_spent includes taxes and shipping, which might skew your customer value calculations. The New Customer trigger only fires on registration, not first purchase, so many rows will show $0 spent initially. Google Sheets API occasionally returns 429 rate limit errors during high-traffic periods — add a retry filter with 2-minute delays to handle this automatically.

Ideas for what to build next

→
Add purchase tracking automation — Create a second scenario using Shopify's 'New Order' trigger to update customer purchase data in real-time when they buy.
→
Set up email marketing sync — Connect your Google Sheets customer data to Mailchimp or ConvertKit to automatically add high-value customers to VIP email sequences.
→
Create customer value alerts — Add a Filter and Slack notification to alert your team when customers cross spending thresholds like $500 or $1,000 lifetime value.