Daily weather reports with OpenWeather API, Google Sheets, and Gmail

Daily Weather Reports with OpenWeather API, Google Sheets, and Gmail

This workflow fetches real-time weather data from the OpenWeather API, stores it in a Google Sheet, formats it into a beautifully styled HTML report and emails it to recipients automatically every day at 10:00 AM. It helps teams track and monitor daily weather trends and optionally correlate them with energy production or field operations.

Who’s it for?

Renewable energy teams monitoring solar/wind energy output vs weather Facility or operations managers requiring daily climate updates Researchers or analysts logging environmental metrics Any team needing automated, daily weather reports by email

How it works?

The workflow begins with a Schedule Trigger set to run at 10:00 AM IST daily. It calls the OpenWeather API to fetch weather metrics for a predefined location. The data is then passed to a Google Sheets node named "Append Weather to Sheet", which stores all the key values into a structured spreadsheet. A Set or Function node generates a clean, styled HTML email using inline CSS and the weather values. Finally, a Gmail node sends this report to one or more recipients with a clear subject line and formatted body.

How to set up?

1. Create/Open your n8n instance (Cloud or Self-hosted). 2. Connect the following credentials: Google Sheets (OAuth2) Gmail (OAuth2) 3. Set your OpenWeather API key in the HTTP Request node (api.openweathermap.org). 4. Replace latitude/longitude in the request URL as per your location. 5. Link a Google Sheet and define the correct tab name and headers. 6. Configure recipient email(s) in the Gmail node. 7. Deploy the workflow and test.