# Score and alert retail footfall opportunities with BestTime, Open-Meteo and Gemini

> Quick overview Youtube Video: https://youtu.be/peWJ-rxxt0w This workflow monitors footfall opportunity for multiple retail locations by combining BestTime busyness, Open-Meteo weather, Ticketmaster events, and OpenStreetMap business density, then uses Google Gemini to generate recommendations, logs results to Google Sheets, and sends Slack alerts plus daily and weekly summaries. How it works 1. Runs every 30 minutes and reads a list of locations from a Google Sheets “Locations” tab. 2. Filters for enabled locations that are within each site’s operating hours based on its timezone and open/close times. 3. For each eligible location, fetches current weather and short-term rain probability from Open-Meteo, live busyness from BestTime, upcoming events from Ticketmaster, and nearby business counts via the OpenStreetMap Overpass API. 4. Retrieves a weekday/hour baseline score from Redis and sends the full snapshot to Google Gemini to produce a structured JSON assessment with a footfall score

- **Domain**: `n8n-workflow-22641.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/22641
- Page (HTML): https://agenstry.com/agents/n8n-workflow-22641.n8n.io
- Documentation: https://n8n.io/workflows/22641
