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
The integration steps this workflow runs, in the order it first runs them.
- 1TelegramNew message trigger
- 2Google SheetsAppend row
How it works
Everything the template sets up, and what to fill in before the first run.
Every message your Telegram bot receives is written to a Google Sheet as one new row, exactly as it was typed. Nothing is summarised, categorised or rewritten on the way - the row holds what you sent, and the sheet stays a plain record you can read, filter and total yourself.
Each row has four columns, in this order: when it was recorded (UTC), the sender's Telegram username, the sender's numeric Telegram user ID, and the message text. Put those four headings on your tab before the first run - the workflow always writes these four columns in this order and cannot be pointed at differently named ones. Values are written exactly as text, so a message beginning with = or + is stored as characters rather than becoming a spreadsheet formula.
This is the answering half of a check-in loop. If you also want a question sent to you on a schedule - a daily "what did you get done today?" - build that as a second workflow on a schedule that sends the prompt to the same chat; a workflow can only have one trigger, so the asking half and the answering half have to be two. This one runs whenever a message arrives, whether it was prompted or not.
To set it up, paste the chat's ID onto the trigger step - leave it blank and every message in every chat the bot has been added to is written to the sheet - then fill in 'spreadsheetUrl' and 'sheetName'. Messages that carry no text, such as a photo or a sticker, are skipped rather than written as blank rows. A sender with no Telegram username is recorded as 'unknown', with their numeric ID still in the next column, so the message is never lost.
You May Also Be Interested In
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.
A written-up plan of your day in TelegramEvery weekday morning, reads the calls booked on your calendar for today and sends you one written-up message in Telegram.
Look up the weather from TelegramReply in Telegram with the current conditions for whatever place someone names in the chat.
Answer Telegram questions from the web, with sourcesAnswers questions asked in a Telegram chat by searching the web, and replies with the answer and the pages it came from.
Start from a workflow that already works.
Add "Log Telegram messages to a spreadsheet" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required