Watching competitors' prices — with a chat alert

The scenario checks competitors' prices from таблица, and if one is below yours, sends an alert to Slack.

  • Competitors' prices without manual checking
  • An alert when it's below yours
  • The whole list checked in turn
  • Everything marked in the table
Google Sheets

How it works

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

  1. Starts when: Schedule Trigger
  2. Then: get unchecked row
  3. Check: row exist?
  4. If yes: HTTP Request to product page
  5. Then: price extract from page
  6. Then: Code to convert price into number
  7. Check: price greater than ours?
  8. If yes: Discord price alert
  9. Then: Update status to 1
  10. If no: Discord1
  11. Then: Get status row
  12. Check: row returned?
  13. If yes: Update status back to 0

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