AcademyWorkflowsData and reporting

Import a CSV from a URL into Google Sheets

Analysts and reporting teams that refresh a shared spreadsheet from a CSV file published online.

  • Recommendedour rating
  • 4,631views on n8n
Open on n8n.io ↗

Paste it straight onto an n8n canvas with Ctrl+V or Cmd+V.

import-csv-from-url-to-google-sheets.json

Loading the file...

What it does

An n8n workflow that downloads a CSV file from a web address, converts it to JSON and writes the rows into a Google Sheet. It builds a unique key from the country code and year week, keeps only the records you filter for, and updates matching rows instead of adding duplicates.

Use cases

  1. 01Refresh a shared sheet from a CSV published on the web
  2. 02Update existing rows without creating duplicates
  3. 03Filter a dataset before it reaches the sheet

Connects

Google Sheets · HTTP Request

Questions about
Import a CSV from a URL into Google Sheets.

What is Import a CSV from a URL into Google Sheets used for?

Analysts and reporting teams that refresh a shared spreadsheet from a CSV file published online. An n8n workflow that downloads a CSV file from a web address, converts it to JSON and writes the rows into a Google Sheet. It builds a unique key from the country code and year week, keeps only the records you filter for, and updates matching rows instead of adding duplicates.

How do I import Import a CSV from a URL into Google Sheets into n8n?

Copy the workflow JSON from this page and paste it onto the n8n canvas with Ctrl+V or Cmd+V. Then connect your credentials in each node.

Is Import a CSV from a URL into Google Sheets safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.