App-store review replies — with review and logging

The scenario collects reviews, shows them in Microsoft Teams, drafts replies with AI, keeps drafts in Google Drive, and after approval posts them, logging results in dataTable.

  • New reviews collected automatically
  • AI drafts polite, personal replies
  • Posting only after your approval
  • Results logged in dataTable
JWT
Set it up for yourselfScriptera

How it works

To connect Microsoft Teams and Google Drive, you don't need a developer: a ready-made scenario links them in minutes.

  1. Starts when: Trigger posting responses
  2. Then: Search responses ready to be posted
  3. Then: Download file
  4. Then: Extract from File
  5. Then: JWT1
  6. Then: HTTP Request - Respond to App Store reviews
  7. Then: Create a success log for the review
  8. Then: Create an errror log for the review
  9. Then: Move spreadsheet to Archived folder
  10. Then: JWT
  11. Then: HTTP Request - App Store Reviews
  12. Then: Split Out fetched reviews
  13. Check: Fetch yesterday's reviews
  14. Check: Any reviews yesterday?
  15. If yes: Fetch fields required by LLM
  16. Then: Aggregate reviews for LLM use
  17. Then: LLM Response Generator
  18. Then: Split responses
  19. Check: Loop over apps
  20. Check: Get rid of empty items
  21. Then: Sort
  22. Then: Convert to File
  23. Then: Upload file
  24. Then: Send to Slack
  25. Then: Fetch app id and name
  26. Then: Fetch list of applications
  27. Then: Anthropic Chat Model
  28. Then: Structured Output Parser
  29. Starts when: Trigger download

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

Similar scenarios