Import typeform, filter answers, send automated email based on filter.
€8-30 EUR
Cerrado
Publicado hace más de 6 años
€8-30 EUR
Pagado a la entrega
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
Hi,
I have gone through your given requirement and i am ready to do the sample for you and once you satisfied in my work, then you can award the project.
Please Advice,
Jee
Relevant Skills and Experience
Data Entry
Proposed Milestones
€29 EUR - Final Milestone