Sharp price-move alerts and a weekly report, straight to chat

Every day the scenario logs the price into dataTable, computes the change from the previous day, alerts Google Chat on a sharp move, and posts a weekly report on weekends.

  • The price history builds itself — no file to maintain
  • You're pinged only on sharp moves, not every single day
  • The weekly report assembles itself
  • Change is computed both in money and in percent
Slack Tool
Set it up for yourselfScriptera

How it works

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

  1. Starts when: Execute every morning
  2. Then: Get Latest Gold Price
  3. Then: calculate third of one troy ounce
  4. Then: rename field
  5. Then: Insert gold record to table
  6. Then: Fetch gold all prices
  7. Then: Get last two records
  8. Then: Calculate price_change & percent_change
  9. Check: Route based on spike
  10. If yes: Slack alert assistant
  11. Then: Update table with new data
  12. Then: Gemini - slack
  13. Then: Slack - alert tool
  14. Starts when: Execute at weekend
  15. Then: Get all prices
  16. Then: Return last 7 days data
  17. Then: Get required fields
  18. Then: Combine data togather
  19. Then: Reporting Agent
  20. Then: Update row(s)
  21. Then: Gemini - report
  22. Then: Slack - report

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

Similar scenarios