This n8n workflow facilitates the automation of importing COVID-19 testing data into a Google Sheets document, specifically focusing on the DACH region (Germany, Austria, Switzerland) for the year 2023. The workflow begins with a manual trigger, allowing users to execute the process on demand.
First, it downloads a CSV dataset from the European CDC website containing COVID testing data. The CSV file is then imported into n8n for processing. A new unique key is created by concatenating the country code and the year-week, ensuring each row can be uniquely identified. The dataset is filtered to retain only entries from Germany, Austria, and Switzerland for the year 2023.
Finally, the refined data is appended or updated in a specific sheet within a Google Sheets document, creating an organized and up-to-date regional COVID-19 report. A sticky note node provides a reminder about API rate limits, suggesting batching for larger datasets if needed.
This workflow is particularly useful for public health officials, data analysts, or researchers who need to automate the regular update of regional COVID statistics in a centralized spreadsheet, ensuring data consistency and saving manual effort.
Reviews
There are no reviews yet.