n8n Nursery Plant Risk Alerts: OpenWeather + Gemini + Slack

Get daily nursery temperature risk alerts—automatically

This n8n automation workflow checks overnight weather from OpenWeatherMap, compares it against your plant inventory from Google Sheets, uses Google Gemini to detect at-risk plants, and posts critical alerts to your chosen Slack channel—every day at 7 PM IST.

What this workflow does

• Runs on a schedule: Executes daily at 7 PM IST using an n8n schedule trigger.
• Fetches overnight forecast: Calls the OpenWeatherMap API (configured via latitude, longitude, and units) to compute the overnight low/high and summarize conditions.
• Loads plant inventory: Reads plant data from Google Sheets, aggregating the rows into a single list for analysis.
• Detects temperature tolerance risk with AI: Sends the forecast and plant list to a Google Gemini agent, which returns a structured list of plant risk alerts.
• Conditionally notifies: If alerts are returned, the workflow formats them into one notification message.
• Posts to Slack: Sends the final alert message to the selected Slack channel.

Use cases

• Nursery and greenhouse operations: Catch overnight temperature risks before staff notice damage.
• SaaS teams running ops workflows: Use scheduled environmental checks to trigger internal notifications.
• Automation engineers: Deploy a practical pattern combining weather, inventory, AI analysis, and Slack alerts.

Technical details

• OpenWeatherMap via HTTP Request (HTTP Query Auth credential)
• Google Sheets via Service Account (or updated authentication)
• Google Gemini (Google PaLM) for structured risk alert output
• Slack integration to post notifications
• Uses workflow logic and data handling nodes including if, set, aggregate, and sticky note, plus slack delivery

Customize the latitude/longitude, spreadsheet/sheet, and schedule (cron) to match your local nursery conditions.