Save Telegram Reply to Google Sheet Journal

Name: Save Telegram Reply to Google Sheet Journal
Rating: 2.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

22 views

0 downloads

Integrationsautomationgoogle sheetsjournalloggingtelegram

Logs replies from a specific Telegram user to a Google Sheet as journal entries.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow automates the process of saving specific Telegram messages, specifically replies to the bot, into a Google Sheet. It's designed to act as a personal journal where you can send messages via Telegram and have them automatically recorded with a date.

Key Features

Triggers on Telegram messages that are replies to the bot.
Filters messages to only accept replies from a specific user.
Parses the message content and a specified date format.
Appends the journal entry and date to a designated Google Sheet.

How To Use

Configure the Telegram Trigger node with your bot token.
Set the BOT_USERNAME and YOUR_USERNAME variables in the 'Parse message' function.
Ensure your Telegram messages are formatted as "SOME CUSTOM MESSAGE: YYYY-MM-DD" where "SOME CUSTOM MESSAGE" is your journal entry and "YYYY-MM-DD" is the date.
Set the YOUR_SPREADSHEET_ID in the Google Sheets node.
Ensure the Google Sheets node is configured to append data to the correct sheet.

Apps Used

automation

google sheets

journal

logging

Workflow JSON

{
  "id": "5ac3747b-f36a-41f3-bcf1-f11c03dfdddd",
  "name": "Save Telegram Reply to Google Sheet Journal",
  "nodes": 0,
  "category": "Integrations",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.