🛒 AI-Powered WooCommerce Product Importer with SEO for n8n (eCommerce Automation)

Revolutionize your online store management with this n8n workflow that automates product imports while generating SEO-optimized metadata. Import hundreds of products from spreadsheets to WooCommerce in minutes, not hours.

Key Features:

• Spreadsheet-to-Store Automation: Bulk import products from Google Sheets
• AI SEO Optimization: Auto-generates meta titles/descriptions using Google Gemini
• Yoast Integration: Directly updates SEO metadata in WooCommerce
• Inventory Management: Handles SKUs, pricing, stock levels automatically
• Telegram Notifications: Instant alerts when imports complete
• Category Mapping: Converts spreadsheet categories to WooCommerce IDs

How to Install & Use:

1. Import Workflow: Add JSON to your n8n instance
2. Connect Services: Set up:

• WooCommerce API
• Google Sheets
• OpenRouter API (for Gemini)
• Telegram (optional)

1. Prepare Spreadsheet: Use provided template with product details
2. Enable Yoast: Add code snippet to WordPress functions.php
3. Run: Execute workflow to import products + SEO metadata

Business Benefits:

• 10X Faster Product Uploads: Reduce manual entry by 90%
• SEO-Ready Products: AI-generated metadata improves search rankings
• Eliminate Errors: Automated data handling prevents mistakes
• Centralized Management: Control inventory via Google Sheets
• Scalable Solution: Import 10 or 10,000 products effortlessly

Technical Requirements:

• n8n instance
• WooCommerce store with Yoast SEO
• Google Sheets
• OpenRouter API access

Why eCommerce Businesses Choose This:

Unlike basic import tools, this solution combines bulk product importing with AI-powered SEO optimization. The automatic Yoast integration ensures every product is search-engine ready from launch, while spreadsheet-based management gives teams familiar control over inventory.

Pro Tip:

Format your spreadsheet columns as specified (text/numeric formats) for flawless imports. The included Telegram notifications keep your team informed without manual checks.