If you are looking for some way to gather all your Telegram messages on Google Sheets then this could be the simplest way possible.

As in this article, we are going to integrate Telegram with Google Sheets using Pabbly Connect to save Telegram messages to Google Sheets automatically. To store the conversation for further referencing, record keeping and machine learning etc. This service enables integrating any two or more services together as well as share information within the connected services instantly.

How to Save Telegram Messages to Google Sheets Automatically

We’ll simply set up a trigger on the Telegram bot messages and its respective action on Google Sheets to save the sent message.

Moreover, Pabbly Connect offers more advanced feature other than instant triggers that are routers, filters and formatters etc. Using this service you can design unlimited workflows, make multi-step calls, integration with unlimited premium apps etc. All this without any hard coding or help from professionals.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect  

In just a minutes interval, it enables you to set up a trigger on Telegram to send messages data to the Google Sheets and save them. So now you can save your time from manual coding and integrate services in simple clicks. Also, Pabbly Connect allows you to access all Pabbly Connect features without any restriction even in its free plan.

Further, let’s move forward with the step by step procedure to integrate Telegram with Google Sheets to automatically save messages on sheets.

How to Save Telegram Messages to Google Sheets Automatically (step by step)

Step 1: Sign up to Pabbly Connect

Sign Up
Go to the official website of Pabbly Connect and then click on the ‘Sign-Up Free‘ button. On the registration page, either signup using an existing Gmail account or manually fill out the form to get into the system.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

After signing up successfully, click the ‘Access Now’ button of the software ‘Connect’ Pabbly application.

Step 3: WorkFlow for Telegram with Google Sheets Integration

(a) Start with a New Workflow

Create New Workflow

Start with creating a workflow to send Telegram messages automatically to Google Sheets and to do this strike the ‘Create New Workflow’ button.

(b) Name the Workflow

Telegram to Google Sheets Workflow

Now, name the workflow (for instance: Telegram to Google Sheets etc) and push the ‘Save’ button.

Step 4: Setting Trigger for Telegram – Google Sheets Integration

To automatically save messages to Google Sheets whenever a message arrives on Telegram, you need to set-up a trigger on messages using Telegram bot and its respective action to save the messages Google Sheets. So, let’s get started with setting up the trigger first.

(a) Select Application you want to integrate

Integrate Telegram

When you hit the save button to create a workflow, a trigger window will open next.

You’ll need to select the ‘Telegram Bot’ option from the ‘Choose App’ field drop-down options to connect as well as start setting up a trigger on the Telegram account.

(b) Connect with Telegram Bot

Connect with Telegram Bot

Make sure of the method in here to be ‘Set Webhook/Watch Updates’.

Then, click the ‘Connect with Telegram Bot’ button.

Step 5: Connecting Telegram to Pabbly Connect

your Telegram account and go to the backend dashboard.

(a) Click the BotFather Link

Click the BotFather Link

When you click on the ‘Connect to Telegram Bot’ button, a window will slide in from the right, click on the BotFather link or go to your telegram account and search for BotFather.

(b) Click Start on BotFather Chat

Click Start on BotFather Chat

Once you enter into the BotFather chat, you’ll see a ‘Start’ button. So, simply press it to initiate creating a bot.

(c) Create a New Bot

Create New Bot

To create a new bot type ‘/newbot’ and then hit send.

(c) Name Your Created Bot

Name Your Bot

Next, it will ask you for a bot name. So, type any bot name that you wanna give to the recently created bot and hit the send icon.

(d) Give Your Bot a Username

Bot Username

Lastly, give your bot any username that ends with a suffix ‘bot’. Just type the username and hit send.

(e) Copy the Token

Copy Telegram Token

Once you successfully assign a username to your bot, a token will show up along with the new bot greetings.

Select and copy the token from here.

(f) Paste the Copied Token on Pabbly Connect

Paste the Telegram Token

Paste the copied Telegram token in the Pabbly Connect and hit the ‘Save’ button.

Step 6: Test the Trigger Response in Pabbly Connect Dashboard

As we can see we are done setting up the trigger to save the messages send via Telegram in Google Sheets. So, let’s just test the trigger by making a test order on Telegram.

(a) Click on ‘Save & Send Test Request’ Button

Save & Send Test Request

After connecting a Telegram account, a Webhook URL becomes visible along with some extra notes.

Simply click on the ‘Save & Send Test Request’ button in here.

(b) Check the Test Response

Check the Test Response

Check the success of your Webhook settings by looking at the API response of the trigger test request. If it looks like thing (as shown in the above image) then your trigger is working fine.

(c) Capture Webhook Response

Capture Webhook Response

To test the trigger, first, hit the ‘Capture Webhook Response’ button on the Pabbly Connect trigger window.

(d) Go to Your Created Telegram Bot Window

Test Your Bot

Open the bot’s chat window that you just created, type any message and then hit the send button icon.

(e) Check the Trigger Response

Trigger API Response

You can see the response of your created trigger below the API Response.

The response will start showing the details of the trigger response.

Step 7: Setting Action for Telegram – Google Sheets Integration

As we can see the response that we got from the set trigger is as expected and now we can move forward towards taking an action on the received data from Telegram.

(a) Create a Google Sheet

Google Sheet

If you’ve already created a Google Sheet then simply move forward to the next step else create a Google Sheet to save Telegram messages first. Also, define the column heads for the data that you wanna store.

(b) Select Application You Want to Integrate

Integrate Google Sheets

To start saving the Telegram messages in Google Sheets, click the plus button next to your recently created trigger window.

Then select the ‘Google Sheets’ app to integrate from the ‘Choose App’ field’s drop-down menu.

(c) Connect with Google Sheets

Connect with Google Sheets

Next, check the method in here to be ‘Append Values’ and then click ‘Connect with Google Sheets’ button.

(d) Authorize your Google Sheets Account

Authorize Google Account

In the next window that slides in from the right, click ‘Connect’ button & authorize your Google account.

(e) Select the Spreadsheet

Select Spreadsheet

Once the Google account authorization is completed, the service starts showing all the spreadsheet names that are created in that particular account. Select the spreadsheet and sheet in which you wanna save the Telegram messages.

(d) Map the Telegram Response to the Google Sheet Fields

Map Values

Now, map the Telegram trigger response values to the Google Sheet fields.

You can map any value by placing your cursor in between a pair of double codes.

Then, click the menu button (or three horizontal lines) next to the values field.

Lastly, click select the value that you want to map with the respective spreadsheet column.

(e) Save & Send Test Request

Save & Send Action Request

After mapping all the trigger response values with the sheet fields, click on ‘Save & Send Test Request’ button.

(f) Check the API Response

Action API Response

You can acknowledge the success of your set action on the ‘API Response’.

(g) Check the Google Sheet Entries

Sheet Entries

Also, you can check the Goggle Sheet entries to ensure the success of the set Webhook.

Step 8: Save the Workflow

(a) Save the Action API’s Response

Save Action API's Response

(b) Save the Workflow

Save Webhook for Telegram and Google Sheets Integration

As we can see the Webhook is working perfectly. So, simply save the webhook by clicking the save button in the trigger window.


Well, this is all about ‘How to save Telegram messages to Google Sheets automatically’. Consequently, after completing the step by step procedure, you will end up saving all the Telegram messages within Google Sheet in real-time. Most importantly, the procedure is very simple and don’t need any coding knowledge.

Note: Bots can not see messages from other bots (regardless of mode) as bots talking to each other can likely get stuck in undesirable loops.

You can try Pabbly Connect for FREE.

Did you like the procedure? Do comment below. We’ll get back to you ASAP.

You May Also Like to Read: