Thanks customers who score you 9 or 10 and flags those who score 6 or below to your team in Slack.

UsesGmailGoogle SheetsSlack

Follow up on survey scores

Google SheetsGoogle SheetsWhen a row is added to the spreadsheet. Save it as response.When a row is added to the spreadsheet. Save it as response.
Decisions & LoopsIf response.fields.Score is greater than or equal to 9If response.fields.Score is greater than or equal to 9
Yes
GmailThank the promoterSend an email to response.fields.Email. Save it as thanked. Subject: Thank you!Hi response.fields.Name, Thank you for the great score! If you have a minute, we'd love it if you shared your experience in a short public review. Thanks againGmail
Else if @response.fields.Score is less than or equal to 6
SlackFlag the unhappy customerSend message to channel. Save it as flagged.:rotating_light: response.fields.Name (response.fields.Email) gave us a response.fields.Score. They said: response.fields.CommentSlack
Otherwise
No steps