Import COVID CSV from URL to Filtered Google Sheets - n8n Workflow | Neura Market
Import COVID CSV from URL to Filtered Google Sheets
Automates fetching CSV data from a URL, filters for DACH countries (DE, AT, CH) in 2023, generates unique keys, and appends/updates Google Sheets.
This n8n workflow streamlines the import of CSV data from a public URL (e.g., ECDC COVID-19 testing data) directly into Google Sheets. It starts with a manual trigger, downloads the CSV via HTTP, parses it into JSON, adds a unique key from country_code and year_week, filters to only DACH region (Germany, Austria, Switzerland) data for 2023 to respect API limits, and finally appends or updates the specified Google Sheet using the unique key for matching.
Benefits include significant time savings
Platform
n8n
Category
Lifestyle
Price
$12.99
Creator
Fred Garcia
google-sheets
csv-import
data-filtering
covid-data
dach-countries
automation
productivity
open-data
json-parsing
append-update
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.