Send daily daycare menu, schedule, and weather briefings with Gemini and WhatsApp
Ready for 3.0What this workflow does
This AI workflow has 17 nodes and runs on a schedule (cron 0 7 * * *). Along the way it connects Google Gemini Chat Model and Google Sheets. It also calls api.open-meteo.com and api.callmebot.com over HTTP.
How it runs
Trigger: On a schedule (cron 0 7 * * *).
- Set Initial Parameters (Edit Fields (Set)): sets 7 fields: menu_url, timezone, latitude…
- Calculate Date and Avoid Duplicates (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Fetch Daycare Menu Page (HTTP Request): calls an HTTP API
- Read Family Schedule from Sheets (Google Sheets): uses Google Sheets
- Locate Today's Menu Section (Code): runs custom JavaScript code
- Fetch Weather Forecast (HTTP Request): calls api.open-meteo.com
- If: checks a condition and branches into true / false
- Generate Weather and Clothing Advice (Code): runs custom JavaScript code
- Extract Menu Using Gemini (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini AI Model
…plus 5 more steps. See the full node list below.
Services it uses
HTTP calls to: api.open-meteo.com, api.callmebot.com
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 (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow runs every morning to fetch a daycare menu from a webpage, read your family schedule from Google Sheets, and pull a local forecast from Open-Meteo, then uses Google Gemini to reliably extract today’s meals and sends a single…