Send Typeform results to Google Sheet, Slack and email

1. Trigger on new Typeform form submission
2. Write data to Google Sheet
3. Check severity of 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".

Columns Names:

• Name
• Email
• 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.