Automated COVID Data Import from URL to Google Sheets

This workflow automates the process of fetching COVID-19 testing data from an external CSV source, filtering for specific regions and year, and importing the cleaned data into a Google Sheet. It starts with a manual trigger to initiate the process. The workflow downloads CSV data via an HTTP request, filters data to include only entries from Germany, Austria, and Switzerland for the year 2023, and adds a unique key by combining country code and week. The filtered data is then appended or updated in a designated Google Sheets document, facilitating ongoing data analysis or reporting. This setup is ideal for maintaining up-to-date regional COVID-19 data for dashboards, reports, or further processing within Google Sheets.