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.

7/8/2025
7 nodes
Simple
manualsimplegooglesheetsspreadsheetfilefiltersticky notefilesstorageapiintegration
Categories:
Manual TriggeredSimple WorkflowData Processing & Analysis
Integrations:
GoogleSheetsSpreadsheetFileFilterSticky Note

Target Audience

  • 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.

    • Problem Solved

    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.

    Workflow Steps

  • 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.

    • Customization Guide

  • Change Data Source: Users can modify the URL in the Download CSV node to pull data from a different source.
    - Adjust Filters: The conditions in the Keep only DACH in 2023 node can be altered to include different countries or years as needed.
    - Modify Spreadsheet Settings: Users can change the sheetName and documentId in the Upload to spreadsheet node to direct the output to a different Google Sheet.
    - Add More Fields: Additional fields can be included in the Add unique field node by modifying the JSON structure to accommodate more data points if required.