Back to Integrations
integrationTelegram node
integrationGoogle Sheets node

Telegram and Google Sheets integration

Save yourself the work of writing custom integrations for Telegram and Google Sheets and use n8n instead. Build adaptable and scalable Communication, Data & Storage, and Productivity workflows that work with your technology stack. All within a building experience you will love.

How to connect Telegram and Google Sheets

  • Step 1: Create a new workflow
  • Step 2: Add and configure nodes
  • Step 3: Connect
  • Step 4: Customize and extend your integration
  • Step 5: Test and activate your workflow

Step 1: Create a new workflow and add the first step

In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.

Telegram and Google Sheets integration: Create a new workflow and add the first step

Step 2: Add and configure Telegram and Google Sheets nodes

You can find Telegram and Google Sheets in the nodes panel. Drag them onto your workflow canvas, selecting their actions. Click each node, choose a credential, and authenticate to grant n8n access. Configure Telegram and Google Sheets nodes one by one: input data on the left, parameters in the middle, and output data on the right.

Telegram and Google Sheets integration: Add and configure Telegram and Google Sheets nodes

Step 3: Connect Telegram and Google Sheets

A connection establishes a link between Telegram and Google Sheets (or vice versa) to route data through the workflow. Data flows from the output of one node to the input of another. You can have single or multiple connections for each node.

Telegram and Google Sheets integration: Connect Telegram and Google Sheets

Step 4: Customize and extend your Telegram and Google Sheets integration

Use n8n's core nodes such as If, Split Out, Merge, and others to transform and manipulate data. Write custom JavaScript or Python in the Code node and run it as a step in your workflow. Connect Telegram and Google Sheets with any of n8n’s 1000+ integrations, and incorporate advanced AI logic into your workflows.

Telegram and Google Sheets integration: Customize and extend your Telegram and Google Sheets integration

Step 5: Test and activate your Telegram and Google Sheets workflow

Save and run the workflow to see if everything works as expected. Based on your configuration, data should flow from Telegram to Google Sheets or vice versa. Easily debug your workflow: you can check past executions to isolate and fix the mistake. Once you've tested everything, make sure to save your workflow and activate it.

Telegram and Google Sheets integration: Test and activate your Telegram and Google Sheets workflow

Telegram bot starter template setup

Telegram Bot Starter template workflow

provides a foundational setup for creating powerful Telegram bots with n8n. It handles incoming messages, photos, files, and voice notes, making it an excellent starting point for developers looking to create bots for customer engagement, support, or interactive services.

Key Features:

Dynamic Message Handling: Respond to text messages, photos, files, and more.
Modular Design: Easily integrate additional workflows such as user registration, payment modules, or custom commands.
Error Handling: Ensure the bot gracefully manages errors and user inputs.

Who Can Use This Workflow?

Developers looking for a quick way to build and customize Telegram bots.
Businesses and service providers who need customer interaction automation.

Setup Instructions:

  1. Replace Telegram credentials with your own API credentials.
  2. Customize responses for different message types (text, photo, file).
  3. If integrating with external services (like Google Sheets), update the necessary credentials and links.

Extensibility:

This workflow is the base for building any Telegram bot. Additional modules, such as a user registration module, payment integration, and user profile management, are available for easy connection to expand the bot’s functionality.

UPDATES:

🔥 Get the most up-to-date and expanded version →

Aug 24:

  • Changed processing of system events: “new user” and ‘user who blocked bot’ events

Sep 24:

  • Improved message handler: Updated logic to handle various types of messages using Switch (text, photo, file, voice, and callback).
  • Payment processing: Added new nodes for sending invoices and handling payments via Telegram

Please reach out to Victor if you need further assistance with your n8n workflows and automations!

Nodes used in this workflow

Popular Telegram and Google Sheets workflows

Telegram Trigger node
Telegram node
+3

Telegram bot starter template setup

