Developer & DevOps

Import CSV file from to

7 nodes 212 117 Automatic trigger
Download

Workflow Description

Automation template that imports CSV files into Google Sheets automatically. Streamlines data transfer with built-in filtering and validation, eliminating manual imports and reducing errors. Ideal for recurring data ingestion tasks requiring structured processing and verification.

How it works

  1. 1.Activate manual trigger to start the import process
  2. 2.Read CSV file from designated source location
  3. 3.Transform and format data for Google Sheets compatibility
  4. 4.Apply filters to exclude unnecessary or invalid records
  5. 5.Upload processed data to target Google Sheets document
  6. 6.Verify import success and log completion details

Use cases

  • Import customer lists and business data from CSV sources weekly or monthly
  • Synchronize inventory records between external systems and cloud spreadsheets

Requirements

  • Active Google Workspace account with spreadsheet access permissions
  • Properly formatted CSV files with clearly defined column headers

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

Google Sheets Spreadsheet File

Details

Trigger Automatic trigger
Nodes 7
Apps 2
Views 212
Downloads 117

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (7)

When clicking "Execute Workflow"

Manual Trigger

#1

Upload to spreadsheet

Google Sheets

#2

Add unique field

Set

#3

Import CSV

Spreadsheet File

#4

Download CSV

HTTP Request

#5

Keep only DACH in 2023

Filter

#6

Sticky Note

Sticky Note

#7