Track construction site progress with Google Gemini AI, drive photos and Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Drive
n8n-nodes-base.googleDrive - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Send Email
n8n-nodes-base.emailSend
What it does
This automated n8n workflow leverages AI to monitor construction site progress using daily site photos, providing real-time updates and detailed tracking. The system analyzes images, generates progress summaries, and appends data to a Google Sheet for comprehensive project management. Good to Know - Supports daily photo analysis for construction progress tracking - Utilizes Google Gemini AI for intelligent image processing and analysis - Includes memory to maintain context of ongoing construction updates - Automates data appending to Google Sheets for real-time tracking - Integrates with scheduled triggers for consistent daily updates How It Works - Schedule Trigger - Initiates the workflow daily to check for new site photos - List a file - Retrieves the latest photos from the designated drive folder - Tack All Images - Passes each photo to the AI for individual analysis - AI Analysis - Processes images using Google Gemini to detect construction progress - Append data to a sheet - Updates a Google Sheet with the analyzed progress data - Send email - Notifies stakeholders with a daily progress update How to Use - Import workflow into n8n - Configure Google Drive API for photo access - Set up Google Gemini AI model for image analysis - Configure Google Sheets API for data appending - Set up email notification settings - Test with sample photos and monitor updates - Adjust AI parameters for accuracy as needed Requirements - Access to Google Drive API - Google Gemini AI model integration - Google Sheets API access - Email service configuration - Scheduled trigger setup in n8n Sheet Columns: - Date - Photo ID - Progress Summary - Status - Notes Customizing This Workflow - Modify AI prompts for specific construction milestones - Adjust photo analysis frequency based on project needs - Configure custom Google Sheet columns for additional data - Set up custom email templates for stakeholder updates - Integrate additional AI models for enhanced analysis