Shopify Abandoned Cart Recovery Tracker in Google Sheets (n8n)

A Shopify abandoned cart recovery tracker in Google Sheets, built with n8n, logs every abandoned checkout to a spreadsheet and flips each row to Recovered the moment the shopper comes back and buys. You always know which carts are still open, which were saved, and how much revenue you clawed back. It runs on two Shopify triggers and one shared sheet, needs no paid recovery app, and costs effectively nothing to run.

Prefer to skip the setup? The ready-made template imports in under 10 minutes. Jump to the template section below.

What it does

Most stores treat abandoned carts as a black box: Shopify sends one or two recovery emails, and whatever happens after that is invisible. This workflow turns that black box into a living ledger.

Every time a shopper starts a checkout and walks away, n8n catches the event and writes a row to a Google Sheet: who they were, what was in the cart, how much it was worth, the recovery link, and a status of Abandoned. When that same shopper later returns and completes an order, a second flow finds the matching row by checkout ID and flips it to Recovered, stamping the date and the amount saved.

The result is a spreadsheet you actually own. Filter it to see every open cart from this week, sort by value to chase the biggest ones first, or sum the Recovered column to see exactly how much abandoned revenue you brought back. It slots neatly alongside the rest of your n8n Shopify automation stack.

Why it beats the default

Shopify already shows an abandoned checkout report, so why build this? Because the native report is a dead end. You cannot edit it, you cannot add a note, you cannot join it to anything, and you certainly cannot hand a filtered slice of it to an assistant to work through.

• It is yours. The data lives in a sheet you control. Add columns, pivot it, build a chart, or pipe it into another tool later.
• It tracks outcomes, not just events. The native report lists abandoned checkouts. This one tells you which ones were recovered and how much money came back, in the same row.
• No per-message billing. There is no recovery app subscription and no email-credit meter. The whole thing runs on webhooks and a free Google Sheet.
• It is a foundation. Once the ledger exists, layering on a Gmail nudge, a Slack alert for high-value carts, or a weekly digest is a small addition rather than a new project.

What you need

• A Shopify store on any paid plan, with an app that has read access to orders and checkouts.
• An n8n instance, either n8n Cloud or self-hosted.
• A Google account and one Google Sheet for the tracker.
• About 30 minutes to build from scratch, or under 10 with the template.

How it works — the big picture

ABANDONED CART RECOVERY TRACKER

Flow A — log abandoned carts
  [Shopify Trigger: checkouts/update] -> [Filter: has email, not paid]
        -> [Edit Fields: build row, Status = Abandoned]
        -> [Google Sheets: Append or Update on Checkout ID]
                                |
                                v
                     +----------------------+
                     |  Google Sheet ledger |
                     |  (one row per cart)  |
                     +----------------------+
                                ^
                                |
Flow B — mark recovered
  [Shopify Trigger: orders/create] -> [Edit Fields: map checkout_id, Status = Recovered]
        -> [Google Sheets: Append or Update on Checkout ID]

Node-by-node list

Seven nodes across two independent flows that share one sheet:

Step-by-step build

Build the sheet first, then the two flows.

1. Create the Google Sheet. Make a new sheet named Tracker with these headers in row 1: Checkout ID, Date, Customer, Email, Items, Cart Value, Currency, Recovery URL, Status, Recovered At. The exact spelling matters because n8n matches on these names.
2. Add the abandoned checkout trigger. Add a Shopify Trigger node, connect your Shopify credential, and set Topic to Checkout Updated (checkouts/update). Shopify fires this when a cart is started and then sits idle.
3. Filter to real abandoned carts. Add a Filter node after the trigger. Add two conditions, combined with AND: {{ $json.email }} is not empty, and {{ $json.completed_at }} is empty. This drops anonymous carts and any checkout that already became an order.
4. Shape the row. Add an Edit Fields node (Set). Switch to Manual mapping and add one assignment per column. For example, map Checkout ID to ={{ $json.id }}, Email to ={{ $json.email }}, Cart Value to ={{ $json.total_price }}, Recovery URL to ={{ $json.abandoned_checkout_url }}, and set Status to the fixed string Abandoned.
5. Log to the sheet. Add a Google Sheets node, Operation Append or Update Row. Pick your document and the Tracker sheet, then set Column to match on to Checkout ID. Map each column to the field you built in the Edit Fields node. Append or Update is what keeps one row per cart even when Shopify fires the event several times.
6. Add the recovery trigger. Add a second Shopify Trigger node with Topic Order Created (orders/create). This is a separate entry point, not wired into Flow A.
7. Mark the cart recovered. Add an Edit Fields node after it. Map Checkout ID to ={{ $json.checkout_id }}, set Status to Recovered, map Recovered At to ={{ $now.toISO() }}, and map Cart Value to ={{ $json.total_price }} so the saved amount reflects the real order.
8. Update the same row. Add a final Google Sheets node, Operation Append or Update Row, matched on Checkout ID again. Because the abandoned row already carries that checkout ID, this lands on it and flips the status instead of adding a new line.
9. Save and activate. Save the workflow and toggle it Active. Run a test checkout, then complete it, and watch the row go from Abandoned to Recovered.

The data structure

A row moves through two states. Here is the same cart before and after recovery.

Common mistakes

• Skipping the completed_at filter. Without it, every checkout update, including completed ones, lands in the tracker and inflates your abandoned count.
• Using Append instead of Append or Update. Plain Append adds a fresh row on every Shopify fire, so one cart becomes five rows. Always match on Checkout ID.
• Matching the recovery flow on email. Email is not unique per cart. Match on checkout_id so a repeat shopper does not overwrite an unrelated open cart.
• Wrong Set node version. Use the current Edit Fields node with named assignments. Old tutorials show a key-value table that behaves differently and breaks expressions.
• Confusing the topics. Use checkouts/update for abandonment and orders/create for recovery. checkouts/create fires too early, before the cart is meaningfully abandoned.

Cost at realistic volume

This is one of the cheapest automations you can run because it never touches a paid messaging service.

Self-hosted n8n makes the marginal cost zero. On n8n Cloud, even a busy store stays inside an entry plan, since each cart costs only one or two executions across both flows.

Frequently asked questions

Related guides

• Shopify abandoned checkout email sequence with n8n
• Shopify customer win-back email with n8n
• Send new Shopify orders to Google Sheets
• Browse more in the Shopify automation category.