More good reviews, and the negatives — to you privately

The scenario offers the client an incentive for a review, sends the happy ones to a public page and takes complaints into a private table — with reminders.

  • Happy clients go to public reviews
  • Negatives come privately, not to your page
  • An incentive lifts the response
  • Reminders for those who went quiet
Google SheetsWebhook
Set it up for yourselfScriptera

How it works

To get Microsoft Teams notifications in Google Sheets, you don't need a developer: a ready-made scenario watches events and sends messages for you.

  1. Starts when: Initial User Message
  2. Then: Fetch Rows from sheet
  3. Check: checks if customer exists in sheets
  4. If yes: Updates customer details
  5. Then: Send Incentive Offer
  6. Then: Updates Status
  7. Then: 2 hours delay for feedback
  8. Then: Send Review Page Link
  9. If no: checks if they still didn't claim the offer
  10. If yes: Already claimed offer msg
  11. Starts when: Feedback message
  12. Then: Save Private Feedback to Sheet
  13. Starts when: Link Click Track
  14. Then: Update Status to 'Clicked'
  15. Starts when: Schedule Trigger
  16. Then: Get row(s) in sheet1
  17. Check: Loop Over Items
  18. Then: Timestamp to Boolean
  19. Check: if 23 hours passed
  20. If yes: Send Review Link Reminder
  21. Then: update status to follow up sent

You can launch this Microsoft Teams + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios