Monitor construction execution from Google Drive photos with GPT‑4.1‑mini, Gmail and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 15 nodes and runs on a schedule (every second). Along the way it connects OpenAI Chat Model, Google Drive, Gmail and Google Sheets.
How it runs
Trigger: On a schedule (every second).
- Config (Edit Fields (Set)): sets 8 fields: runTimestamp, inputFolderId, reportLanguage…
- Drive: List files (Input folder) (Google Drive): work with file folder
- Filter: keeps only the items that match a condition
- If: checks a condition and branches into true / false
- Drive: Download image (Google Drive): download
- AI: Analyze image (AI Agent): runs an AI agent, with model: OpenAI Chat Model
- Prepare: Image data (Edit Fields (Set)): sets 4 fields: imageId, imageName, binaryImage…
- Gmail: uses Gmail
- Drive: Share image (anyone reader) (Google Drive): share
- Sheets: Append log row (Google Sheets): append
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Edit Fields (Set)
n8n-nodes-base.set - Google Drive
n8n-nodes-base.googleDrive - Filter
n8n-nodes-base.filter - AI Agent
@n8n/n8n-nodes-langchain.agent - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - No Operation, do nothing
n8n-nodes-base.noOp - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if
From the author
AI-Driven construction execution monitoring What This Workflow Does Monitor construction execution with AI by analyzing site photos from Google Drive and automatically generating structured Work Performance Data. This workflow enables you to: - Monitor…