Manage construction projects with tasks, photo reports, Telegram & Google Sheets
Needs changesWhat this workflow does
This workflow has 100 nodes and runs on a schedule (legacy Cron node) (plus 2 other triggers). Along the way it connects Google Sheets, Telegram and Google Drive.
How it runs
Trigger: On a schedule (legacy Cron node) (plus 2 other triggers).
- Get tasks (Google Sheets): uses Google Sheets
- Get photo reports data (Google Sheets): uses Google Sheets
- Process incoming message (Code): runs custom JavaScript code
- Find and form messages - Tasks (Code): runs custom JavaScript code
- Find and form messages - Photo (Code): runs custom JavaScript code
- Check send_message (If): checks a condition and branches into true / false
- Check check_status (If): checks a condition and branches into true / false
- Check send_report_menu (If): checks a condition and branches into true / false
- Check manual_report (If): checks a condition and branches into true / false
- Check register_user (If): checks a condition and branches into true / false
…plus 83 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Cron in Check every minute - Photo, Check every minute - Tasks: replace with Schedule Trigger.
| Removed in 3.0 | Replace with |
|---|---|
| Cron Check every minute - Photo, Check every minute - Tasks | Schedule Trigger |
Nodes used (9)
- If
n8n-nodes-base.if - Code
n8n-nodes-base.code - No Operation, do nothing
n8n-nodes-base.noOp - Cron
n8n-nodes-base.cron - Google Sheets
n8n-nodes-base.googleSheets - Telegram
n8n-nodes-base.telegram - Telegram Trigger
n8n-nodes-base.telegramTrigger - Merge
n8n-nodes-base.merge - Google Drive
n8n-nodes-base.googleDrive
From the author
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:…