Back to Templates

Track Construction Site Progress with Google Gemini AI, Drive Photos and Sheets

Last update

Last update 22 days ago

Share


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