Latenode
HTTP Request
Google sheets

Automatically sync public CSV data to a designated Google Sheets tab

This Latenode automation simplifies the process of importing data from a public CSV file and populating a designated Google Sheets tab.

The workflow automatically downloads the CSV file from a specified URL, extracts and filters the relevant data (focusing on COVID-19 testing metrics for Germany, Austria, and Switzerland in 2023), and then uploads the organized information directly to the target Google Sheets document. This solution streamlines the data integration process, allowing users to easily centralize and analyze important information from external sources within their existing spreadsheet infrastructure.

Updated Apr 6, 2026Est. run: 26sEst. cost: $0.0703
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
Data, spreadsheets & databases

Workflow preview

What this template does

  • Downloads CSV data from a public URL
  • Extracts relevant COVID-19 testing metrics for Germany, Austria, and Switzerland in 2023
  • Filters and normalizes the data
  • Uploads the organized information to a designated Google Sheets tab
  • Provides a centralized data source for analysis within an existing spreadsheet infrastructure

How it works

1
Trigger

Manually start workflow

The user manually initiates the workflow to fetch data from a public CSV file and populate a designated Google Sheets tab.

2
Action

Download CSV file

The workflow downloads the COVID-19 testing data CSV file from the specified URL: https://opendata.ecdc.europa.eu/covid19/testing/csv/data.csv.

3
Logic

Extract and filter data

The workflow extracts and filters the relevant data, focusing on COVID-19 testing metrics for Germany, Austria, and Switzerland in 2023.

4
Action

Upload data to Google Sheets

The filtered and organized data is then uploaded directly to the designated Google Sheets document, allowing users to easily centralize and analyze the information within their existing spreadsheet infrastructure.

Setup guide

1

Add Google Sheets credential

1. Go to the **Latenode Credentials** panel. 2. Click **Add new credential**. 3. Select **Google Sheets** from the integration options. 4. Follow the authorization flow to connect your Google account and grant access to the Google Sheets API.

2

Configure HTTP Request node

1. In the Latenode visual builder, add an **HTTP Request** node. 2. In the node settings, set the **URL** to `https://opendata.ecdc.europa.eu/covid19/testing/csv/data.csv`. 3. Leave the other settings as default.

3

Map CSV data to Google Sheets

1. Add a **Google Sheets** node to the workflow. 2. In the node settings, select the Google Sheets credential you added earlier. 3. Choose the target spreadsheet and worksheet. 4. Map the CSV data fields to the corresponding Google Sheets columns.

4

Filter data for DACH countries in 2023

1. Add a **Filter** node to the workflow. 2. Configure the filter to keep only rows where the **country_code** is in the list `["DE", "AT", "CH"]` and the **year_week** starts with `"2023"`.

5

Trigger the workflow

1. In the Latenode visual builder, add a **Manual Trigger** node as the first node in the workflow. 2. When you're ready to run the workflow, click the **Execute** button in the Latenode interface.

Requirements

Latenode workspace with access to the 'http-request' and 'google-sheets' integrations
A Google Sheets document and a designated tab within that document to receive the imported data
The URL of the public CSV file containing the COVID-19 testing metrics for Germany, Austria, and Switzerland in 2023
A Google Cloud Platform service account with the necessary permissions to access and modify the target Google Sheets document

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →
Data, spreadsheets & databases

Automatically sync Notion items to new Google Docs documents

This automation allows users to automatically create a new Google Docs document whenever a new item is added to a Notion database. It streamlines the process of transferring data from Notion to Google Docs, making it easier for teams to collaborate on documents and reports. The automation triggers when a new item is added to the specified Notion database, and it then creates a corresponding Google Docs document with the relevant information. This integration between Notion and Google Docs helps users to centralize their data and workflows, improving productivity and efficiency.

26s$0.0703
Data, spreadsheets & databases

Automatically generate customized Google Docs from new form data

This automation allows users to create a new Google Doc based on a predefined template, using data from a new submission in a linked Google Form. Whenever a new row is added to the associated Google Sheets spreadsheet, the automation will trigger and generate a personalized document using the form data. This streamlines the process of creating documents from structured data, making it more efficient for individuals or teams working with Google's productivity suite. The primary systems involved are Google Forms, Google Sheets, and Google Docs.

26s$0.0703
Data, spreadsheets & databases

Automatically notify via Burst SMS when new rows added to Google Sheets

This Latenode automation allows users to stay focused on their primary workflows by automatically sending SMS messages through the Burst SMS platform whenever a new row is added to a specified Google Sheets spreadsheet. It connects the Google Sheets data source to the Burst SMS service, streamlining the notification process. Users can configure the specific spreadsheet and mobile number to receive the SMS updates, helping them stay informed without getting distracted from their main tasks.

7s$0.0004