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:
| Part | What it does |
|---|---|
| Column | The header in your sheet, such as "Invoice number" |
| From | Where to look: Body text, Subject, Sender name, Sender email, To, Cc, Reply-To, Labels, Attachment names, Another header and more |
| Take | Which part to keep (the six rules below) |
| Format | How 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
| Column | From | Take | Format | Result |
|---|---|---|---|---|
| Invoice number | Body text | Text after a label: Invoice # | As found | INV-2207 |
| Amount | Body text | Text after a label: Amount due | Amount (strip currency) | 1480 |
| Due date | Body text | Text after a label: Due date | Date (YYYY-MM-DD) | 2026-11-30 |
| Vendor | Sender name | All of it | As found | the 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
- Click Preview on 20 emails. Each column shows its value, or "not found", for every email.
- 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.
- 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
- How to send new Gmail emails to Google Sheets automatically
- How to send contact form leads from Gmail to Google Sheets
- How to export Gmail emails to Google Sheets
- How to log order confirmation emails in Google Sheets