Templates / Manage construction projects with tasks, photo reports, Telegram & Google Sheets

Manage construction projects with tasks, photo reports, Telegram & Google Sheets

Needs changes

by Artem Boiko ✓ · 4,910 views · created 2025-07-30 · Project Management

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: Cron. 1 breaking item(s) found. Static check, last run 2026-10-19.

What 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).

  1. Get tasks (Google Sheets): uses Google Sheets
  2. Get photo reports data (Google Sheets): uses Google Sheets
  3. Process incoming message (Code): runs custom JavaScript code
  4. Find and form messages - Tasks (Code): runs custom JavaScript code
  5. Find and form messages - Photo (Code): runs custom JavaScript code
  6. Check send_message (If): checks a condition and branches into true / false
  7. Check check_status (If): checks a condition and branches into true / false
  8. Check send_report_menu (If): checks a condition and branches into true / false
  9. Check manual_report (If): checks a condition and branches into true / false
  10. 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

Google SheetsTelegramGoogle Drive

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.0Replace with
Cron
Check every minute - Photo, Check every minute - Tasks
Schedule Trigger

Nodes used (9)

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:…

Excerpt from Artem Boiko's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.