{"product_id":"automated-daily-daycare-menu-weather-briefing-via-whatsapp","title":"Automated Daily Daycare Menu + Weather Briefing via WhatsApp","description":"\u003ch3\u003eGet Your Daycare Menu + Weather Briefing on WhatsApp Every Morning (Automatically)\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation delivers a single, child-focused morning briefing to your phone: it fetches today’s daycare menu from a webpage, reads your family schedule from Google Sheets, adds an Open-Meteo weather summary, and sends everything via WhatsApp using CallMeBot—every day at \u003cstrong\u003e07:00\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 daily at 07:00\u003c\/strong\u003e and calculates today’s date in your configured timezone, then stops if a message was already successfully sent for the same date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOn weekdays\u003c\/strong\u003e, downloads the daycare menu webpage, extracts the text around today’s date, and uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to return today’s meals as \u003cstrong\u003estrict JSON\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates Gemini output\u003c\/strong\u003e by confirming the “date text seen” exists in the original page content; if verification fails, the menu is reported as \u003cstrong\u003eunavailable\u003c\/strong\u003e instead of guessing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your schedule from Google Sheets\u003c\/strong\u003e (tab named \u003cstrong\u003eschedule\u003c\/strong\u003e) and selects recurring and date-specific items that match today.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches an hourly forecast\u003c\/strong\u003e from \u003cstrong\u003eOpen-Meteo\u003c\/strong\u003e using your coordinates and converts it into a deterministic, child-oriented weather summary with clothing advice.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends one consolidated WhatsApp message\u003c\/strong\u003e via \u003cstrong\u003eCallMeBot\u003c\/strong\u003e. On weekends, it skips daycare menu details as described.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRetries safely\u003c\/strong\u003e: today is marked as sent only after the WhatsApp API indicates the message was queued\/sent.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eParents who need a reliable \u003cstrong\u003edaycare daily menu\u003c\/strong\u003e and quick \u003cstrong\u003eweather + clothing\u003c\/strong\u003e guidance without checking multiple apps.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers setting up a production-ready \u003cstrong\u003en8n WhatsApp notification workflow\u003c\/strong\u003e with validation and retry behavior.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators demonstrating dependable integrations: Gemini extraction + Open-Meteo forecasting + Google Sheets scheduling.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduler:\u003c\/strong\u003e daily trigger at 07:00 (timezone-aware)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/logic:\u003c\/strong\u003e if, set, code, sticky note, http request, google sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Gemini (API key), Google Sheets (OAuth2), Open-Meteo (forecast), CallMeBot WhatsApp API (HTTP Query Auth credential)\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup includes\u003c\/strong\u003e credentials for Google Gemini, Google Sheets, and CallMeBot so the workflow can fetch, extract, verify, summarize, and send the briefing automatically.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46086659571891,"sku":"N8N-19904","price":6.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/PuwJwaN7vqA1FHV6Lf4_HJeyIZgh.png?v=1790327441","url":"https:\/\/buyflowscripts.com\/products\/automated-daily-daycare-menu-weather-briefing-via-whatsapp","provider":"N8N Commerce","version":"1.0","type":"link"}