Developer & DevOps

Receive Telegram messages and log them to spreadsheets

21 nodes 282 123 Automatic trigger
Download

Workflow Description

Automation that receives incoming Telegram messages and classifies them based on content, then automatically records them in a spreadsheet file while handling attachments and executing commands.

How it works

  1. 1.Receive new message from Telegram and determine its type
  2. 2.Process attached files or execute requested commands
  3. 3.Record message data in the spreadsheet file

Use cases

  • Automatically log important messages for review and documentation
  • Process requests and commands sent via Telegram and execute them immediately
  • Collect data and files from Telegram channels into a centralized repository

Requirements

  • Active Telegram account with bot credentials configured
  • Access to an editable spreadsheet file
  • n8n with enabled Telegram and file handling nodes

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

Telegram Spreadsheet File

Details

Trigger Automatic trigger
Nodes 21
Apps 2
Views 282
Downloads 123

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (21)

/

Switch

Switch

#1

msg_greet

Set

#2

msg_wrongcommand

Set

#3

Telegram Trigger

Set

#4

msg_getweather

Set

#5

City List

Function

#6

Convert API response

Function

#7

Get weather data

HTTP Request

#8

Spreadsheet File

Spreadsheet File

#9

Write csv

Write Binary File

#10

Filename

Set

#11

msg_errorAPI

Set

#12

Any errors API?

If

#13

msg_errorR

Set

#14

Read Binary File

Read Binary File

#15

R successful?

If

#16

Merge

Merge

#17

Merge1

Merge

#18

msg_pleasewait

Set

#19

Merge2

Merge

#20

Run R script

Execute Command

#21