Follow up on survey scores

A score is only useful if someone acts on it. When a new survey response lands in your sheet (columns Name, Email, Score, Comment), customers who score 9 or 10 get a thank-you email asking for a public review.

Customers who score 6 or below are flagged to your team in Slack with their comment, so someone can reach out while it still matters. Scores of 7 and 8 are left alone.

Google SheetsWhen a row is added to the spreadsheet. Save it as response.When a row is added to the spreadsheet. Save it as response.

If response.fields.Score is greater than or equal to 9If response.fields.Score is greater than or equal to 9

Yes

Thank 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

Flag 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