Library / Alerts & Notifications
Alerts & Notifications
Prepare store weather alerts from Open-Meteo with Claude drafts to Slack
Runs every afternoon, reads store locations from Google Sheets, checks Open-Meteo forecasts for rain, heat or cold, has Claude draft staff prep lists and customer messages verified by code, then posts one Slack message per store.
What it does
## Rain, heat or cold ahead? Tell each store in time Every afternoon the workflow reads the free Open-Meteo forecast (no key) for each store in your Stores tab. Code flags the days with rain, heavy rain, heat or cold, using your limits. For the flagged stores, Claude writes a short prep list for the staff and a draft message for customers, and code checks both: every temperature, probability, amount and date must be in the forecast, the customer draft must fit your length and avoid your banned words. Slack gets one message per store. ### How it works 1. Read the stores (name, lat, lon, notes, contact). A wrong coordinate stops the run with a clear message. 2. One forecast request per store (default 3 days). Code turns the flagged days into numbered facts. 3. Claude writes with the fact ids it used; checks mark anything that fails with a warning. ### Setup 1. Blank Google Sheet: paste its ID in Spreadsheet ID, run Run once, select the sheet in the Google Sheets node. 2. Fill the Stores tab (right-click a place in Google Maps to copy lat and lon). 3. Credentials: Google Sheets, Anthropic, Slack (pick a channel). 4. Set the limits, language, time zone and banned words in Config. Publish. ### Note Forecasts can be wrong. Read the customer draft before you send it.
The steps
- Every day at 15:00
- Run now
- Config
- Read Stores tab
- Check the stores
- Get forecast (Open-Meteo)
- Find weather events
- AI: Write prep and message
- Check the texts
- Post to Slack
- Run once: set up the sheet
- Add the Stores tab
- Write the header row
- Spreadsheet ID
Similar automations
AI Agents & AssistantsWeather Forecast Chat Agent with OpenAI and Open-Meteo27 stepsAI Agents & AssistantsAnswer Weather Questions with OpenAI and Open-Meteo6 stepsMonitoring, Ops & IncidentsWrite multilingual weather articles with Open-Meteo, Claude, and OpenAI57 stepsMonitoring, Ops & IncidentsDiagnose solar production losses with SolarEdge, Open-Meteo, Gemini, Postgres, Jira and21 steps