Import CSV from URL to Google Sheets
Ready for 3.0What this workflow does
This workflow has 6 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls opendata.ecdc.europa.eu over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Download CSV (HTTP Request): calls opendata.ecdc.europa.eu
- Import CSV (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
- Add unique field (Edit Fields (Set)): sets or maps fields
- Keep only DACH in (Filter): keeps only the items that match a condition
- Upload to spreadsheet (Google Sheets): append or update
Services it uses
HTTP calls to: opendata.ecdc.europa.eu
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.
- Still check Spreadsheet File (Import CSV): Convert to File / Extract from File.
Nodes used (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Spreadsheet File
n8n-nodes-base.spreadsheetFile - HTTP Request
n8n-nodes-base.httpRequest - Filter
n8n-nodes-base.filter
From the author
This workflow automatically imports data from a CSV file located at a specific URL and then updates the Google Sheets document with the provided data. Below is a step-by-step description of what this workflow does: 1. The workflow is started manually using…