Import typeform, filter answers, send automated email based on filter.

Task 1: Import form results via Typeform API into Google Spreadsheet. This creates a list of all the form results. Task 2: Import answers from Typeform into Google Spreadsheet cells. Every answer is added to the drop down menu. Task 3: Add an email tab in Google Spreadsheet where the html of multiple emails can be added. We need to able to refer to an answer that has been given in the typeform. Task 4: Setup a filter per line and by selecting answers per question with a multiple choice dropdown. Task 5: Send the selected email to the email adres from the form based on the filtered answers in task 3. This needs to be done with a Google script and Gmail adres. For example: IF form answers = (Question1=AnswerA) AND (Question3=AnswerC) AND (Question8=AnswerB) THEN Send Email A. Task 6: Mark the form result row as 'Email send' by filling it with a green color. This script should run every 15 minutes. Software to work with: Google Spreadsheet Google Script Typeform API