Community Contributed: Import CSV from URL to Google Sheets

Name: Community Contributed: Import CSV from URL to Google Sheets
Rating: 1.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

36 views

0 downloads

Data Integrationautomationcsvdata processingfiltergoogle sheetshttp requestimport

Imports data from a CSV file hosted at a URL and uploads it to a Google Sheet.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow automates the process of fetching a CSV file from a specified URL and then importing its data into a Google Sheets document. It includes steps for downloading the file, parsing it, adding a unique identifier, filtering data, and finally uploading it to the designated Google Sheet. This is useful for regularly updating spreadsheets with external data sources.

Key Features

Downloads CSV files from a URL.
Parses CSV data.
Adds a unique key based on country code and year-week.
Filters data to include only specific regions (DACH) and years (2023).
Appends or updates data in a Google Sheet.
Includes error handling and notes on API rate limits.

How To Use

Set the WEBHOOK_URL environment variable to the URL of your CSV file.
Configure the Google Sheets credentials.
Specify the target Google Sheet and sheet name in the Upload to spreadsheet node.
Adjust the filtering conditions in the Keep only DACH in 2023 node if needed.
Execute the workflow manually.

Apps Used

automation

csv

data processing

filter

google sheets

http request

import

Workflow JSON

{
  "id": "64ffc43a-7620-453f-a9c1-4fd19ade36da",
  "name": "Community Contributed: Import CSV from URL to Google Sheets",
  "nodes": 0,
  "category": "Data Integration",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.