Dynamic Mandrill Email Template -------
1. Triggered by entry in google sheet or Typeform API
2. Inputs dynamic content from the fields entered in Google Sheet/Typeform api
3. Template uses if ELSE conditions to display content in mail according to values entered in google sheet /typeform api.
4. Template has a simple design with icons and a background image General Work Flow :-
1. User fills up a tyepform . We use [login to view URL] to integrate the data from typeform to google sheets.
2. User basically enters yes/no to various form fields asked.
3. Now Using IF /ELSE Logics we need to send a customised mail to the user
.
Where in content is displayed based on yes/no to the user .
4. Also Each email is triggered based on every new entry in the google sheets.
5. I assume this is possible by using mandrill add on by mail chimp.