Export Email to Google Sheets currently supports the following parsing rules:

  1. Before text (in the same line) – returns portion of the line
  2. After text (in the same line) – returns portion of the line
  3. After and before text (in the same line) – returns portion of the line
  4. After line – returns only one line
  5. Line number – returns only one line
  6. Between two lines – returns multiple lines
  7. Extract using regular expression (can extract email addresses, URLs, etc.)

All of the above rules can be “chained” as:

  1. OR – the rule will run only if the previous rule does not return any value
  2. AND – the rule will process results returned by the previous rule

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 value of text before should something which is common in all email message.

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 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 that is 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 recent example of...

Submit By: 11 December 9:00AM 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:00PM 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 are some tips consumers can follow to reach that goal (or other savings goals) faster? Should they use retirement accounts, high-yield accounts, a mix?

Submit By: 14 December 3:00PM 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.