{"product_id":"n8n-nursery-plant-risk-alerts-openweather-gemini-slack","title":"n8n Nursery Plant Risk Alerts: OpenWeather + Gemini + Slack","description":"\u003ch3\u003eGet daily nursery temperature risk alerts—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n automation workflow\u003c\/strong\u003e checks overnight weather from \u003cstrong\u003eOpenWeatherMap\u003c\/strong\u003e, compares it against your plant inventory from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to detect at-risk plants, and posts critical alerts to your chosen \u003cstrong\u003eSlack\u003c\/strong\u003e channel—every day at \u003cstrong\u003e7 PM IST\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e Executes daily at \u003cstrong\u003e7 PM IST\u003c\/strong\u003e using an n8n schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches overnight forecast:\u003c\/strong\u003e Calls the \u003cstrong\u003eOpenWeatherMap API\u003c\/strong\u003e (configured via latitude, longitude, and units) to compute the overnight low\/high and summarize conditions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads plant inventory:\u003c\/strong\u003e Reads plant data from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, aggregating the rows into a single list for analysis.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects temperature tolerance risk with AI:\u003c\/strong\u003e Sends the forecast and plant list to a \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e agent, which returns a structured list of \u003cstrong\u003eplant risk alerts\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConditionally notifies:\u003c\/strong\u003e If alerts are returned, the workflow formats them into one notification message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts to Slack:\u003c\/strong\u003e Sends the final alert message to the selected \u003cstrong\u003eSlack\u003c\/strong\u003e channel.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNursery and greenhouse operations:\u003c\/strong\u003e Catch overnight temperature risks before staff notice damage.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS teams running ops workflows:\u003c\/strong\u003e Use scheduled environmental checks to trigger internal notifications.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers:\u003c\/strong\u003e Deploy a practical pattern combining weather, inventory, AI analysis, and Slack alerts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenWeatherMap\u003c\/strong\u003e via \u003cstrong\u003eHTTP Request\u003c\/strong\u003e (HTTP Query Auth credential)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e via Service Account (or updated authentication)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini (Google PaLM)\u003c\/strong\u003e for structured risk alert output\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e integration to post notifications\u003c\/li\u003e\n  \u003cli\u003eUses workflow logic and data handling nodes including \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003eaggregate\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e, plus \u003cstrong\u003eslack\u003c\/strong\u003e delivery\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eCustomize the latitude\/longitude, spreadsheet\/sheet, and schedule (cron) to match your local nursery conditions.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45755361198259,"sku":"N8N-17729","price":6.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/O5CJie7LxZp-wzsOSiF6p_fbDgXBo1.png?v=1785661455","url":"https:\/\/buyflowscripts.com\/products\/n8n-nursery-plant-risk-alerts-openweather-gemini-slack","provider":"N8N Commerce","version":"1.0","type":"link"}