Construction Site Management via Telegram and Google Sheets - n8n Workflow

• Construction Project Managers needing automated task distribution.


• Foremen or site supervisors managing daily reporting from field staff.


• Teams requiring robust, time-stamped photo documentation for compliance.


• Users looking for advanced projecttaskmanagement n8n templates.

This is a highly sophisticated, two-part n8n workflow designed for real-time construction site coordination. It solves the critical problem of timely documentation (tasks and photo reports) by transforming Google Sheets data into actionable Telegram messages. The automation runs two parallel loops using a Cron n8n trigger to check task deadlines and report schedules every minute. Executors receive personalized reminders and can submit reports (text statuses, photos, or GPS locations) directly back to the system via an interactive Telegram bot. All inputs are meticulously processed, uploaded to Google Drive, and logged in Google Sheets, ensuring a clear audit trail. This robust n8n workflow drastically improves project tracking efficiency.

The n8n workflow operates in two main modes: scheduled reminders and real-time interaction.

1. Scheduled Reminders (Tasks & Photos): The process begins with a Cron n8n trigger firing every minute. The workflow reads the 'Tasks' and 'Photo Reports' Google Sheets using the Google Sheets n8n node. A Code n8n node (Find and form messages) calculates the current time against the scheduled reminder time, identifying any new or repeated overdue items. If messages are ready, the flow uses a Telegram n8n node to send personalized notifications. Finally, another Google Sheets n8n node updates the row status, marking the item as "Reminder Sent" and logging the time.

1. Real-time Interaction (Telegram Webhook): The Telegram Webhook n8n trigger receives user input. The central Process incoming message1 Code n8n node analyzes the message content, routing requests based on commands (/start, /status, /read) or media type (Photo, Location).

1. Photo & GPS Submission: When a user replies with a photo or geolocation, the flow extracts the associated Task ID. Photos are downloaded, uploaded to Google Drive (Upload to Google Drive4 n8n node), grouped if sent simultaneously, and then either update an existing report row or create a new one in the 'Photo Reports' sheet using the Google Sheets n8n node. GPS data follows a similar lookup and update path.

1. Task Status Submission: When a user replies with a text status (e.g., 'completed'), the system verifies task ownership (Check ID Match1), updates the status, comment, and report date in the 'Tasks' sheet using the Google Sheets n8n node, and sends a confirmation message.

To deploy this powerful n8n workflow, follow these steps:

1. Import the n8n workflow: Copy the provided JSON into your n8n instance using the "Import Workflow" function.


2. Google Sheets Setup: You need a single Google Sheet document containing at least three tabs: 'Tasks', 'Photo Reports', and 'Users'. Ensure the column headers (like 'Task ID', 'Executor ID', 'Reminder Sent') match those expected by the Google Sheets n8n node configurations.


3. Credentials:

1. Activation: The Telegram Webhook - Receiving messages n8n trigger must be configured and activated (set to Active). Ensure the two Cron n8n trigger nodes (Check every minute - Tasks and Check every minute - Photo) are also active to begin sending automated reminders. This n8n workflow template is ready for immediate operation once credentials are set.

Cron n8n trigger: (Check every minute - Tasks, Check every minute - Photo): These are the primary n8n trigger nodes responsible for initiating the scheduled reminder loops, ensuring that tasks and reports are checked every 60 seconds.
Google Sheets n8n node: Used throughout as the database layer (Get tasks, Update status in table - Tasks, Record new executor, Find Task for GPS). It performs read, update, and append operations across the three main sheets ('Tasks', 'Photo Reports', 'Users').
Code n8n node: This n8n node performs complex transformations and validation, including date parsing from Excel formats, calculating reminder logic (Find and form messages), and preparing bulk updates for Google Sheets.
Telegram Webhook n8n trigger: The core interactive n8n trigger that listens for all user input (commands, photos, geolocation) directed at the Telegram bot.
Telegram n8n node: Handles outbound communication, sending reminders, confirmations, errors, and welcome messages to users. Configuration includes setting the parse_mode to HTML or Markdown for rich formatting.
Google Drive n8n node: (Upload to Google Drive4): Saves incoming photo attachments directly to a specified Google Drive folder, linking the file path back to the Google Sheets n8n node for logging.

• If n8n node: Crucial for routing messages based on user intent (e.g., checking if the message is a /start command, a photo, or a task report), maintaining the complex branching structure of this n8n workflow.