Telegram Bot Starter template workflow provides a foundational setup for creating powerful Telegram bots with n8n. It handles incoming messages, photos, files, and voice notes, making it an excellent starting point for developers looking to create bots for customer engagement, support, or interactive services. Key Features: Dynamic Message Handling: Respond to text messages, photos, files, and more. Modular Design: Easily integrate additional workflows such as user registration, payment modules, or custom commands. Error Handling: Ensure the bot gracefully manages errors and user inputs. Who Can Use This Workflow? Developers looking for a quick way to build and customize Telegram bots. Businesses and service providers who need customer interaction automation. Setup Instructions: Replace Telegram credentials with your own API credentials. Customize responses for different message types (text, photo, file). If integrating with external services (like Google Sheets), update the necessary credentials and links. Extensibility: This workflow is the base for building any Telegram bot. Additional modules, such as a user registration module, payment integration, and user profile management, are available for easy connection to expand the bot’s functionality. ✍🏻Use the Telegram user registration workflow → 💵Use the Telegram Payment, Invoicing and Refund Workflow for Stars → UPDATES: 🔥 Get the most up-to-date and expanded version → Aug 24: Changed processing of system events: “new user” and ‘user who blocked bot’ events Sep 24: Improved message handler: Updated logic to handle various types of messages using Switch (text, photo, file, voice, and callback). Payment processing: Added new nodes for sending invoices and handling payments via Telegram Please reach out to Victor if you need further assistance with your n8n workflows and automations!
Google Sheets node
Telegram node

Send bulk messages to chats in Telegram

The Telegram API has a limitation to send only 30 messages per second. Use this workflow to send messages to more than 30 chats in Telegram.
Google Sheets node
Telegram Trigger node

Save Telegram daily messages to Google Sheets

A goal for 2022 is to write 1 thing I do each day. Combined with this workflow you will get daily messages via Telegram and when you reply to them they will be saved in a Google Sheet. Note: Make sure to configure your Telegram and Google Sheet credentials! You will also need to modify the functions to have your Telegram username and bot name.*
Google Sheets node
HTTP Request node
Twilio node
Telegram node
Telegram Trigger node

Add data from a photo to Google Sheets

Automatically adding expense receipts to Google Sheets with Telegram, Mindee API, Twilio, and n8n.
Google Sheets node
Telegram node

Telegram User Registration Workflow

Telegram User Registration module Offers an efficient way to manage new and returning users in your Telegram bot workflow. It checks user data against a Google Sheets database, saving essential user information and ensuring personalized interactions. Key Features: User Lookup: Searches for users in a Google Sheets database based on their unique Telegram ID. New User Handling: Automatically registers new users, capturing details such as first name, last name, username, and language code. Returning User Recognition: Detects when an existing user returns and updates their status. Data Storage: Safely stores user information in a structured format, with fields for status and date of registration. Personalized Greetings: Delivers customized welcome messages for both new and returning users, promoting engagement. Setup Instructions: Copy this Telegram User Registration Workflow Follow the instructions inside: - Use Google Sheet template - Set up your credentials - Use example data to test workflow Customization: Adjust the status and messages for users based on your bot's needs. Connecting to the bot Workflow: Copy my Telegram bot starter template Copy Workflow ID of your Telegram User Registration Workflow Find the Register module in Telegram bot starter template and paste your Workflow ID Now the user's data is entered into the Register Workflow. This module provides a scalable foundation for managing user registration, whether your bot is for meal planning, customer support, or other interactive services. My easy to set up Telegram bot modules: 🏁 Telegram bot starter template 📝 Telegram callback menu (soon) Please reach out to Victor if you need further assistance with you n8n workflows and automations!
HTTP Request node
+5

Telegram Payment, Invoicing and Refund Workflow for Stars

