Export Email to Google Sheets currently supports the following parsing rules:
- Automatically detect entity – automatically detect and extract entity from the text
- Before text (in the same line) – returns portion of the line
- After text (in the same line) – returns portion of the line
- After and before text (in the same line) – returns portion of the line
- After line – returns only one line
- Line number – returns only one line
- Between two lines – returns multiple lines
- Multiple lines after line – returns multiple lines
- Multiple lines before line – returns multiple lines
- Multiple between line numbers – returns multiple lines
- Extract using regular expression (can extract email addresses, URLs, etc.)
All of the above rules can be “chained” using the logical operators:
- OR – the rule will run only if the previous rule does not return any value
- AND – the rule will process results returned by the previous rule
Automatically detect entity
This rule will automatically try to find an entity in the email.
For example, if your email message has the following text:
Total Amount Tax $23.00 USD $1.00 USD
And if you want to extract Total Amount, then you will add the rule Automatically detect entity and for entity name, enter Total Amount.
Before text (in the same line)
This rule will return all the text before the certain text.
For example, if your email message has the following line:
$23.00 USD has been applied.
And if you want to extract $23.00 USD then you will add the rule Before text (in the same line). The text before should be set to has been applied.
Note that the value of text before should be something common in all email messages.
After text (in the same line)
This rule will return all the text after the certain text.
For example, if your email message has the following line:
Price Total: $23.00 USD
And if you want to extract $23.00 USD then you will add the rule After text (in the same line). The text before should be set to Price total:
After and before text (in the same line)
This rule will return all the text between after and before the text.
For example, if your email message has the following line:
This is an order notification for item number 234-34243, ordered on May 23rd, 2020
And if you want to extract item number 234-34243 then you will add the rule After and before (in the same line). The text after should be set to This is order notification for item number while text after should be set to ordered by.
After line
This rule will return the entire line after the line with the given text.
For example, if your email message has the following line:
Email Address: someemail@somecompany.com Phone number:
And if you want to extract email address someemail@somecompany.com then you will add the rule After line. The text after should be set to Email Address:.
Line number
This rule will return the entire line given the line number.
Between two lines
This rule will return the text between two lines. For example, if your email message has the following line:
From: Forbes When And How Companies Should Change Their Handling Of A Crisis > Seeking sources to comment on why and how companies and organizations should change their approach to managing and responding to a crisis in the midst of addressing the crisis. Also seeking a recent example of... Submit By: 11 December 9:00 AM PST (in 2 days) LEARN MORE AND PITCH: http://wwww.qwoted.com --- From: Forbes Policies And Strategies For Administering Covid-19 Shots > For a story on Forbes.com, I am seeking sources to comment in writing ASAP today about the challenges and dangers posed by not having standard and agreed-upon policies and strategies for administering a Covi... Submit By: 9 December 3:00 PM PST (in about 4 hours) LEARN MORE AND PITCH: http://wwww.qwoted.com --- From: Fox Business Topic: Reaching savings goals > > How much should people have saved up by age 40? > What tips can consumers follow to reach that goal (or other savings goals) faster? Should they use retirement accounts, high-yield accounts, or a mix? Submit By: 14 December 3:00 PM PST (in 5 days) LEARN MORE AND PITCH: http://wwww.qwoted.com --- From: Fox Business
And if you want to extract get only text between From: and LEARN MORE AND PITCH. The “text after” should be set to From: while “text before” should set to LEARN MORE AND PITCH.
Multiple lined after line
This rule will return X lines of text after the matching line. For example, if your email message has the following line:
Account Info: Kirk L. Fuller 4447 Sycamore Street Santa Clara, CA 95054 Some random text, some text Some random text, some text Some random text, some text
And if you want to extract get only name and address info, then set the following rule: “3 lines after the line matching the Account Info:“.