{
  "name": "Track construction site progress with Google Gemini AI, drive photos and Sheets",
  "nodes": [
    {
      "id": "da61ca99-96ef-4d45-980a-b345934e1763",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -360,
        -200
      ]
    },
    {
      "id": "12714e65-1608-415f-a7ad-cd5f53011d38",
      "name": "AI Analysis",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        300,
        -200
      ]
    },
    {
      "id": "a49a82ee-e630-4344-99bc-e97647ae5c6c",
      "name": "Append data to a sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        676,
        -200
      ]
    },
    {
      "id": "d478f1a4-023a-49f8-a4ed-84ad03c49714",
      "name": "Tack All Images ",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        80,
        -200
      ]
    },
    {
      "id": "477884af-a527-41ad-983e-02f9b82c79bc",
      "name": "List a file",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -140,
        -200
      ]
    },
    {
      "id": "bcf6fcdc-ea52-4ae6-a148-22ae84ecbf73",
      "name": "Google Gemini",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        388,
        20
      ]
    },
    {
      "id": "91e41140-4d9d-466a-8085-34f610a9d4b9",
      "name": "Send email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        900,
        -200
      ]
    },
    {
      "id": "43c14ff9-a3bf-40e7-bb52-95c011799740",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -380,
        -300
      ],
      "parameters": {
        "width": 160,
        "height": 260,
        "content": "Runs the workflow daily to check for new site photos.\n\n"
      }
    },
    {
      "id": "ec04c3bb-f1ea-488b-bca7-1cf82f90209a",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        620,
        -300
      ],
      "parameters": {
        "width": 200,
        "height": 260,
        "content": "Logs the AI-generated summary into a Google Sheet for tracking.\n\n\n\n"
      }
    },
    {
      "id": "4e2ca085-ce22-4225-9521-3f846d273284",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        40,
        -300
      ],
      "parameters": {
        "width": 160,
        "height": 260,
        "content": "Loops through each image to send them individually for AI analysis.\n\n\n"
      }
    },
    {
      "id": "f218dc67-2bf0-4a7c-8efd-9534541c639c",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        -300
      ],
      "parameters": {
        "width": 160,
        "height": 260,
        "content": "Fetches the latest uploaded site photos from the Drive folder.\n\n\n"
      }
    },
    {
      "id": "46582e78-902c-406e-aa0a-1a09e4b2892c",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        280,
        -300
      ],
      "parameters": {
        "width": 280,
        "height": 260,
        "content": "Passes each image to Gemini AI for construction progress detection.\n\n\n"
      }
    },
    {
      "id": "d51ee962-ce7f-4e99-9c0b-640c694d5090",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        860,
        -300
      ],
      "parameters": {
        "width": 160,
        "height": 260,
        "content": "Sends the daily site progress update to stakeholders.\n\n\n"
      }
    }
  ],
  "connections": {
    "AI Analysis": {
      "main": [
        [
          {
            "node": "Append data to a sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "List a file": {
      "main": [
        [
          {
            "node": "Tack All Images ",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini": {
      "ai_languageModel": [
        [
          {
            "node": "AI Analysis",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "List a file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Tack All Images ": {
      "main": [
        [
          {
            "node": "AI Analysis",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Tack All Images ",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append data to a sheet": {
      "main": [
        [
          {
            "node": "Send email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}