Connect Google Sheets to Telegram
Ideas
What you can do with Google Sheets and Telegram
Turn Telegram ideas into short videos logged in a sheet
Message your bot an idea and get back a finished short video, with every video tracked in your Google Sheet.
See how it worksAnswer Telegram questions from a Google Sheet
People message your Telegram bot and get answers drawn from your sheet, with every question and reply logged.
See how it worksTurn receipt photos into rows in your expense sheet
Send a photo of a receipt to your Telegram bot and the merchant, date, total and category land in your expenses sheet.
See how it worksSend a weekly Telegram message to every chat in a sheet
Write your announcement once in a sheet and every Telegram chat on your list gets it on Monday morning, with each one marked as sent.
See how it worksGet a daily vocabulary quiz from your sheet on Telegram
Every evening your Telegram bot quizzes you on five words from your sheet, checks your answers and records your score next to each word.
See how it worksLog meals and macros by messaging a Telegram bot
Tell your bot what you ate and get calories and macros logged in your sheet, with today's total in the reply.
See how it worksGet Telegram alerts when a site in your sheet goes down
Every site in your sheet is checked every 5 minutes, its status is kept up to date, and you get a Telegram message when one goes down or recovers.
See how it worksLog trading alert emails to a sheet and Telegram
Each TradingView alert email is logged with ticker, action and price in your sheet and pushed to your Telegram within minutes.
See how it worksGet a daily Telegram news digest on your own topics
Each morning a short summary of the news on the topics in your sheet arrives in Telegram, and every digest is logged.
See how it worksTrack competitor prices from a sheet
List competitor product pages in a sheet and get a Telegram message whenever one of their prices changes, with the latest price recorded in the sheet.
See how it works Your own logicAny other automation you can describe in words
Your own rules, schedule and AI steps with Google Sheets and Telegram, plus any other app. Describe it and your assistant builds it.
See how to build your ownMore ideas
Sell with Telegram Stars and log every payment in a sheet
Customers buy from your bot with Telegram Stars, and every payment and refund lands in your Google Sheet.
See how it worksGet Telegram warnings before SSL certificates expire
Each day the domains in your sheet are checked, the days left on each certificate are written next to them, and you get a Telegram message for any under 14 days.
See how it worksTrack focus sessions from Telegram in a sheet
Start and stop focus sessions with a Telegram message and every session is logged with its duration, with today's total in the reply.
See how it worksRecord every Telegram bot user in a sheet
Each new person who messages your Telegram bot is added to a sheet and greeted, and returning users get their last-seen date updated.
See how it worksGet matching job posts on Telegram and log them in a sheet
Each morning, new job posts from your feeds are scored against your profile, good matches are added to your Jobs sheet and the best ones arrive on Telegram.
See how it worksLog expenses from Telegram messages to Google Sheets
Type "12.50 lunch" to your bot and a row with the date, amount, category and note is added to your Google Sheet, with this month's total in the reply.
See how it worksGet a Telegram message when a Google Sheet gets a new row
Every 5 minutes ClickRuntime checks a Google Sheet and sends a Telegram message for each new row, such as a form response or order, with the columns you pick.
See how it worksBuild your own
Build any Google Sheets and Telegram automation you can describe
Your own rules
Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.
Any number of apps
One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.
AI where it helps
Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.
On a schedule or on each event
Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.
For example, ask your assistant
When I message my bot something like 'spent 24 on lunch', use AI to read the amount and category and add a row to my Budget sheet, then reply with this month's total for that category.
Every hour, check my Stock sheet and send a Telegram alert for items below their minimum, but only once until the value goes back up.
Use cases
Why people connect Google Sheets and Telegram
How the two apps work together
- Messages to your Telegram bot reach a trigger link instantly and can be added as rows in the sheet.
- ClickRuntime checks the sheet on a schedule, as often as every 5 minutes, for new rows or values that need an alert.
- Alerts and summaries are sent to a Telegram chat, group or channel through your bot.
Shop owner gets daily sales on Telegram
A sales sheet can be summarized each evening and sent as a Telegram message with totals and the best seller.
Field team logs entries by message
Crew members send '12 boxes delivered to Store 4' to a bot, and a row is added to the sheet.
Manager watches thresholds
When a value like stock, spend or signups crosses a limit in the sheet, a Telegram alert goes out.
Teacher or coach sends reminders from a list
A sheet of names, dates and messages can drive reminders to a Telegram group.
More apps
Google Sheets, Telegram and other apps in one automation
Shopify orders to a sheet with Telegram summary
Log each Shopify order in my Sales sheet and send me a Telegram message with the day's total at 9pm.
Sheet deadlines to calendar and Telegram
When a row in my Deadlines sheet is due tomorrow, add it to Google Calendar and send me a Telegram reminder.
Telegram entries emailed weekly
Every Friday, email my manager from Gmail a summary of the rows my team added to the sheet through Telegram this week.
Setup
Connect Google Sheets and Telegram once
Google Sheets
Spreadsheets
- In the ClickRuntime dashboard, open Connections and choose Google Sheets.
- Sign in with your Google account and allow access.
- Pick the spreadsheets the automation may use. It can't see any other file in your Drive.
Telegram
Messaging
- In Telegram, open a chat with @BotFather and send
/newbot. - Choose a name and a username for your bot, then copy the token BotFather sends (it looks like
123456:ABC-...). - Open your new bot and press Start, so it is allowed to message you. For groups or channels, add the bot and give it admin rights if it should post or delete.
- In the ClickRuntime dashboard, open Connections & secrets and save the bot token.
FAQ
Questions about connecting Google Sheets and Telegram
Do I need my own Telegram bot?
Can it send to a group or a channel, not only to me?
Can I send things to the sheet from Telegram?
Does it read the whole sheet every time?
Can I query the sheet from Telegram?
Does each person need a Google account?
Can it send charts?
Related pages
Keep exploring
Tell your assistant what Google Sheets and Telegram should do together
Free plan. No credit card.