Log and report construction punch list items with OpenAI, Google Sheets, Gmail and Telegram
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 25 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Telegram, OpenAI Chat Model, Google Sheets and Gmail.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Normalize Punch Message (Edit Fields (Set)): sets 3 fields: text, chat_id, sender
- Get Punch Log (Google Sheets): uses Google Sheets
- Validate Message (If): checks a condition and branches into true / false
- Filter Open Items (If): checks a condition and branches into true / false
- AI Punch Parser (AI Agent): runs an AI agent, with model: OpenAI Punch Model; 1 tool (Trade Roster Tool)
- Reply Help Text (Telegram): uses Telegram
- Build Report Lines (Edit Fields (Set)): sets 1 field: item_line
- No Open Items Telegram (Telegram): uses Telegram
- Extract Punch Item (Edit Fields (Set)): sets 11 fields: punch_id, received_at, sender…
- Summarize: summarizes / groups the items
…plus 10 more steps. 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 (11)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Telegram
n8n-nodes-base.telegram - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Summarize
n8n-nodes-base.summarize
From the author
Construction chaos, organized. Site teams send punch list messages via webhook and this workflow structures each item with AI, routes it to the right subcontractor from a trade roster, logs it to Sheets, and follows up weekly. Critical issues ping the project…