Thanks customers who score you 9 or 10 and flags those who score 6 or below to your team in Slack.
Uses
Gmail
Google Sheets
Slack
Follow up on survey scores
response.When a row is added to the spreadsheet. Save it as response.response.fields.Score is greater than or equal to 9If response.fields.Score is greater than or equal to 9Yes
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 againGmailElse if @response.fields.Score is less than or equal to 6
flagged.:rotating_light: response.fields.Name (response.fields.Email) gave us a response.fields.Score. They said: response.fields.CommentSlackOtherwise
No steps