Sheets → Telegram

Demo project for the portfolio.

The task: new bookings and orders in a sheet and their status changes reach Telegram right away, without spam or repeats.

The Apps Script runs on edit, on change and scans the sheet every 5 minutes.

What was sent is marked in its own column, so it survives sorting; only complete rows are sent; a lock against parallel runs and a 10-minute cache.

A 429 waits as told, a 5xx retries on the next scan, a 401 stops.

The token lives in Script Properties.

node --test 20/20: the real Code.

js runs in an Apps Script emulator with no network.

Not run against live Google or Telegram.