Developer & DevOps

Import multiple manufacturers from Google Sheets into 6

12 nodes 213 121 Automatic trigger
Download

Workflow Description

An automation template that imports manufacturer data from Google Sheets in batches, processes it through custom code, and delivers it to an external system via HTTP requests with comprehensive error handling and validation at each step.

How it works

  1. 1.Trigger workflow manually and initialize required variables
  2. 2.Retrieve manufacturer list from Google Sheets database
  3. 3.Split data into manageable batches for processing
  4. 4.Apply programmatic transformation and data validation logic
  5. 5.Send each batch via HTTP POST request to the target endpoint
  6. 6.Verify system response and log transaction results

Use cases

  • Import large supplier and manufacturer lists without manual intervention
  • Synchronize product data between Google Sheets and internal management systems
  • Process large datasets efficiently by dividing them into optimized chunks

Requirements

  • Active Google Workspace account with Sheets API access enabled
  • Clear understanding of data format requirements for the receiving system
  • Valid API endpoint or HTTP URL for the destination application
  • Basic JavaScript knowledge to customize data transformation logic

Service Value

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

Apps Used

Split In Batches Google Sheets

Details

Trigger Automatic trigger
Nodes 12
Apps 2
Views 213
Downloads 121

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 (12)

/

When clicking "Execute Workflow"

Manual Trigger

#1

Settings

Set

#2

Create Import Request Body

Code

#3

Upload Manufacturer Logo

HTTP Request

#4

Import Manufacturer

HTTP Request

#5

Sticky Note

Sticky Note

#6

Sticky Note1

Sticky Note

#7

Loop Over Manufacturers

Split In Batches

#8

Get Manufacturer from Google Sheet

Google Sheets

#9

If has Logo

If

#10

Sticky Note2

Sticky Note

#11

Sticky Note3

Sticky Note

#12