Open-Meteo Weather Archive to n8n Data Table (Daily ETL)

Automate daily weather history updates from Open-Meteo into an n8n Data Table

This n8n workflow pulls the last 10 days of daily weather metrics from the Open-Meteo Archive API for multiple cities every day at 6:00 AM, then upserts the results into an n8n Data Table so you avoid duplicates.

What this workflow does

• Runs on a schedule — the Schedule Trigger starts the job daily at 6:00 AM.
• Builds an Open-Meteo Archive API request — using configured city latitude/longitude plus a rolling 10-day date range.
• Fetches daily weather metrics — temperature, precipitation, snowfall, and wind speed from Open-Meteo’s archive data.
• Transforms the response — creates one record per city per day with normalized numeric fields.
• Upserts into an n8n Data Table — inserts or updates records using city + date as the deduplication keys.

Use cases

• SaaS operators who need fresh daily weather history for dashboards or reports without manual imports.
• Automation engineers building ETL pipelines that require reliable upserts (dedupe by city and date).
• Data teams storing long-term weather metrics in an n8n Data Table for downstream analytics workflows.

Technical details

• Workflow cadence: daily at 6:00 AM via Schedule Trigger.
• Nodes used: HTTP Request, Code, Data Table, Sticky Note.
• API credentials: no external API key required.
• Platform requirement: n8n instance with Data Tables support (n8n Cloud or self-hosted v1.60+).

Setup & customization

Create an n8n Data Table (e.g., weather_daily) with columns for date, city, and the weather metrics you want to store. In the Data Table upsert step, match filters on both date and city. Update your city list and coordinates, then activate the workflow to run daily.

You can also adjust the CITIES array, change the cron time, and add additional metrics based on the Open-Meteo API documentation.