Save Telegram Daily Messages to Google Sheets

This n8n workflow automates the process of capturing messages received via a Telegram bot and saving them to a Google Sheet. It's ideal for tracking daily communications, collecting feedback, or logging specific types of interactions from your Telegram channel or bot.

What it does

This workflow simplifies data collection from Telegram by performing the following steps:

1. Listens for Telegram Messages: It acts as a webhook, waiting for any new messages sent to a configured Telegram bot.
2. Processes Incoming Data: Upon receiving a message, it extracts relevant information.
3. Formats Data: It transforms the extracted Telegram message data into a structured format suitable for a spreadsheet.
4. Appends to Google Sheet: It adds a new row with the formatted message data to a specified Google Sheet.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Telegram Bot: A Telegram bot token (obtained from BotFather) and a configured bot.
• Google Account: A Google account with access to Google Sheets.
• Google Sheet: An existing Google Sheet where the messages will be saved. You will need the Spreadsheet ID and the name of the sheet.

Setup/Usage

1. Import the workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Telegram Trigger:
   • Click on the "Telegram Trigger" node.
   • Add your Telegram Bot API Token credential.
   • Ensure the "Updates" field is set to "Message".
   • Activate the workflow. n8n will provide a webhook URL that you need to set for your Telegram bot (usually done via the Telegram Bot API or by sending a /setwebhook command to BotFather if not automatically handled by n8n).
3. Configure Function Item:
   • The "Function Item" node contains JavaScript code to extract and format the Telegram message data. Review and adjust the code if you need to extract different fields or format them in a specific way. By default, it likely extracts chatId, chatType, fromId, fromFirstName, fromLastName, fromUsername, messageId, and messageText.
4. Configure Google Sheets Node:
   • Click on the "Google Sheets" node.
   • Add your Google Sheets API credential (OAuth2 is recommended for secure access).
   • Select the "Append Row" operation.
   • Enter the Spreadsheet ID of your target Google Sheet.
   • Enter the Sheet Name (e.g., "Sheet1").
   • Map the data from the "Function Item" node to the columns in your Google Sheet. For example, if your Google Sheet has columns like "Timestamp", "Chat ID", "Sender Username", "Message", you would map them accordingly using expressions like {{ $json.timestamp }}, {{ $json.chatId }}, {{ $json.fromUsername }}, {{ $json.messageText }}.
5. Activate the Workflow: Once all credentials and configurations are set, activate the workflow. It will now automatically listen for new Telegram messages and save them to your Google Sheet.