WeblineIndia This workflow corresponds to n8n.io template #6738 — we link there as the canonical source.
This workflow follows the Gmail → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "ONGqVR4QHDYAI40u",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Daily Weather Reports with OpenWeather API, Google Sheets, and Gmail",
"tags": [],
"nodes": [
{
"id": "5d9003c3-5608-4dc5-8b0b-ba712c0799d4",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
340,
40
],
"parameters": {
"width": 1220,
"height": 260,
"content": "## Daily Weather Reports with OpenWeather API, Google Sheets, and Gmail"
},
"typeVersion": 1
},
{
"id": "0842de03-5376-4161-9581-25982d90467c",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
340,
320
],
"parameters": {
"width": 1220,
"height": 400,
"content": "## Node Breakdown & Descriptions:\n- The workflow starts with a Schedule Trigger node named \"Trigger Daily at 10 AM\", which runs every day at 10:00 AM IST to initiate the weather reporting process.\n\n- The next node, named \"Fetch Weather from OpenWeather\", is an HTTP Request node that fetches the latest weather data from the OpenWeather API using coordinates, API key, and metric units.\n\n- The workflow then proceeds to a Google Sheets node named \"Append Weather to Sheet\", which appends the fetched weather data into a predefined Google Sheet. The stored fields include: Country, Location Latitude, Location Longitude, Temperature (\u00b0C), Feels Like (\u00b0C), Min Temp (\u00b0C), Max Temp (\u00b0C), Humidity (%), Pressure (hPa), Sea Level (hPa), Ground Level (hPa), Visibility (m), Wind Speed (m/s), Wind Direction (\u00b0), Wind Gust (m/s), Cloudiness (%), Sunrise (UTC) (stored as UNIX timestamp or formatted date), Sunset (UTC) (stored as UNIX timestamp or formatted date),Date Time (UTC) (report generated time, in UNIX or formatted UTC), Each row in the sheet represents a daily weather snapshot with all key climate indicators.\n\n- After storing the data, the workflow uses a Set or Function node named \"Generate Weather Email HTML\", which creates a styled HTML email template by formatting the weather data into a visually readable format.\n\n- Finally, the Gmail node named \"Send Weather Update Email\" sends the formatted weather report to a predefined email list, with a subject line like \u201cDaily Weather Report \u2013 {{ $now.toFormat('dd MMM yyyy') }}\u201d and the generated HTML as the message body."
},
"typeVersion": 1
},
{
"id": "babd8c14-906e-498d-a35c-5637e1378ce0",
"name": "Fetch Weather from OpenWeather",
"type": "n8n-nodes-base.httpRequest",
"notes": "Fetching the weather data",
"position": [
660,
120
],
"parameters": {
"url": "https://api.openweathermap.org/data/2.5/weather?",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpQueryAuth",
"queryParameters": {
"parameters": [
{
"name": "lon",
"value": ""
},
{
"name": "lat",
"value": ""
}
]
}
},
"credentials": {
"httpQueryAuth": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 4.2
},
{
"id": "fdddcafa-d579-4d13-b624-80c66d02d78c",
"name": "Append Weather to Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
880,
120
],
"parameters": {
"columns": {
"value": {
"Country": "={{ $json.sys.country }}",
"Location": "={{ $json.coord }}",
"Humidity (%)": "={{ $json.main.humidity }}",
"Sunset (UTC)": "={{ $json.sys.sunset }}",
"Sunrise (UTC)": "={{ $json.sys.sunrise }}",
"Cloudiness (%)": "={{ $json.clouds.all }}",
"Max Temp (\u00b0C)": "={{ $json.main.temp_max }}",
"Min Temp (\u00b0C)": "={{ $json.main.temp_min }}",
"Pressure (hPa)": "={{ $json.main.pressure }}",
"Visibility (m)": "={{ $json.visibility }}",
"Date Time (UTC)": "={{ $json.dt }}",
"Sea Level (hPa)": "={{ $json.main.sea_level }}",
"Wind Gust (m/s)": "={{ $json.wind.gust }}",
"Feels Like (\u00b0C)": "={{ $json.main.feels_like }}",
"Wind Speed (m/s)": "={{ $json.wind.speed }}",
"Temperature (\u00b0C)": "={{ $json.main.temp }}",
"Ground Level (hPa)": "={{ $json.main.grnd_level }}",
"Wind Direction (\u00b0)": "={{ $json.wind.deg }}"
},
"schema": [
{
"id": "Location",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Temperature (\u00b0C)",
"type": "string",
"display": true,
"required": false,
"displayName": "Temperature (\u00b0C)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Feels Like (\u00b0C)",
"type": "string",
"display": true,
"required": false,
"displayName": "Feels Like (\u00b0C)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Min Temp (\u00b0C)",
"type": "string",
"display": true,
"required": false,
"displayName": "Min Temp (\u00b0C)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Max Temp (\u00b0C)",
"type": "string",
"display": true,
"required": false,
"displayName": "Max Temp (\u00b0C)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Humidity (%)",
"type": "string",
"display": true,
"required": false,
"displayName": "Humidity (%)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Pressure (hPa)",
"type": "string",
"display": true,
"required": false,
"displayName": "Pressure (hPa)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Sea Level (hPa)",
"type": "string",
"display": true,
"required": false,
"displayName": "Sea Level (hPa)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Ground Level (hPa)",
"type": "string",
"display": true,
"required": false,
"displayName": "Ground Level (hPa)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Visibility (m)",
"type": "string",
"display": true,
"required": false,
"displayName": "Visibility (m)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Wind Speed (m/s)",
"type": "string",
"display": true,
"required": false,
"displayName": "Wind Speed (m/s)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Wind Direction (\u00b0)",
"type": "string",
"display": true,
"required": false,
"displayName": "Wind Direction (\u00b0)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Wind Gust (m/s)",
"type": "string",
"display": true,
"required": false,
"displayName": "Wind Gust (m/s)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Cloudiness (%)",
"type": "string",
"display": true,
"required": false,
"displayName": "Cloudiness (%)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Sunrise (UTC)",
"type": "string",
"display": true,
"required": false,
"displayName": "Sunrise (UTC)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Sunset (UTC)",
"type": "string",
"display": true,
"required": false,
"displayName": "Sunset (UTC)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date Time (UTC)",
"type": "string",
"display": true,
"required": false,
"displayName": "Date Time (UTC)",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Location"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 380635808,
"cachedResultUrl": "",
"cachedResultName": "weather_data"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1cQ-TBf3-dqo7njDYzYpxpASYFvEp8lIzH7vpIqTLcwc",
"cachedResultUrl": "",
"cachedResultName": ""
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "d9eb272f-4c1e-42dc-a297-05d0a0848358",
"name": "Generate Weather Email HTML",
"type": "n8n-nodes-base.html",
"position": [
1120,
120
],
"parameters": {
"html": "<!DOCTYPE html>\n<html>\n<head>\n <meta charset=\"UTF-8\" />\n <title>Daily Weather Report</title>\n <style>\n .container {\n background-color: #ffffff;\n text-align: center;\n padding: 24px;\n border-radius: 12px;\n font-family: Arial, sans-serif;\n max-width: 650px;\n margin: auto;\n box-shadow: 0 2px 8px rgba(0, 0, 0, 0.1);\n }\n\n h1 {\n color: #ff6d5a;\n font-size: 24px;\n font-weight: bold;\n padding: 8px;\n margin-bottom: 0;\n }\n\n table {\n width: 100%;\n border-collapse: collapse;\n margin-top: 20px;\n }\n\n td {\n padding: 10px;\n text-align: left;\n border-bottom: 1px solid #eee;\n }\n\n td:first-child {\n font-weight: bold;\n color: #555;\n width: 40%;\n }\n\n p.footer {\n font-size: 13px;\n color: #999;\n margin-top: 24px;\n }\n </style>\n</head>\n<body>\n <div class=\"container\">\n <h1>\ud83c\udf24\ufe0f Weather Report</h1>\n\n <table>\n <tr>\n <td>\ud83d\udccc Coordinates</td>\n <td>Lat: {{ $json[\"Location\"]?.lat }}, Lon: {{ $json[\"Location\"]?.lon }}</td>\n </tr>\n <tr>\n <td>\ud83c\udf21\ufe0f Temperature</td>\n <td>{{ $json[\"Temperature (\u00b0C)\"] }} \u00b0C (Feels like {{ $json[\"Feels Like (\u00b0C)\"] }} \u00b0C)</td>\n </tr>\n <tr>\n <td>\ud83d\udcc9 Min / Max Temp</td>\n <td>{{ $json[\"Min Temp (\u00b0C)\"] }} \u00b0C / {{ $json[\"Max Temp (\u00b0C)\"] }} \u00b0C</td>\n </tr>\n <tr>\n <td>\ud83d\udca7 Humidity</td>\n <td>{{ $json[\"Humidity (%)\"] }}%</td>\n </tr>\n <tr>\n <td>\ud83d\udcc8 Pressure</td>\n <td>{{ $json[\"Pressure (hPa)\"] }} hPa (Sea: {{ $json[\"Sea Level (hPa)\"] }} hPa, Ground: {{ $json[\"Ground Level (hPa)\"] }} hPa)</td>\n </tr>\n <tr>\n <td>\ud83d\udc41\ufe0f Visibility</td>\n <td>{{ $json[\"Visibility (m)\"] }} meters</td>\n </tr>\n <tr>\n <td>\ud83e\udded Wind</td>\n <td>\n Speed: {{ $json[\"Wind Speed (m/s)\"] }} m/s<br/>\n Direction: {{ $json[\"Wind Direction (\u00b0)\"] }}\u00b0<br/>\n Gust: {{ $json[\"Wind Gust (m/s)\"] }} m/s\n </td>\n </tr>\n <tr>\n <td>\u2601\ufe0f Cloudiness</td>\n <td>{{ $json[\"Cloudiness (%)\"] }}%</td>\n </tr>\n <tr>\n <td>\ud83c\udf05 Sunrise (UTC)</td>\n <td>{{ new Date($json[\"Sunrise (UTC)\"] * 1000).toUTCString() }}</td>\n </tr>\n <tr>\n <td>\ud83c\udf07 Sunset (UTC)</td>\n <td>{{ new Date($json[\"Sunset (UTC)\"] * 1000).toUTCString() }}</td>\n </tr>\n <tr>\n <td>\ud83d\udcc6 Report Time (UTC)</td>\n <td>{{ new Date($json[\"Date Time (UTC)\"] * 1000).toUTCString() }}</td>\n </tr>\n </table>\n\n <p class=\"footer\">\u26c5 Auto-generated by n8n | {{ new Date().toUTCString() }}</p>\n </div>\n</body>\n</html>\n"
},
"typeVersion": 1.2
},
{
"id": "cced121e-190b-4026-aeea-54e32907af0d",
"name": "Send Weather Update Email",
"type": "n8n-nodes-base.gmail",
"position": [
1360,
120
],
"parameters": {
"sendTo": "",
"message": "={{ $json.html }}",
"options": {},
"subject": "Daily Weather Update"
},
"credentials": {
"gmailOAuth2": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "7e0b458d-540e-479b-acd0-708cb9a888ec",
"name": "Trigger Daily at 10 AM",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
440,
120
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 10
}
]
}
},
"typeVersion": 1.2
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "74976aa3-0dba-4e9a-a442-cf715fc38807",
"connections": {
"Trigger Daily at 10 AM": {
"main": [
[
{
"node": "Fetch Weather from OpenWeather",
"type": "main",
"index": 0
}
]
]
},
"Append Weather to Sheet": {
"main": [
[
{
"node": "Generate Weather Email HTML",
"type": "main",
"index": 0
}
]
]
},
"Generate Weather Email HTML": {
"main": [
[
{
"node": "Send Weather Update Email",
"type": "main",
"index": 0
}
]
]
},
"Fetch Weather from OpenWeather": {
"main": [
[
{
"node": "Append Weather to Sheet",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
gmailOAuth2googleSheetsOAuth2ApihttpQueryAuth
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
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…
Source: https://n8n.io/workflows/6738/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
YOUR_ID 4. Uses gmail, googleDrive, googleSheets, httpRequest. Scheduled trigger; 53 nodes.
Gmail, Google Drive, Google Sheets +1
Looking for a way to track GitHub bounty issues automatically and get notified in real time? This GitHub Bounty Tracker workflow monitors repositories for issues labeled 💎 Bounty, logs them in Google
Google Sheets, HTTP Request, WhatsApp +1
This workflow automatically sends a beautifully designed HTML newsletter every Sunday at 8 AM, featuring products currently on sale from your Algolia-powered e-commerce store.
Google Sheets, HTTP Request, Gmail
This n8n template demonstrates how to build a Auto Lead Gen & Outreach System for Local Businesses specifically designed to help businesses that don’t have a website yet.
Google Sheets, HTTP Request, Google Drive +1
I created this workflow with care for marketing professionals and agencies who manage multiple Meta Ads (Facebook) accounts and want to track ad account balances automatically — no more logging in eve
HTTP Request, Google Sheets, Gmail