{"product_id":"construction-rfi-submittal-tracker-with-n8n-airtable-gmail","title":"Construction RFI \u0026 Submittal Tracker with n8n, Airtable, Gmail","description":"\u003ch3\u003eAutomatically track Construction RFIs \u0026amp; Submittals—then notify everyone on time\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures incoming construction RFIs and submittals through webhooks, logs them into \u003cstrong\u003eAirtable\u003c\/strong\u003e, drafts acknowledgment emails with \u003cstrong\u003eOpenAI\u003c\/strong\u003e, and pushes updates instantly via \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eDiscord\u003c\/strong\u003e, and \u003cstrong\u003eTelegram\u003c\/strong\u003e—including urgent escalation and an automated daily due\/overdue sweep.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives new RFI submissions\u003c\/strong\u003e via a webhook, normalizes the payload, and rejects incomplete requests while alerting the office through \u003cstrong\u003eDiscord\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrioritizes each RFI\u003c\/strong\u003e using its due date and keywords, then uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to categorize the question and draft an acknowledgment email; it parses the JSON response with a fallback if needed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates records in Airtable\u003c\/strong\u003e in an “\u003cstrong\u003eRFI Register\u003c\/strong\u003e”, emails the acknowledgment to the submitter via \u003cstrong\u003eGmail\u003c\/strong\u003e, and posts a “new RFI” message to \u003cstrong\u003eDiscord\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates engineering-required items\u003c\/strong\u003e by sending an urgent \u003cstrong\u003eDiscord\u003c\/strong\u003e message, a \u003cstrong\u003eTelegram\u003c\/strong\u003e alert, and emailing an engineer via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives RFI answers\u003c\/strong\u003e via a separate webhook, validates the payload, finds the matching Airtable entry, and updates the record to “\u003cstrong\u003eanswered\u003c\/strong\u003e”.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies submitters\u003c\/strong\u003e by emailing the answer through \u003cstrong\u003eGmail\u003c\/strong\u003e, logs updates to \u003cstrong\u003eDiscord\u003c\/strong\u003e, and alerts the office if the answer is invalid or doesn’t match any Airtable record.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses new submittals\u003c\/strong\u003e via webhook: validates required fields, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to classify and draft an acknowledgment, logs to Airtable “\u003cstrong\u003eSubmittal Log\u003c\/strong\u003e”, then emails the submitter and posts to \u003cstrong\u003eDiscord\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGeneral contractors routing RFIs to the right team with priority and due-date awareness.\u003c\/li\u003e\n  \u003cli\u003eEngineering review escalation when an RFI is flagged for additional scrutiny.\u003c\/li\u003e\n  \u003cli\u003eSubmittal intake automation that keeps owners and teams informed without manual copy\/paste.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e if, set, code, webhook, gmail, discord\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData storage:\u003c\/strong\u003e Airtable (RFI Register, Submittal Log)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComms:\u003c\/strong\u003e Gmail, Discord, Telegram (including urgent alerts)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI assistance:\u003c\/strong\u003e OpenAI for RFI\/submittal categorization and acknowledgment email drafting\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978922516659,"sku":"N8N-19350","price":55.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/OS4yapXfHHabbAsztTrU3_9kvZl8eK.png?v=1788858879","url":"https:\/\/buyflowscripts.com\/products\/construction-rfi-submittal-tracker-with-n8n-airtable-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}