{"product_id":"open-meteo-weather-archive-to-n8n-data-table-daily-etl","title":"Open-Meteo Weather Archive to n8n Data Table (Daily ETL)","description":"\u003ch3\u003eAutomate daily weather history updates from Open-Meteo into an n8n Data Table\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls the last 10 days of daily weather metrics from the Open-Meteo Archive API for multiple cities every day at \u003cstrong\u003e6:00 AM\u003c\/strong\u003e, then \u003cstrong\u003eupserts\u003c\/strong\u003e the results into an \u003cstrong\u003en8n Data Table\u003c\/strong\u003e so you avoid duplicates.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule\u003c\/strong\u003e — the Schedule Trigger starts the job daily at \u003cstrong\u003e6:00 AM\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds an Open-Meteo Archive API request\u003c\/strong\u003e — using configured city latitude\/longitude plus a rolling \u003cstrong\u003e10-day date range\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches daily weather metrics\u003c\/strong\u003e — temperature, precipitation, snowfall, and wind speed from Open-Meteo’s archive data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTransforms the response\u003c\/strong\u003e — creates \u003cstrong\u003eone record per city per day\u003c\/strong\u003e with normalized numeric fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts into an n8n Data Table\u003c\/strong\u003e — inserts or updates records using \u003cstrong\u003ecity + date\u003c\/strong\u003e as the deduplication keys.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS operators\u003c\/strong\u003e who need fresh daily weather history for dashboards or reports without manual imports.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e building ETL pipelines that require reliable upserts (dedupe by \u003cem\u003ecity\u003c\/em\u003e and \u003cem\u003edate\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData teams\u003c\/strong\u003e storing long-term weather metrics in an n8n Data Table for downstream analytics workflows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow cadence:\u003c\/strong\u003e daily at 6:00 AM via \u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used:\u003c\/strong\u003e \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, \u003cstrong\u003eCode\u003c\/strong\u003e, \u003cstrong\u003eData Table\u003c\/strong\u003e, \u003cstrong\u003eSticky Note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAPI credentials:\u003c\/strong\u003e no external API key required.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePlatform requirement:\u003c\/strong\u003e n8n instance with \u003cstrong\u003eData Tables support\u003c\/strong\u003e (n8n Cloud or self-hosted \u003cstrong\u003ev1.60+\u003c\/strong\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup \u0026amp; customization\u003c\/h3\u003e\n\u003cp\u003eCreate an n8n Data Table (e.g., \u003ccode\u003eweather_daily\u003c\/code\u003e) with columns for \u003cstrong\u003edate\u003c\/strong\u003e, \u003cstrong\u003ecity\u003c\/strong\u003e, and the weather metrics you want to store. In the Data Table upsert step, match filters on both \u003cstrong\u003edate\u003c\/strong\u003e and \u003cstrong\u003ecity\u003c\/strong\u003e. Update your city list and coordinates, then activate the workflow to run daily.\u003c\/p\u003e\n\u003cp\u003eYou can also adjust the CITIES array, change the cron time, and add additional metrics based on the Open-Meteo API documentation.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46066368872627,"sku":"N8N-19737","price":16.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Konj582vV9Mk48jmNRkQZ_hecdcSik.png?v=1789895316","url":"https:\/\/buyflowscripts.com\/products\/open-meteo-weather-archive-to-n8n-data-table-daily-etl","provider":"N8N Commerce","version":"1.0","type":"link"}