Store Weather Requests & Send City Weather SMS via Twilio

This n8n workflow automates weather information delivery by SMS for any city. It starts with a secure webhook endpoint that accepts POST requests containing the user's name, phone number, and desired city. The data is immediately extracted and stored in an Airtable base for record-keeping and future reference, ensuring all requests are logged without manual intervention.

Next, it queries the OpenWeatherMap API to retrieve real-time weather data, including temperature, humidity, wind speed, and description for the specified city. This data is then formatted into a concise, user-friendly message and dispatched via Twilio SMS directly to the provided phone number, delivering instant updates like 'The weather in London, UK is 22℃ with clear sky. Humidity is 65% and windspeed is 3.6 m/s.'

Ideal for travel agencies, personal assistants, or apps needing on-demand weather alerts, this workflow saves time on manual lookups and messaging. Benefits include seamless integration of storage, API data fetching, and communication; scalability for high-volume requests; and easy customization for additional fields or weather details. It's perfect for enterprise travel workflows, customer support, or IoT weather stations, reducing operational costs and enhancing user experience with reliable automation.