Daily weather reports with OpenWeather API, Google Sheets, and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 5 nodes and runs on a schedule (every day at 10:00). Along the way it connects Google Sheets and Gmail. It also calls api.openweathermap.org over HTTP.
How it runs
Trigger: On a schedule (every day at 10:00).
- Fetch Weather from OpenWeather (HTTP Request): calls api.openweathermap.org
- Append Weather to Sheet (Google Sheets): append or update
- Generate Weather Email HTML (HTML): parses or builds HTML
- Send Weather Update Email (Gmail): uses Gmail
Services it uses
HTTP calls to: api.openweathermap.org
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (5)
- HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - HTML
n8n-nodes-base.html - Gmail
n8n-nodes-base.gmail - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
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…