Import COVID CSV from URL to Filtered 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 on manual data imports, error-free parsing and filtering, and easy customization for other URLs or filters. It's ideal for analysts tracking public health data, news aggregators, or anyone needing automated spreadsheet updates without coding.

Use cases: Daily COVID stats reporting for European markets, adapting for other open data sources like weather or finance CSVs, or building dashboards in Sheets for business intelligence. Handles large datasets efficiently by pre-filtering, avoiding Google API rate limits.