This workflow provides a complete solution for handling Telegram Stars payments, invoicing and refunds using n8n. It automates the process of sending invoices, managing pre-checkout approvals, recording transactions, and processing refunds for stars, making it ideal for businesses using Telegram Stars for digital payments. What are Telegram Stars? Learn more here. Key Features Payment Handling**: Automate invoice creation and sending via Telegram, with pre-checkout approval for smooth payment processing. Refund Management: Simplify the refund process using user IDs and payment charge IDs from successful **Telegram Stars transactions. Transaction Recording**: Record all payment details, such as user information and payment charge IDs, in Google Sheets for transparent financial tracking. Who Can Use This Workflow? Developers and Businesses: Looking to implement **Telegram Stars as a payment system within Telegram. Service Providers**: Managing subscriptions, donations, or digital sales through Telegram automation. Use Cases Subscription Sales Automation**: Use the workflow to issue invoices and automatically process payments for recurring subscriptions. Infopreneurs and Marketers: Use the workflow for delivering lead magnets, tripwires, and further automating sales via **Telegram Stars. Course Sales Automation**: Automate invoicing and refunds for educational platforms selling online courses. Developers and Businesses: Looking to implement **Telegram Stars as a payment system within Telegram. Service Providers**: Managing subscriptions, donations, or digital sales through Telegram automation. Online Educational Platforms**: Automate billing for courses and handle refunds easily. Setup Instructions Replace the Telegram API credentials with your bot API token from BotFather. Customize invoice details, including product name, description, and payment amount. Connect your Google Sheets for storing transaction logs. Configure refund steps for easy processing of star refunds when needed. Note: The setup is very simple—just follow the instructions provided on the yellow sticky notes within the workflow and insert your data. All other nodes are pre-configured and require no additional customization. The entire setup process takes just 1 minute. I provided a short Loom record with an explanation. Extensibility This workflow can be further customized to include user profile management, payment analytics, or integration with external services like CRMs or accounting tools. Additional modules can be easily connected to manage advanced features like Telegram User Registration. Available Templates Telegram Bot Starter Template: A foundational setup for creating custom Telegram bots. Telegram User Registration Workflow: Automate user registration and data collection via Telegram. Telegram Payment and Refund Workflow for Stars**: Streamline your Telegram payment processing with stars, invoices, and refunds. Support and Updates This workflow is supported and regularly updated to stay compatible with the latest Telegram features and n8n improvements. If you encounter any issues, technical support is available to ensure smooth integration and setup. Key terms: Telegram Stars payment workflow, Telegram refund automation, n8n payment template, Google Sheets transaction logging, Telegram bot for payments, automated refunds on Telegram, Telegram Stars invoice workflow. Please reach out to Victor if you need further assistance with your n8n workflows and automation!

Build your own Telegram and Google Sheets integration

Create custom Telegram and Google Sheets workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.

Telegram supported actions

Get
Get up to date information about a chat
Get Administrators
Get the Administrators of a chat
Get Member
Get the member of a chat
Leave
Leave a group, supergroup or channel
Set Description
Set the description of a chat
Set Title
Set the title of a chat
Answer Query
Send answer to callback query sent from inline keyboard
Answer Inline Query
Send answer to callback query sent from inline bot
Get
Get a file
Delete Chat Message
Delete a chat message
Edit Message Text
Edit a text message
Pin Chat Message
Pin a chat message
Send Animation
Send an animated file
Send Audio
Send a audio file
Send Chat Action
Send a chat action
Send Document
Send a document
Send Location
Send a location
Send Media Group
Send group of photos or videos to album
Send Message
Send a text message
Send Photo
Send a photo
Send Sticker
Send a sticker
Send Video
Send a video
Unpin Chat Message
Unpin a chat message

Google Sheets supported actions

Create
Create a spreadsheet
Delete
Delete a spreadsheet
Append or Update Row
Append a new row or update an existing one (upsert)
Append Row
Create a new row in a sheet
Clear
Delete all the contents or a part of a sheet
Create
Create a new sheet
Delete
Permanently delete a sheet
Delete Rows or Columns
Delete columns or rows from a sheet
Get Row(s)
Retrieve one or more rows from a sheet
Update Row
Update an existing row in a sheet

FAQs

  • Can Telegram connect with Google Sheets?

  • Can I use Telegram’s API with n8n?

  • Can I use Google Sheets’s API with n8n?

  • Is n8n secure for integrating Telegram and Google Sheets?

  • How to get started with Telegram and Google Sheets integration in n8n.io?

Looking to integrate Telegram and Google Sheets in your company?

Over 3000 companies switch to n8n every single week

Why use n8n to integrate Telegram with Google Sheets

Build complex workflows, really fast

Build complex workflows, really fast

Handle branching, merging and iteration easily.
Pause your workflow to wait for external events.

Code when you need it, UI when you don't

Simple debugging

Your data is displayed alongside your settings, making edge cases easy to track down.

Use templates to get started fast

Use 1000+ workflow templates available from our core team and our community.

Reuse your work

Copy and paste, easily import and export workflows.

Implement complex processes faster with n8n

red iconyellow iconred iconyellow icon