Why don't I see all my abandoned carts in the spreadsheet?

Shopify only tracks abandonment when customers enter an email address. Anonymous browsers and guest checkouts without email won't trigger this automation.

Can I track how long customers spent on checkout before abandoning?

Not directly through this automation. Shopify's abandoned checkout webhook doesn't include session duration data — you'd need custom analytics for that.

What happens if my Google Sheet reaches the row limit?

Google Sheets caps at 10 million cells. At 6 columns, that's 1.6 million abandoned carts before you hit limits. Archive old data annually or create monthly sheets.

Can I add product images or SKUs to the tracking?

Yes, go back to your Zap's field mapping and add columns for 'Line Items Image URL' and 'Line Items SKU' from the Shopify abandoned checkout data.

How long do the cart recovery URLs stay valid?

Shopify expires abandoned checkout URLs after 30 days. They also become invalid if the customer completes purchase through another method or channel.

Beginner~8 min setupProductivity & E-commerceVerified April 2026

How to Track Abandoned Carts from Shopify to Google Sheets with Zapier

Automatically log abandoned checkouts from Shopify to a Google Sheets spreadsheet with customer email, cart value, and product details for manual follow-up or recovery campaigns.

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 who want simple abandoned cart tracking without custom development.

Not ideal for

High-volume stores processing 1,000+ abandoned carts monthly or teams needing advanced product data formatting.

Sync type

real-time

Use case type

notification

Real-World Example

💡

A 8-person fashion e-commerce brand uses this to track their 150 weekly abandoned carts worth an average $85 each. Their marketing manager reviews the Google Sheet every morning and personally emails high-value abandoners ($200+) with styling tips. Before automation, they relied on Shopify's basic abandonment emails and missed the personal touch that recovers 15% more carts.

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.

Shopify store with admin or staff permissions

Google account with Google Sheets access

Zapier account (free tier works for basic volume)

Optional

At least one recent abandoned checkout in your Shopify store for testing

Field Mapping

Map these fields between your apps.

Field	API Name	Description
Required
Email	`email`	Customer email address from the abandoned checkout
Cart Value	`total_price`	Total cart value including taxes and shipping
Products	`line_items[].name`	Comma-separated list of abandoned product names
Abandoned Date	`created_at`	Timestamp when cart was abandoned

2 optional fields▸ show

Customer Name	`billing_address.name`	Full name from billing address or customer profile
Cart URL	`abandoned_checkout_url`	Direct link for customer to complete purchase

Step-by-Step Setup

Google Sheets > New Spreadsheet

Create the Google Sheets spreadsheet

Set up your tracking spreadsheet with the right column headers before connecting to Zapier. This ensures clean data organization from the first abandoned cart.

1Open Google Sheets and create a new blank spreadsheet
2Name it 'Abandoned Cart Tracking' in the top left
3Add these headers in row 1: Email, Customer Name, Cart Value, Products, Abandoned Date, Cart URL
4Format column C as currency by selecting it and clicking Format > Number > Currency

✓ What you should see: Your spreadsheet should have 6 labeled columns with currency formatting on Cart Value.

Dashboard > Create Zap > Trigger

Start a new Zap in Zapier

Create the automation workflow that will connect Shopify abandoned carts to your spreadsheet. Zapier's guided builder walks you through each connection.

1Log into your Zapier account and click 'Create Zap' in the top left
2Click the trigger box and search for 'Shopify'
3Select 'Shopify' from the app list
4Choose 'Abandoned Checkout' as your trigger event

✓ What you should see: You should see 'Shopify: Abandoned Checkout' as your trigger with a setup button.

⚠

Common mistake — Don't select 'Updated Order' or 'New Order' — those fire on completed purchases, not abandonment.

Trigger Setup > Account > Sign In

Connect your Shopify account

Authenticate your Shopify store so Zapier can access abandoned checkout data. This requires admin permissions on your store.

1Click 'Sign in to Shopify' in the account connection box
2Enter your Shopify store URL (yourstore.myshopify.com)
3Click 'Install app' to grant Zapier access
4Return to Zapier and click 'Continue' when you see the green connected status

