How to Save Telegram Messages to Google Sheets Automatically

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.

Try Pabbly Connect for FREE

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.