Send Typeform results to Google Sheet, Slack and email

1. Trigger on new Typeform form submission
2. Write data to Google Sheet
3. Check the severity of the problem
4. If very severe post message to Slack
5. If not so severe just send an email

Assumptions

Google Sheet

Sheet in Spreadsheet called "Problems".

Column Names:

• Name
• E-mail
• Severity
• Problem

Example Sheet: https://docs.google.com/spreadsheets/d/17fzSFl1BZ1njldTfp5lvh8HtS0-pNXH66b7qGZIiGRU

Typeform

Typeform formular with questions named exactly like the columns of the Google Sheet.