How to log order confirmation emails in Google Sheets

By Jake Marsh · Updated

To log order confirmation emails in Google Sheets, open Rowcatch, click New and pick the Orders template. It searches Gmail for subject:(order OR "new order") newer_than:90d and fills in columns for the date, order number, customer, customer email, total, items, subject and a Gmail link. Click Preview on 20 emails, fix any label your store words differently, create the spreadsheet and export. Duplicates are checked by order number, so each order gets one row.

Who this is for

  • Store owners who get a "new order" email from Shopify, WooCommerce, Etsy, Square or a similar platform for every sale.
  • Anyone who buys from suppliers and wants their order confirmations in one list.
  • Bookkeepers who receive a client's order notifications by email and need totals they can add up.

Steps

  1. Click New, then Orders.
  2. Narrow the search in step 1. The suggested search catches any subject with "order" in it. Add the sender to keep it to one store, for example from:store@example.com subject:order newer_than:1y. Click Find emails to check the list.
  3. Click Preview on 20 emails in step 3 and read each column against the emails.
  4. Fix the columns your store words differently (see the table below).
  5. Create the spreadsheet in step 4. Duplicates is already set to "Skip rows whose value in a column is already there" with the column Order number.
  6. Click Check what will be exported, then Export N emails now.
  7. Set step 5 to Every hour to add new orders while Chrome is open. The toolbar button shows how many rows were added since you last looked.

The Orders columns

ColumnRule it starts withChange it when
DateDate receivedNever needed
Order numberPattern (regex) that finds "Order number", "Order no.", "Order ID" or "Order #" followed by a code with a digit in itYour orders are called something else, like "Confirmation"
CustomerText after a label: Customer|Name|Ship to|Shipping addressThe name sits under another heading
Customer emailText after a label: Email|E-mail, format First email addressRarely
TotalPattern (regex) for "Total" or "Order total", format Amount (strip currency)Your email says "Grand total" or "Amount paid"
ItemsPattern (regex) for lines like "Blue mug x 2", every matchYour items use another layout
Subject, LinkThe subject and a link to the emailNever needed

To change a label, open the column's Take box and add your store's word with a |, for example Customer|Name|Bill to. To change the total, switch Take to Text after a label and type Grand total, keeping the format Amount (strip currency). The rule types are explained in how to extract data from Gmail into Google Sheets.

Why order numbers matter for duplicates

Stores often send the same order twice: once on purchase and again on an edit, or one email to you and a copy to a shared inbox. With duplicates checked on Order number, a second email with an order number already in the sheet is skipped. If you'd rather see every email, pick "One row per email; skip emails already in the sheet" instead.

Adding up totals

Amount (strip currency) writes the total as a number, whether the email says $1,234.56, 1.234,56 EUR or £45. Type =SUM(E:E) under the Total column, or build a pivot table by month from the Date column. Rowcatch keeps any columns and formulas you add next to its own, and new rows line up by column name.

Several stores in one sheet

Create one export per store, each with its own search, and pick the same spreadsheet in step 4 with Or use one Rowcatch created earlier.... Each export writes to its own tab, named after the export. Starter includes 1 saved export, Pro 10 and Business unlimited.

What it costs

The trial covers your first 100 exported emails or 7 days, whichever comes first. Starter is $39 a month for 1,000 emails a month, Pro $70 for 2,000, Business $99 for 4,000, each per Google account. A busy store sending 50 orders a day fits in Pro. Every plan and the install link are on the Rowcatch page.

Rowcatch: Email Parser to Google Sheets for Gmail

Export Gmail emails to Google Sheets with parsing rules, duplicate checks and scheduled sync 3 plans from $39 a month per Google account.


Questions

Does this work with Shopify order notifications?

Yes, if the notification reaches the Gmail account you sign in with. Shopify, WooCommerce, Etsy and Square emails each use slightly different labels, so check the preview and add your store's wording where a column says "not found".

Can Rowcatch read the order from the store directly?

No. Rowcatch reads only your Gmail. Anything that's in the order email can go in the sheet.

What about refund or cancellation emails?

Make a second export with a search such as subject:(refund OR canceled) and its own columns, writing to another tab of the same spreadsheet.

Will old orders be imported too?

Yes. The search decides how far back it goes: change newer_than:90d to newer_than:2y, or use after:2025/01/01. One run writes up to 2,000 emails, and the next run continues.


More Rowcatch guides


More Chrome guides