{"product_id":"construction-punch-list-automation-openai-google-sheets-gmail","title":"Construction Punch List Automation: OpenAI + Google Sheets + Gmail","description":"\u003ch3\u003eTurn construction punch list messages into routed tasks automatically—using OpenAI, Google Sheets, and Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow takes incoming punch list text via \u003cstrong\u003ewebhook\u003c\/strong\u003e, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to structure each item (location, trade, severity, description), logs it to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and emails the responsible subcontractor via \u003cstrong\u003eGmail\u003c\/strong\u003e. It also notifies stakeholders in \u003cstrong\u003eTelegram\u003c\/strong\u003e and sends a weekly status summary.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives\u003c\/strong\u003e a POST request through a webhook containing the punch list message, sender, and a Telegram chat ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates the message text\u003c\/strong\u003e. If missing, it replies with usage instructions in Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts structured fields\u003c\/strong\u003e using OpenAI: location, trade, severity, and description.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes to the right subcontractor\u003c\/strong\u003e by looking up the trade in a Google Sheets tab called \u003cstrong\u003eTradeRoster\u003c\/strong\u003e (trade → company name → contact email).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates parsed results\u003c\/strong\u003e. If key fields are missing, it requests a clearer message and\/or a roster-mapped trade via Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs every item\u003c\/strong\u003e to a Google Sheets tab called \u003cstrong\u003ePunchLog\u003c\/strong\u003e, then \u003cstrong\u003eemails\u003c\/strong\u003e the assigned subcontractor via Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends alerts\u003c\/strong\u003e to the project manager in Telegram when severity is \u003cstrong\u003eCritical\u003c\/strong\u003e or \u003cstrong\u003eHigh\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly reporting\u003c\/strong\u003e: every Monday at \u003cstrong\u003e09:00\u003c\/strong\u003e, it pulls open items from PunchLog, uses OpenAI to generate a concise weekly report, and delivers it via \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomatically convert site punch list notes received in messages into assigned subcontractor work items.\u003c\/li\u003e\n  \u003cli\u003eReduce follow-up delays by emailing the correct trade from a maintained Google Sheets roster.\u003c\/li\u003e\n  \u003cli\u003eSend guaranteed weekly punch status updates to stakeholders with one scheduled run.\u003c\/li\u003e\n  \u003cli\u003eEscalate Critical\/High issues instantly to a project manager through Telegram.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook\u003c\/strong\u003e to accept punch list submissions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e for extracting structured punch list data and summarizing weekly reports.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (OAuth2) with two tabs: \u003cstrong\u003ePunchLog\u003c\/strong\u003e and \u003cstrong\u003eTradeRoster\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e (OAuth2) to notify subcontractors and send weekly summaries.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram\u003c\/strong\u003e to confirm logging, request clarifications, and alert the project manager.\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic uses nodes such as \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003ewebhook\u003c\/strong\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e, and \u003cstrong\u003esummarize\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup\u003c\/strong\u003e requires creating the PunchLog and TradeRoster tabs in Google Sheets, and adding credentials for OpenAI, Google Sheets (OAuth2), Gmail (OAuth2), and Telegram Bot API in n8n.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45865765306547,"sku":"N8N-18358","price":11.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/05GDd3oyTqMsybYzxMGNi_OqzpU0Xv.png?v=1787044627","url":"https:\/\/buyflowscripts.com\/products\/construction-punch-list-automation-openai-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}