✓ What you should see: You should see your Shopify store name with a green 'Connected' badge.

⚠

Common mistake — You need admin or staff permissions with 'Orders' access — basic user accounts won't work.

Zapier settings

Connection

Choose a connection…Add

click Add

Google Sheets

Authorize Zapier

popup window

✓

Connected

green checkmark

Trigger Setup > Options

Configure the abandoned checkout trigger

Set up the specific conditions for when Zapier should capture abandoned carts. The default settings work for most stores but you can add filters later.

1Leave 'Store' set to your connected Shopify account
2Set 'Abandoned Checkout Email' to 'Yes' to only track carts with email addresses
3Click 'Continue' to proceed to testing
4Click 'Test trigger' to fetch a recent abandoned checkout

✓ What you should see: Zapier should display sample abandoned checkout data with fields like email, total_price, and line_items.

⚠

Common mistake — If no test data appears, you may not have recent abandoned checkouts — the trigger will still work when new ones occur.

Zapier

click +

search apps

Google Sheets

Configure the abandoned chec…

Google Sheets

module added

Action Setup > App Selection

Add Google Sheets as your action

Connect the second half of your automation to write abandoned cart data to your tracking spreadsheet. This creates a new row for each abandoned checkout.

1Click the action box below your Shopify trigger
2Search for and select 'Google Sheets'
3Choose 'Create Spreadsheet Row' as the action event
4Click 'Continue' to proceed to account connection

✓ What you should see: You should see 'Google Sheets: Create Spreadsheet Row' as your action step.

Action Setup > Account > Sign In

Connect your Google account

Authenticate with Google so Zapier can write to your spreadsheets. This requires Google Sheets access permissions.

1Click 'Sign in to Google Sheets'
2Select your Google account from the list
3Click 'Allow' when prompted for Google Sheets permissions
4Return to Zapier and click 'Continue' when connected

✓ What you should see: Your Google account email should appear with a green 'Connected' status.

⚠

Common mistake — Use the same Google account that owns your abandoned cart tracking spreadsheet.

Action Setup > Spreadsheet Selection

Select your tracking spreadsheet

Point Zapier to the specific spreadsheet you created earlier. This tells the automation exactly where to write abandoned cart data.

1Click the 'Spreadsheet' dropdown and select 'Abandoned Cart Tracking'
2Set 'Worksheet' to 'Sheet1' (the default first tab)
3Verify the spreadsheet URL shows your correct file
4Click 'Continue' to proceed to field mapping

✓ What you should see: You should see your spreadsheet name selected with Sheet1 as the worksheet.

⚠

Common mistake — If your spreadsheet doesn't appear in the list, refresh the page — sometimes new files take a moment to sync.

Action Setup > Field Mapping

Map abandoned cart data to spreadsheet columns

Connect each piece of Shopify data to the right column in your tracking sheet. This determines what information gets logged for each abandoned cart.

1Click the 'Email' field and select 'Email' from the Shopify data dropdown
2Set 'Customer Name' to map to 'Billing Address Name' or 'Customer Display Name'
3Map 'Cart Value' to 'Total Price' from the Shopify abandoned checkout
4For 'Products', select 'Line Items Name' to get product titles
5Set 'Abandoned Date' to 'Created At' timestamp

✓ What you should see: Each column field should show mapped Shopify data in purple pill format.

⚠

Common mistake — Don't use 'Subtotal Price' for cart value — it excludes taxes and shipping that customers saw.

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 Setup > Field Mapping

Add the cart recovery URL

Include the direct link that takes customers back to their abandoned cart. This makes manual follow-up much easier since they can complete checkout in one click.

1Click the 'Cart URL' field in your mapping
2Select 'Abandoned Checkout URL' from the Shopify data options
3Scroll down and click 'Continue' to proceed to testing
4Review your field mappings to ensure they're all correct

✓ What you should see: The Cart URL field should show the Shopify 'Abandoned Checkout URL' mapped.

⚠

