See also:
Capturing text with “Starts after… continues until…”
Exporting email contents to Excel
This example shows how to parse an incoming email contaning data using the format “name:value” and save it to an Excel file. This format is quite common in email notification like website contact forms, e-commerce sales and other type of reporting that uses an email for notifications. The email we receive in this case is a notification from a weather station:
From:test@example.com
To:example@example.com
Subject:Weather report
We only want to capture the wind speed, the date, and the time when the data was measured. Let’s see how to set up the fields to capture this information from the email body:
The last step is to save this fields to an Excel file. To do that, we use an action of type Save to an Excel file:
When an email is received, Email Parser automatically captures the text following the rules above and produces the following output:
After parsing a set of emails (or leave Email Parser running for a while) we have this generated rows in the Excel file: