Weekly Google Business report — automatically

Every week the scenario gathers impressions and reviews for your companies, adds short takeaways and sends a summary to Telegram and SendGrid.

  • Impressions and reviews for the week and 12 weeks
  • Short takeaways in plain language
  • Everything saved to таблица
  • Summary to Telegram and SendGrid
Google Sheets
Set it up for yourselfScriptera

How it works

To create Telegram records from GitHub without manual input, use a ready-made scenario.

  1. Starts when: Schedule Trigger
  2. Then: Read Companies
  3. Then: Build Week Window2
  4. Then: Get Impression data
  5. Then: Flatten
  6. Then: Add Impressions to Sheet
  7. Check: Merge2
  8. Then: Join All
  9. Then: format
  10. Then: Overall one-liner
  11. Check: Merge One Liners
  12. Then: Normalize Keys
  13. Check: Attach recipients
  14. Then: Group Three Lines Per Company
  15. Then: All-companies Slack
  16. Then: Per Company Slack
  17. Then: Create Email
  18. Then: Per company email
  19. Then: Read Recipients
  20. Then: Normalize recipients
  21. Then: Reviews one-liner
  22. Then: Impressions one-liner
  23. Then: Get Impressions (last week)
  24. Then: Flatten (last week)
  25. Then: Append row in sheet
  26. Then: Build Week Window (reviews)
  27. Then: Set Company (reviews)
  28. Then: Get Many Reviews
  29. Then: Map weekly reviews
  30. Then: Add Reviews to Sheet
  31. Then: Summarize Weekly Reviews
  32. Then: Add Weekly Summary
  33. Then: Build 12-Week Window
  34. Then: 12 week impressions
  35. Then: Flatten 12-week
  36. Then: Add 12 week Impressions to Sheet
  37. Then: Set Company (total reviews)
  38. Then: Get all reviews
  39. Then: All-time Reviews → KPIs (no LLM)
  40. Then: Add all time Summary
  41. Then: Build last week window
  42. Then: Set Company last week reviews
  43. Then: Get last week reviews
  44. Then: Map + categorize reviews (last week, single node)
  45. Then: Summarize Weekly Reviews (last week)
  46. Then: Build 12-week window (reviews)
  47. Then: Set Company last 12 week reviews
  48. Then: Get last 12 week reviews
  49. Then: map and summarize last 12 weeks reviews
  50. Then: Summarize 12-week reviews (totals + weekly average)
  51. Then: OpenAI Chat Model4
  52. Then: OpenAI Chat Model2
  53. Then: Review Parser
  54. Then: Impression parser
  55. Then: OpenAI Chat Model
  56. Then: overall parser

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

Similar scenarios