Design Dynamic Mandrill Email Template -- 3

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.