n8n templatesn8n templates

Import CSV from URL to Google Sheet

This workflow is designed to automate the processing of pandemic-related data. It can download CSV files from a specified URL, filter out the pandemic testing data for the DACH region (Germany, Austria, Switzerland) in 2023, and intelligently import it into Google Sheets. By automatically triggering matches with unique data keys, it significantly reduces the manual work of downloading and organizing data, enhancing the speed and accuracy of data updates. It is suitable for use by public health monitoring, research institutions, and data analysts.

Workflow Diagram
Import CSV from URL to Google Sheet Workflow diagram

Workflow Name

Import CSV from URL to Google Sheet

Key Features and Highlights

This workflow automates the process of downloading a CSV file from a specified URL, parsing the data, filtering COVID-19 testing data for the DACH region (Germany, Austria, Switzerland) in 2023, and intelligently importing the processed data into a Google Sheets spreadsheet. Its highlights lie in the seamless integration of automated data download, filtering, and cloud-based data updating, significantly simplifying the data maintenance workflow.

Core Problems Addressed

Manually downloading, organizing, and uploading CSV-format pandemic data is time-consuming and prone to errors. This workflow executes automatically upon trigger, supports unique key matching to prevent duplicate entries, and solves issues related to data synchronization difficulties, slow updates, and insufficient accuracy.

Application Scenarios

  • Public health data monitoring and analysis
  • Research institutions and government agencies requiring regular updates of pandemic testing data
  • Data analysts and report creators seeking automated data aggregation and cloud sharing
  • Enterprises or organizations conducting regional pandemic tracking and decision support

Main Process Steps

  1. Manually trigger the workflow to start execution
  2. Automatically download COVID-19 testing data in CSV format from the European Centre for Disease Prevention and Control (ECDC) via HTTP request
  3. Import the CSV data and add a unique identifier field to each record (country code + year-week number)
  4. Filter data related to the DACH region (Germany, Austria, Switzerland) for the year 2023
  5. Append or update the filtered data into a specified Google Sheets spreadsheet using the Google Sheets API

Involved Systems or Services

  • HTTP Request Node: used to download the CSV file from the specified URL
  • CSV Parsing Node: parses the downloaded CSV data
  • Data Filtering Node: filters data by specific time period and region
  • Google Sheets Node: uploads and updates data via the Google Sheets API
  • Manual Trigger Node: controls the timing of workflow execution

Target Users and Value

  • Data analysts and public health experts: quickly access and manage the latest pandemic data, improving data processing efficiency
  • Research institutions and government agencies: automate aggregation of regional pandemic information to support decision-making
  • Users who regularly maintain and update pandemic-related reports: reduce repetitive work and ensure data accuracy and timeliness
  • Automation enthusiasts and technical personnel: demonstrate how to combine HTTP requests and Google Sheets for automated data workflows

In summary, this workflow is an efficient solution for automatic downloading, filtering, and cloud synchronization of pandemic data, greatly enhancing the automation and intelligence of data processing. It is well-suited for various business scenarios requiring real-time data updates and sharing.