Send Typeform results to Google Sheet, Slack and email

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.