Inserting a new row in an Excel file
Email Parser can insert data from emails in an Excel file. It automatically creates a new row with the specified fields.
Note that old Excel files (.xls) are not supported. Only newer (.xlsx) Excel files can be used by Email Parser.
For example, given the following email:
We need to extract the fields customer, invoice and quantity and insert them in an Excel file. It can be done this way:
Fields retrieved from the email are inserted in new Excel row
A little more advanced way is to process emails that can have multiple sets of customer,invoice and quantity. For example:
It can be done adding an Iterator automated process before the Excel automated process:
The resulting Excel file is the following: