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.
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
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.
Step 1: Sign up to Pabbly Connect
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.
Step 2: Access Pabbly 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
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
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
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
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
Sign-in your Telegram account and go to the backend dashboard.
(a) 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
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
To create a new bot type ‘/newbot’ and then hit send.
(c) Name Your Created 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
Lastly, give your bot any username that ends with a suffix ‘bot’. Just type the username and hit send.
(e) Copy the 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 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
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 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
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
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
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
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
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
Next, check the method in here to be ‘Append Values’ and then click ‘Connect with Google Sheets’ button.
(d) Authorize your Google Sheets Account
In the next window that slides in from the right, click ‘Connect’ button & authorize your Google account.
(e) Select the 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
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
After mapping all the trigger response values with the sheet fields, click on ‘Save & Send Test Request’ button.
(f) Check the API Response
You can acknowledge the success of your set action on the ‘API Response’.
(g) Check the Google 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
(b) Save the Workflow
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:
- How to Send Google Drive File on Every WooCommerce Purchase
- Zapier Alternatives
- How to get SMS Notifications for Every WooCommerce Purchase
- How to get SMS for Every Pabbly Subscription Billing Purchase