Workflow templateRun a coaching chat that remembers sessions
Replies to coaching messages on Telegram using each person's profile and history from a sheet, and emails everyone a check-in every Monday. After publishing, you pick a secret token in Whenever and pass it with the webhook address to Telegram's setWebhook; one bot serves one workflow.
Workflow illustration
01Trigger
TriggerA message to my coaching bot on Telegram, and every Monday at 09:00 AM UTC.
02Go
Google SheetsOn a message, find its row on tab 1 of the Google Sheets spreadsheet id from setup (Chat Id, Email, Profile, History, Last Id, Checked In), or add one; stop if Last Id is this message id.
03Te
TelegramReply in Telegram using Profile and History.
04
Custom stepAdd the exchange to History, save its id.
05Gm
GmailOn Monday, Gmail my setup check-in subject and text to each row with an Email not Checked In this week; set it to today.
06
OutputFinish
How it runs
This is the brief Whenever builds from. Change any of it in plain words before you publish.
When
A message to my coaching bot on Telegram, and every Monday at 09:00 AM UTC.
Then
- On a message, find its row on tab 1 of the Google Sheets spreadsheet id from setup (Chat Id, Email, Profile, History, Last Id, Checked In), or add one; stop if Last Id is this message id.
- Reply in Telegram using Profile and History.
- Add the exchange to History, save its id.
- On Monday, Gmail my setup check-in subject and text to each row with an Email not Checked In this week; set it to today.