Alert on at-risk nursery plants with OpenWeather, Google Sheets, Gemini, and Slack
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 14 nodes and runs on a schedule (cron 30 13 * * *). Along the way it connects Google Sheets, Google Gemini Chat Model and Slack. It also calls api.openweathermap.org over HTTP.
How it runs
Trigger: On a schedule (cron 30 13 * * *).
- Set Weather Parameters (Edit Fields (Set)): sets 3 fields: lat, lon, units
- Fetch Weather Forecast (HTTP Request): calls api.openweathermap.org
- Summarize Overnight Weather (Edit Fields (Set)): sets 4 fields: overnight_low_f, overnight_high_f, conditions…
- Read Plants from Sheets (Google Sheets): uses Google Sheets
- Aggregate: combines items into one
- Build Plant Risk Prompt (Edit Fields (Set)): sets 1 field: prompt
- Plant Risk Analyzer Agent (AI Agent): runs an AI agent, with model: Google Gemini Model; output parser: Parse AI Output Structure
- Parse AI Response (Edit Fields (Set)): sets 1 field: alerts
- If: checks a condition and branches into true / false
- Prepare Alert Message (Edit Fields (Set)): sets 1 field: message
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: api.openweathermap.org
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - If
n8n-nodes-base.if - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - AI Agent
@n8n/n8n-nodes-langchain.agent - Slack
n8n-nodes-base.slack
From the author
Quick Overview This workflow runs daily at 7 PM IST, pulls an overnight forecast from OpenWeatherMap and plant inventory data from Google Sheets, uses Google Gemini to identify plants whose temperature tolerances are at risk, and posts critical alerts to a…