Send Typeform results to Google Sheet, Slack and email

Description

Trigger on new Typeform form submission
Write data to Google Sheet
Check severity of problem
If very severe post message to Slack
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.