Parsing emails, creating a dynamic HTML template

Client: A company of realtors

Task: track when the right email arrives in the mail, find a link to the building's page in it. Transfer the data from the page (the description and link to the photo are generated using JavaScript) to a new email template (in the form of HTML).

Main difficulties:
* The content on the site was generated dynamically via JavaScript, which meant that standard methods of retrieving data via Zapier did not work.
* The link in the Outlook email was not in its final format and was changing before the pages loaded.

How I solved the problem:
- I used Zapier + Outlook to automatically detect emails and extract links.
- I set up an additional URL processing step to get the correct link to the site.
- Since the content was loaded via JavaScript, she used an alternative method of collecting data from web pages that could handle dynamic elements.
- I set up the data transfer to an HTML template in Outlook with the correct display of the content. Personalized the email. The finished template is saved in Outlook drafts.

I provided an option if the link does not work.

The main work was with:
- Webhooks - for data transfer and processing.
- JavaScript + Code by Zapier - to work with dynamic website content.
- HTML + CSS - to create the final email template.
- Regex (Regular Expressions) - to process the text and clean the received data.


The result:
The client receives ready-made email templates!

#Zapier #Microsoft Outlook #HTML #вилученняданих #API #xhr #збірданих #Email #шаблони #витягданих #данызсайту #динамічнідані