Developed as an internal initiative by Toolshed, the project needed to continuously monitor weather conditions across multiple cities without requiring manual checks. The challenge was to create a reliable scheduled workflow automation that could retrieve live weather data, process multiple cities, maintain historical records, and automatically notify stakeholders when temperatures exceeded a defined threshold.

To build an automated weather monitoring and alert workflow using BuildShip, Supabase, and the OpenWeatherMap API. The objective was to automate scheduled weather data collection, store historical readings for analysis, and trigger real-time email alerts when predefined temperature thresholds were exceeded.

BuildShip Workflow Automation: Built the complete automated workflow in BuildShip, using scheduled execution, API calls, conditional logic, loops, and email notifications to create an unattended weather monitoring system.

Scheduled Automation: Configured an hourly scheduled workflow to automatically refresh weather data and evaluate temperature conditions without manual intervention.

Supabase Data Integration: Connected Supabase to retrieve active cities and store historical weather readings in a structured weather logs table for ongoing monitoring and trend analysis.

OpenWeatherMap API Integration: Integrated the OpenWeatherMap API to fetch live weather information including temperature, humidity, and current conditions for each monitored city.

Multi-City API Automation: Implemented loop-based processing to automatically retrieve and evaluate weather data for multiple active cities within a single workflow.

Conditional Alert Automation: Built threshold-based workflow logic that evaluates temperature data and automatically triggers an email alert when predefined conditions are met.

Automated Email Notifications: Configured automated email notifications containing the relevant city and temperature information, ensuring stakeholders are alerted without manually monitoring weather conditions.

Historical Data Logging: Automated the storage of weather readings in Supabase, creating a historical dataset that can support auditing, monitoring, and future trend analysis.

The BuildShip workflow automation provides continuous, unattended weather monitoring across a configurable set of cities. By integrating Supabase, the OpenWeatherMap API, scheduled automation, conditional logic, and automated email alerts, the workflow eliminates manual weather checks while maintaining a historical record of weather conditions for ongoing analysis.