Developer & DevOps
Import multiple manufacturers from Google Sheets into 6
12 nodes
215
121
Automatic trigger
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.Trigger workflow manually and initialize required variables
- 2.Retrieve manufacturer list from Google Sheets database
- 3.Split data into manageable batches for processing
- 4.Apply programmatic transformation and data validation logic
- 5.Send each batch via HTTP POST request to the target endpoint
- 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
215
Downloads
121
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (12)
/
When clicking "Execute Workflow"
Manual Trigger
Settings
Set
Create Import Request Body
Code
Upload Manufacturer Logo
HTTP Request
Import Manufacturer
HTTP Request
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Loop Over Manufacturers
Split In Batches
Get Manufacturer from Google Sheet
Google Sheets
If has Logo
If
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note