AI-driven WooCommerce product importer with SEO
Workflow Description
Intelligent automation for importing products into WooCommerce directly from Google Sheets. The system analyzes data using AI, refines descriptions and titles for SEO, organizes them into safe batches, and sends real-time reports via Telegram for complete visibility.
How it works
- 1.Trigger the automation manually or when Google Sheets data updates
- 2.Fetch product data from Google Sheets using secure API connection
- 3.Process products through an open-source AI model to optimize titles, descriptions, and add relevant keywords
- 4.Split products into safe batches to prevent processing errors and ensure stability
- 5.Upload validated products to your WooCommerce store using the REST API
- 6.Send a comprehensive Telegram report showing total imported products, SEO improvements, and any errors
Use cases
- Import large product catalogs from Google Sheets with automatic SEO enhancement
- Sync products from multiple suppliers while standardizing descriptions and metadata
- Update product prices and information periodically without manual intervention
- Rewrite weak product descriptions into professional, search-optimized content
Requirements
- Valid Google Sheets API key with read and write permissions
- Active WooCommerce store with product creation and editing privileges
- API key for an open-source AI service (Open Router or similar)
- Telegram bot token or channel ID configured for notifications
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
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 (16)
When clicking ‘Test workflow’
Manual Trigger
OpenRouter Chat Model
Lm Chat Open Router
SEO Expert
LLM Chain
Get products
Google Sheets
Map categories
Code
Create product
Woo Commerce
Creation done
Google Sheets
Update meta
Google Sheets
Set SEO meta
Woo Commerce
Loop products
Split In Batches
Send message
Set
Structured Output Parser
Output Parser Structured
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note