Track and manage construction RFIs with Gmail, OpenAI, and Data Tables
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 41 nodes and runs manually, when you click “Execute workflow” (plus 2 other triggers). Along the way it connects Gmail, OpenAI Chat Model and Data table.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 2 other triggers).
- Create RFI Projects Table (Data table): create (table)
- RFI Intake Settings (Edit Fields (Set)): sets 5 fields: company_name, project_team_name, review_inbox…
- Sweep Settings (Edit Fields (Set)): sets 3 fields: company_name, project_team_name, escalate_after_days
- Create RFI Log Table (Data table): create (table)
- Loop Over RFI Emails (Loop Over Items (Split in Batches)): loops over the items in batches
- Load Open RFIs (Data table): get
- Add Sample Project (Data table): uses Data table
- Extract Attached PDF Text (Extract from File): extracts data from a file (pdf)
- Age and Route Open RFIs (Code): runs custom JavaScript code
- Build the Open RFI Digest (Code): runs custom JavaScript code
…plus 25 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 (15)
- Manual Trigger
n8n-nodes-base.manualTrigger - Data table
n8n-nodes-base.dataTable - Gmail Trigger
n8n-nodes-base.gmailTrigger - Edit Fields (Set)
n8n-nodes-base.set - Extract from File
n8n-nodes-base.extractFromFile - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Data Table Tool
n8n-nodes-base.dataTableTool - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Switch
n8n-nodes-base.switch - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview This workflow monitors an RFI Gmail inbox, uses OpenAI to classify and extract RFI details (including PDF text), logs everything to n8n Data Tables, routes new questions to the design team, files answers back to the requester with PM approval…