Email Data Extraction and Automation
Budget: £20 – £250 GBP
I am looking for the following 2 automation tasks to be set up.
1. Transfer data from emails into the correct tab on an Excel Spreadsheet stored on Onedive. This should be by configuring the emails using make.com webhook and then using RegEdit script to extract the required fields.
2. Transfer the same data from the emails into Brevo application - Customer Data Lists.
Data to be extracted will be Name, Address, Email Address and maybe some other data.
Additional info about the email layout is shown below.
Hello Oliver, the mail format is html so the column positions will adjust depending on the length of the field values - so if someone has a long name a greater proportion of the space will be allocated to the name. It's not really practical to make these fields fixed length, and if you are scraping the content you need to do it taking the html tags into account - the name will always be on the same column position within the table - so it shouldn't be a problem for your developer. If it is, let me know, but we don't really want to switch to a text based mail with fixed length fields - that would be like going back about 30 years!
If it helps, the body of the mail is base64 encoded, and it's very easy to convert this back to plain text - for one of the examples I sent you, the body is this: ATTACHED
1. Transfer data from emails into the correct tab on an Excel Spreadsheet stored on Onedive. This should be by configuring the emails using make.com webhook and then using RegEdit script to extract the required fields.
2. Transfer the same data from the emails into Brevo application - Customer Data Lists.
Data to be extracted will be Name, Address, Email Address and maybe some other data.
Additional info about the email layout is shown below.
Hello Oliver, the mail format is html so the column positions will adjust depending on the length of the field values - so if someone has a long name a greater proportion of the space will be allocated to the name. It's not really practical to make these fields fixed length, and if you are scraping the content you need to do it taking the html tags into account - the name will always be on the same column position within the table - so it shouldn't be a problem for your developer. If it is, let me know, but we don't really want to switch to a text based mail with fixed length fields - that would be like going back about 30 years!
If it helps, the body of the mail is base64 encoded, and it's very easy to convert this back to plain text - for one of the examples I sent you, the body is this: ATTACHED
Related categories:
PHP
Data Processing
Excel
Web Scraping
Email Handling
Data Scraping
Data Extraction
Data Integration
Automation
Make.com