Standardize daily construction reports with OpenAI, Gmail and Google 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.
What this workflow does
This AI workflow has 13 nodes and runs when a chat message arrives. Along the way it connects Guardrails, Gmail, OpenAI Chat Model and Google Sheets.
How it runs
Trigger: When a chat message arrives.
- Config (Edit Fields (Set)): sets 7 fields: runTimestamp, reportLanguage, emailTo…
- Guardrail: Validate Input (Guardrails): uses Guardrails, with model: Guardrail Chat Model: OpenAI
- AI: Standardize DCR (AI Agent): runs an AI agent, with model: AI Chat Model: OpenAI
- Gmail: uses Gmail
- Sheets: Append DCR Log (Google Sheets): append
- Chat: uses Chat
- Gmail: uses Gmail
- Chat: uses Chat
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 (9)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Guardrails
@n8n/n8n-nodes-langchain.guardrails - Gmail
n8n-nodes-base.gmail - Chat
@n8n/n8n-nodes-langchain.chat - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Sheets
n8n-nodes-base.googleSheets - No Operation, do nothing
n8n-nodes-base.noOp - Edit Fields (Set)
n8n-nodes-base.set
From the author
AI-Driven daily construction report (DCR) standardization What This Workflow Does Standardize Daily Construction Reports (DCR) with AI by capturing raw site inputs via chat and automatically generating structured Work Performance Data. This workflow enables…