FM
FlowMarket
DevOps & GitHub Intermediate ⚡ 7 n8n Nodes

Import CSV from URL to Google Sheets

This workflow automatically imports data from a CSV file located at a specific URL and then updates the Google Sheets document with the provided data. Below ...

🔌 Nodes & Integrations Used (3)

Google Sheets Spreadsheet File HTTP Request

📖 Implementation & Setup Guide

This workflow automatically imports data from a CSV file located at a specific URL and then updates the Google Sheets document with the provided data.

Below is a step-by-step description of what this workflow does: 1. The workflow is started manually using the "When you click 'Execute Workflow'" node. 2. The CSV file is then uploaded from the specified URL "https://opendata.ecdc.europa.eu/covid19/testing/csv/data.csv" using the "Upload CSV" node. 3. The "Import CSV" node accepts the uploaded CSV file and converts it into JSON formatted data. 4. The "Add Unique Field" node generates a unique key by combining the 'country_code' and 'year_week' fields from the JSON data, which will be further used in the Google Sheets document. 5. The 'Keep only DACH in 2023' node filters the data to keep only records where 'country_code' is either 'DE', 'AT', or 'CH' and 'year_week' starts with '2023'. Google's API has limitations on the speed of read and write operations, so only a subset of the data is taken. 6. The filtered data is loaded into the specified Google Sheets document via the 'Load to Spreadsheet' node. The operation is set to 'appendOrUpdate' and the document ID and sheet name are specified. Also, the previously generated 'unique_key' key is set as the key to match the columns.

⚡ How to import this workflow into n8n:

  1. Click the Direct Download JSON button above to save Import CSV from URL to Google Sheets.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related DevOps & GitHub Workflows

View All in DevOps & GitHub →