Save Telegram messages to a Google Sheets spreadsheet
Software used in this automated workflow example
Summary
Detailed explanations
Step by step instructions
-
Create a new scenario from scratch.
-
Add a Telegram Watch module and set it up as follows:
Connection : You will be asked to log in and authorize Make (formerly Integromat) to access your Telegram account
: You will be asked to log in and authorize Make (formerly Integromat) to access your Telegram account Operation : Watch for new messages
: Watch for new messages Chat ID : Enter the Telegram chat/channel ID
: Enter the Telegram chat/channel ID Limit: Set a limit. If you want to retrieve more messages, you will need to add another Watch module.
- Add a Google Sheets module and set it up as follows:
Connection : You will be asked to log in and authorize Make (formerly Integromat) to access your Google account
: You will be asked to log in and authorize Make (formerly Integromat) to access your Google account Operation : Select the Append to spreadsheet operation
: Select the Append to spreadsheet operation Spreadsheet URL : Enter the URL of your spreadsheet. You can find the URL by opening the spreadsheet in Google Sheets, clicking the Share button in the top right corner, and copying the link from the pop-up window
: Enter the URL of your spreadsheet. You can find the URL by opening the spreadsheet in Google Sheets, clicking the Share button in the top right corner, and copying the link from the pop-up window Range : Enter the range of cells you want to append the data to
: Enter the range of cells you want to append the data to Map: Select the fields you want to append to the spreadsheet. If a field is not mapped, it will not appear in the spreadsheet.
- Run the scenario.
Business use case example
You can use this scenario to automatically keep a record of all the messages posted in a Telegram chat/channel.