E-Commerce
Automate Google Sheets data updates with conditional logic
11 nodes
120
77
Automatic trigger
Workflow Description
A workflow template that automatically updates and manages Google Sheets data based on scheduled triggers or manual execution. It processes incoming data through HTTP requests or custom code, applies filtering conditions, and uploads results to designated spreadsheets.
How it works
- 1.Trigger automation manually or on a recurring schedule
- 2.Receive and process data via HTTP requests or custom code
- 3.Apply conditional filters to identify relevant data
- 4.Split results and upload to specified Google Sheets tabs
Use cases
- Automatically update sales records and inventory levels in e-commerce spreadsheets
- Sync customer and order data from external sources to Google Sheets
Requirements
- Active Google Workspace account with Google Sheets access permissions
- Basic understanding of data formats and conditional logic
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Google Sheets
Details
Trigger
Automatic trigger
Nodes
11
Apps
1
Views
120
Downloads
77
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 (11)
/
When clicking ‘Test workflow’
Manual Trigger
Get Orders
HTTP Request
Extract page_info
Code
Merge Loop items
Code
List Orders
Split Out
Google Sheets
Google Sheets
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Schedule Trigger
Schedule Trigger
Assign page_info parameter
Set
Check page_info existence
If