Manage Construction Projects with Tasks, Photo Reports, Telegram & Google Sheets — n8n 工作流
概览
How it works This template helps project managers collect task updates and photo reports from field workers via Telegram and stores everything in a Google Sheet. It enables daily project reporting without paper or back-office overhead.
High-level flow:
Workers receive daily tasks via Telegram
They respond with photo reports
Bot auto-saves replies (photos + status) to a Google Sheet
The system tracks task completion, adds timestamps, and maintains report history
Set up steps 🕒 Estimated set
使用的节点
Google SheetsTelegramGoogle DriveCode
工作流预览
A
Are there messages to se…
Prepare Updates
A
Are there updates?
N
No messages
N
No updates
⚡
C
Check every minute - Photo
Get photo reports data
Find and form messages -…
Send to Telegram - Photo
Update status in table -…
⚡
C
Check every minute - Tasks
Get tasks
Find and form messages -…
A
Are there messages to se…
Send to Telegram - Tasks
Prepare updates - Tasks
A
Are there updates? - Tasks
Update status in table -…
N
No messages - Tasks
N
No updates - Tasks
C
Check register_user1
Read users sheet1
Check registration1
C
Check new user1
Generate welcome1
C
Check existing user1
⚡
T
Telegram Webhook - Recei…
C
Check send_message
Send message
C
Check check_status
Read data for status
Collect status from sheet
Generate status message
C
Check send_report_menu
C
Check manual_report
Request registration data1
C
Check read
Read sheet for read
Prepare read updates
F
Filter read summary
F
Filter valid read updates
Update read status in ta…
Send read confirmation
Form read response
C
Check no_reply error
Error message
C
Check complete_registrat…
Prepare data for recording
Record new executor
Confirm registration
Send message2
Group files by task
M
Merge lookup and grouped…
M
Merge for confirmation
Prepare confirmation
C
Check process_photo3
Extract photo data4
C
Check error2
Photo error message4
Get and download file4
C
Check file presence4
Upload to Google Drive4
Prepare data for writing5
Handle retrieval error4
M
Merge file streams2
Check existing task1
D
Does task exist?1
Prepare data for adding2
Update row in table2
Add to reports table1
Confirm photo receipt4
Prepare data for updating2
Send Received Confirmation
C
Check Task Owner1
Get Tasks for Check1
Check ID Match1
C
Check Process Report1
Extract Reports1
Update Task Status1
Format Confirmation1
Confirm Report Save1
C
Check Received1
Get Tasks for Reading1
Prepare Read Updates1
F
Filter Valid Read Updates1
Update Read in Table1
C
Check Command1
Send Command Response1
C
Check Action Type1
Send Report Form1
Find Task for GPS
T
Task Found?
Update GPS in Table
Confirm GPS Receipt
Error - Task Not Found
C
Check Process Location2
Extract Location Data1
C
Check Location Error1
Location Error Message1
Process incoming message1
100 nodes112 edges
工作原理
- 1
触发器
工作流由 定时 触发器启动，按预定计划运行。
- 2
处理
数据流经 100 个节点, connecting code, cron, googledrive。
- 3
输出
工作流完成自动化并将结果发送到配置的目标。
节点详情 (100)
GO#1
Google Sheets
googleSheets
TE#2
Telegram
telegram
GO#3
Google Drive
googleDrive
CO#4
Code
code
如何导入此工作流
- 1点击右侧 下载 JSON 按钮保存工作流文件。
- 2打开你的 n8n 实例，依次点击 工作流 → 新建 → 从文件导入。
- 3选择下载的
manage-construction-projects-with-tasks-photo-reports-telegram-google-sheets文件并点击导入。 - 4为每个服务节点配置 凭证（API 密钥、OAuth 等）。
- 5点击 测试工作流 验证一切正常，然后激活它。
或直接在 n8n → 从 JSON 导入 中粘贴：
{ "name": "Manage Construction Projects with Tasks, Photo Reports, Telegram & Google Sheets", "nodes": [...], ...}
集成
codecrongoogledrivegooglesheetsifmergetelegramtelegramtrigger
创建者
Artem Boiko
@datadrivenconstruction
标签
codecrongoogledrivegooglesheetsifmergetelegramtelegramtrigger