How to extract data from Gmail emails into Google Sheets

By Jake Marsh · Updated

To extract data from Gmail into Google Sheets, open Rowcatch, start an export and add a column for each value you need. Set From to Body text and Take to Text after a label (for "Order number: 1042"), Text between two markers, Pattern (regex) or Line number, then pick a Format such as Amount (strip currency) or Date (YYYY-MM-DD). Click Preview on 20 emails to check every column on real emails before you export.

How a column rule works

Every column in step 2 has four parts:

PartWhat it does
ColumnThe header in your sheet, such as "Invoice number"
FromWhere to look: Body text, Subject, Sender name, Sender email, To, Cc, Reply-To, Labels, Attachment names, Another header and more
TakeWhich part to keep (the six rules below)
FormatHow to write it: As found, Trim spaces, Number, Amount (strip currency), Date (YYYY-MM-DD), Date and time, lowercase, UPPERCASE, First email address, First phone number

HTML emails are turned into plain text first, so a value in a table cell reads the same as one in a line of text. Tick Ignore quoted replies in the body to leave out the earlier messages quoted under a reply.

The six Take rules

All of it

The whole field. Use it for Subject, Sender email or Labels.

Text after a label

The rest of the line after a label. Type Order number and an email line "Order number: 1042" gives 1042. Separate several spellings with |, as in Order number|Order #|Order ID; Rowcatch tries the longest first. When the label sits alone on its line, as it often does in HTML tables, Rowcatch takes the next line instead.

Text between

Everything between a start marker and an end marker, without matching case. Start Ship to: and end Phone gives the whole address block in between.

Pattern (regex)

A regular expression for values with a fixed shape. If the pattern has a group in parentheses, the group is what lands in the cell. Total:\s*\$([\d.,]+) turns "Total: $1,234.50" into 1,234.50. Add flags such as i to ignore case.

Line number

One line of the field, counting non-empty lines from 1. Handy for notification emails where the value is always on the same line.

Combine (template)

Builds a cell from other columns or fields, for example {{From email}} / {{Order number}}. A template can use any column to its left, or a field name such as {{subject}}.

Worked example: an invoice email

Say your supplier's emails read:

Invoice #INV-2207
Amount due: $1,480.00
Due date: November 30, 2026
ColumnFromTakeFormatResult
Invoice numberBody textText after a label: Invoice #As foundINV-2207
AmountBody textText after a label: Amount dueAmount (strip currency)1480
Due dateBody textText after a label: Due dateDate (YYYY-MM-DD)2026-11-30
VendorSender nameAll of itAs foundthe supplier's name

Amount (strip currency) writes a real number Sheets can add up, and it reads both $1,234.56 and 1.234,56 EUR.

Check before you export

  1. Click Preview on 20 emails. Each column shows its value, or "not found", for every email.
  2. Read the hit counts. The preview shows how many of the 20 emails each column found a value in. A column at 3 of 20 usually needs another label spelling.
  3. Click a row to see that email next to its values, with the matched text highlighted in the body. Change the rule and click Preview again.

When the columns look right, create the spreadsheet in step 4 and export. The steps for that part are in how to export Gmail emails to Google Sheets.

Start from a template

The Replace with a template... menu in step 2 loads ready-made columns for Orders, Leads and contact forms, Invoices and receipts, and Form notifications. They're ordinary rules, so you can open each one and see how it's built. Order confirmation emails to Google Sheets walks through the Orders one.

What it costs

Your first 100 exported emails or 7 days are free, whichever comes first, with every feature. Then Rowcatch is $39, $70 or $99 a month per Google account depending on how many saved exports and emails a month you need. Previews never use trial emails. 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

Can I extract data from email attachments?

Rowcatch reads the email itself: headers, subject and body. It records attachment names and the attachment count, but it doesn't open PDF or spreadsheet attachments.

What if a value isn't in every email?

The cell stays empty for that email and the rest of the row is written. The preview's hit counts show how often each column finds something.

Can one column hold several matches?

Yes. The Items column in the Orders template collects every item line in the email, joined with commas. Start from that template and change its pattern to collect other repeated values.

Do I need to know regular expressions?

No. Text after a label and Text between cover most emails, and the templates show working patterns you can copy.


More Rowcatch guides


More Chrome guides