{"product_id":"auto-snow-ice-crew-dispatch-with-open-meteo-gpt-4o","title":"Auto Snow \u0026 Ice Crew Dispatch with Open-Meteo, GPT-4o","description":"\u003ch3\u003eAuto Snow \u0026amp; Ice Dispatch that Runs Itself (Open-Meteo + GPT-4o)\u003c\/h3\u003e\n\u003cp\u003eStop manually checking weather and calling crews. This n8n workflow automatically sweeps Open-Meteo forecasts for every site listed in your Google Sheets, and dispatches snow\/ice crews the moment each site’s trigger criteria are met—then generates AI crew briefs and client notices and tracks every step through webhooks.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules or starts on demand:\u003c\/strong\u003e runs every 3 hours, or you can trigger a forecast sweep via a webhook.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads site data from Google Sheets:\u003c\/strong\u003e pulls the \u003cem\u003eSites\u003c\/em\u003e tab and validates required fields (IDs, coordinates, triggers, and emails).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles bad data fast:\u003c\/strong\u003e invalid rows are sent to an admin via \u003cstrong\u003eGmail\u003c\/strong\u003e, posted to \u003cstrong\u003eTelegram\u003c\/strong\u003e, and recorded in the \u003cem\u003eErrors\u003c\/em\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks Open-Meteo forecasts hourly:\u003c\/strong\u003e fetches a 2-day hourly forecast for each valid site and evaluates the next 12 hours using the site’s snow trigger and freezing-precipitation criteria.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs every sweep:\u003c\/strong\u003e writes sweep results to \u003cem\u003eCheckLog\u003c\/em\u003e (checked counts, dispatch counts, no-action sites, and rejected rows).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDispatches when triggers are met:\u003c\/strong\u003e when one or more sites need dispatch, it uses \u003cstrong\u003eGPT-4o\u003c\/strong\u003e to generate a storm summary plus a crew brief and client notice for each site.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTracks dispatch outcomes:\u003c\/strong\u003e creates dispatch entries in \u003cem\u003eDispatchLog\u003c\/em\u003e and follows up using confirmation and follow-up \u003cstrong\u003ewebhooks\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProperty management teams dispatching snow removal based on site-specific thresholds.\u003c\/li\u003e\n  \u003cli\u003eOperators managing multiple locations who need consistent, automated crew communication.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an n8n weather-to-dispatch pipeline with reliable logging and error handling.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n schedule\u003c\/strong\u003e (every 3 hours) + \u003cstrong\u003ewebhook\u003c\/strong\u003e for on-demand runs\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: Sites, Errors, CheckLog, DispatchLog\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpen-Meteo\u003c\/strong\u003e: 2-day hourly forecast evaluation for the next 12 hours\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGPT-4o\u003c\/strong\u003e: storm summary, crew brief, and client notice generation\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eTelegram\u003c\/strong\u003e: invalid-row alerts and notifications\u003c\/li\u003e\n  \u003cli\u003eCore workflow nodes: if, set, code, no op, gmail, webhook\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eLast updated:\u003c\/strong\u003e September 2026.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46029587808435,"sku":"N8N-19569","price":55.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/K7hOhqFOA3tPwhhT1wD1O_zU8RsHTm.png?v=1789464243","url":"https:\/\/buyflowscripts.com\/products\/auto-snow-ice-crew-dispatch-with-open-meteo-gpt-4o","provider":"N8N Commerce","version":"1.0","type":"link"}