Log Telegram messages to a spreadsheet
Writes every message your Telegram bot receives to a Google Sheet as a row - the time, who sent it and exactly what they typed.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1TelegramNew message triggerStarts a run whenever your Telegram bot receives a message in the chat it watches.
- 2Google SheetsAppend rowAppends one row per message with the time recorded, the sender's username, their user ID and the exact text.
How it works
What happens on each run, in plain English.
Whenever your Telegram bot receives a message, one new row is added to your Google Sheet holding exactly what was typed. Nothing is summarised, categorised or rewritten on the way, so the sheet stays a plain record you can read, filter and total yourself.
Each row records when the message arrived, the sender's Telegram username, their numeric user ID and the text itself, in that order. Rows are only ever added, so nothing already on the tab is touched. A message with no text, such as a photo or a sticker, is skipped rather than written as a blank row, and a sender with no username is recorded as 'unknown' with their numeric ID still beside it, so no message is lost. This is the answering half of a check-in loop: if you also want a question sent to you on a schedule, that is a second workflow posting to the same chat.
Before the first run you need a Telegram bot in the chat you want recorded and a sheet with a tab carrying those four column headings.
You may also be interested in
Find matching rows in a spreadsheetEvery hour, finds the rows on a Google Sheets tab where a column holds a value you choose, or is empty, ready for the steps you add.
Fill a spreadsheet with a ChatGPT-written list every hourEvery hour, has ChatGPT write a fresh batch of the list you describe and adds each item as a row in your Google Sheet.
Save matching emails to a spreadsheetSaves each new Gmail message that matches your search as a row in your spreadsheet, and never saves the same message twice.
Daily news digest from your sheetEvery morning, has Claude pick the ten best stories logged in your news sheet, emails them to you with links, and clears the sheet.Start from a workflow that already works.
Add "Log Telegram messages to a spreadsheet" to your workspace, connect its apps, and make it yours.
Free plan, no credit card