Import CSV from URL to GoogleSheet
For Google Sheets, this workflow automates the import of CSV data from a URL, filtering for DACH countries in 2023. It appends or updates the data in a spreadsheet, ensuring unique entries while streamlining the data management process. This saves time and enhances data accuracy, making it easier to track COVID-19 testing statistics.
View Large Image
Workflow Overview
For Google Sheets, this workflow automates the import of CSV data from a URL, filtering for DACH countries in 2023. It appends or updates the data in a spreadsheet, ensuring unique entries while streamlining the data management process. This saves time and enhances data accuracy, making it easier to track COVID-19 testing statistics.
- Data Analysts: Individuals who analyze COVID-19 testing data and need to import it into Google Sheets for further analysis.
- Public Health Officials: Professionals who require up-to-date testing data for monitoring COVID-19 trends in specific regions.
- Researchers: Academics or scientists studying the impact of testing on COVID-19 spread, especially in DACH countries (Germany, Austria, Switzerland).
- Business Intelligence Professionals: Those needing to visualize and report on testing data for decision-making purposes.
This workflow automates the process of importing COVID-19 testing data from a CSV file available at a URL into Google Sheets. It specifically filters the data to focus on the DACH region (Germany, Austria, Switzerland) for the year 2023, thereby saving time and effort in manual data handling. The workflow also ensures that unique entries are created for each record, preventing data duplication.
- Manual Trigger: The workflow starts when the user clicks the "Execute Workflow" button.
- Download CSV: It fetches the latest COVID-19 testing data from the specified URL: https://opendata.ecdc.europa.eu/covid19/testing/csv/data.csv.
- Import CSV: The downloaded CSV file is imported, with the first row treated as headers.
- Add Unique Field: A unique key is generated for each record based on the country_code and year_week. This key helps in identifying records uniquely.
- Filter Data: The workflow filters the records to include only those from the DACH region for the year 2023, ensuring relevance and specificity.
- Upload to Spreadsheet: Finally, the filtered data is appended or updated in the specified Google Sheet, allowing for easy access and analysis.