Common mistake — This URL expires after 30 days — don't rely on it for long-term recovery campaigns.

Action Setup > Test

Test your complete automation

Run a full test to ensure data flows correctly from Shopify to your Google Sheet. This catches any mapping issues before you go live.

1Click 'Test action' to send the sample abandoned cart to your sheet
2Open your Google Sheets file in a new tab to verify the data appeared
3Check that the email, cart value, and products populated correctly
4Return to Zapier and click 'Continue' when the test passes

✓ What you should see: You should see a new row in your spreadsheet with the test abandoned cart data.

⚠

Common mistake — If the test fails with a 'permission denied' error, check that your Google account has edit access to the spreadsheet.

Zapier

▶ Turn on & test

executed

✓

Google Sheets

✓

Shopify

🔔 notification

received

Zap Editor > Turn On

Turn on your Zap

Activate the automation so it starts tracking new abandoned carts automatically. Once live, it will create a new spreadsheet row within 1-15 minutes of each abandonment.

1Click 'Turn on Zap' in the top right corner
2Add a descriptive name like 'Shopify Abandoned Carts to Google Sheets'
3Click 'Turn on Zap' to confirm and activate
4You should see 'Zap is ON' status with a green toggle

✓ What you should see: Your Zap dashboard should show the automation as 'On' with a green status indicator.

Scaling Beyond 500+ abandoned carts/month+ Records

If your volume exceeds 500+ abandoned carts/month records, apply these adjustments.

Switch to Make for better pricing

At 500+ tasks monthly, Make costs $9 vs Zapier's $50 Professional plan. The setup is more complex but saves $500/year.

Add cart value filters

Filter out carts under $25-50 to focus on higher-value recovery opportunities. Reduces task usage by 30-40% in most stores.

Going live

Production Checklist

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

Test with a real abandoned cart from your store, not just Zapier's sample data

Applies when: Always

Verify currency formatting in Google Sheets matches your store's currency

Applies when: Always

Set up Zap error notifications to catch failed writes to your spreadsheet

Applies when: Always

Add a filter to exclude abandoned carts under $10 to reduce noise

Applies when: High volume

Share the Google Sheet with your marketing team with appropriate edit/view permissions

Applies when: Always

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 dead-simple setup and your team doesn't code. Takes 15 minutes to configure and works reliably with Shopify's webhook system. The trigger fires within 1-15 minutes of cart abandonment, which is fast enough for most recovery campaigns. Skip Zapier if you're tracking 1,000+ abandoned carts per month — Make handles that volume cheaper and gives you better data transformation options.

Cost

This workflow burns 1 task per abandoned checkout. At 200 abandonments monthly, that's 200 tasks total. Fits comfortably in Zapier's Starter plan at $20/month (750 tasks). Make would cost $9/month for the same volume, and n8n runs free if you self-host. Zapier costs more but saves you 2-3 hours of setup complexity.

Tradeoffs

Make gives you better product data handling — you can loop through line items and format them as a clean list instead of Zapier's comma-separated dump. N8n lets you add custom JavaScript to calculate abandonment timing or cart recovery probability. But Zapier connects to Shopify's abandoned checkout webhook faster than Make's 1-minute polling, and the setup wizard prevents the field mapping errors that trip up n8n beginners.

You'll hit two main issues after going live. First, Shopify only triggers abandoned checkouts when customers enter an email address — anonymous browsers don't generate events, so you're missing 40-60% of actual abandonment. Second, the abandoned checkout URLs expire after 30 days, so don't build long-term nurture campaigns around them. Plan manual outreach within 1-2 weeks max.

Ideas for what to build next

→
Set up automated email recovery — Connect your email platform (Mailchimp, Klaviyo) to send personalized recovery emails when high-value carts appear in your sheet.
→
Add SMS recovery for mobile customers — Use Zapier's SMS apps to text customers who abandon carts over $100, since mobile users respond better to texts than emails.
→
Create abandonment analytics dashboard — Build Google Sheets pivot tables or connect to Data Studio to track abandonment trends by product category, cart value, and time of day.