{"product_id":"n8n-construction-risk-triage-sheets-open-meteo-gemini","title":"n8n Construction Risk Triage: Sheets, Open-Meteo \u0026 Gemini","description":"\u003ch3\u003eKnow construction schedule \u0026amp; cost risk before it becomes a problem—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e runs every weekday morning to triage \u003cstrong\u003econstruction delivery risk\u003c\/strong\u003e using \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, a \u003cstrong\u003e7-day Open-Meteo weather forecast\u003c\/strong\u003e, and \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e—then logs a structured escalation decision and emails the project manager when intervention is needed.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules execution\u003c\/strong\u003e at \u003cstrong\u003e7:00 AM, Monday–Friday\u003c\/strong\u003e via cron.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads active projects\u003c\/strong\u003e from the Google Sheets \u003cem\u003eProjects\u003c\/em\u003e tab (projects marked \u003cem\u003eActive\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls 7-day forecasts\u003c\/strong\u003e from the \u003cstrong\u003eOpen-Meteo API\u003c\/strong\u003e for each project using its \u003cstrong\u003elatitude and longitude\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads supporting data\u003c\/strong\u003e from other tabs in the same spreadsheet, including \u003cem\u003ebudget\/accounting, procurement, labor, site reports, and disputes\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes risk metrics\u003c\/strong\u003e across schedule, procurement, labor, disputes, weather, reporting integrity, and budget risk—then derives a rule-based decision:\n    \u003cstrong\u003eCONTINUE\u003c\/strong\u003e, \u003cstrong\u003eINTERVENE\u003c\/strong\u003e, or \u003cstrong\u003eSTOP_REVIEW\u003c\/strong\u003e, including the most impactful mitigation lever and deadline.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates the decision with Google Gemini\u003c\/strong\u003e by generating a structured decision JSON (headline, reasons, critical action, confidence) while applying guardrails for overrides.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs results\u003c\/strong\u003e by appending each decision to the Google Sheets \u003cem\u003eDecision_Log\u003c\/em\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails only when needed\u003c\/strong\u003e: the project manager receives a Gmail message when the decision is \u003cstrong\u003eINTERVENE\u003c\/strong\u003e or \u003cstrong\u003eSTOP_REVIEW\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily executive triage for multi-site construction programs tracking budget, procurement, labor, and disputes.\u003c\/li\u003e\n  \u003cli\u003eEscalation when weather risk (from Open-Meteo) threatens delivery timelines and budget integrity.\u003c\/li\u003e\n  \u003cli\u003eOperational teams needing consistent, auditable escalation records in Google Sheets with Gemini-structured explanations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (Service Account access), \u003cstrong\u003eOpen-Meteo\u003c\/strong\u003e (HTTP Request), \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow components:\u003c\/strong\u003e \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003ehttp request\u003c\/em\u003e, \u003cem\u003efilter\u003c\/em\u003e, \u003cem\u003elimit\u003c\/em\u003e, and messaging\/notes via \u003cem\u003esticky note\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46196346618035,"sku":"N8N-20433","price":54.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/yS1M_DwFBwdQyCFIqHfUF_1ZcEpp7M.png?v=1791623896","url":"https:\/\/buyflowscripts.com\/products\/n8n-construction-risk-triage-sheets-open-meteo-gemini","provider":"N8N Commerce","version":"1.0","type":"link"}