AI-Powered WooCommerce Product Importer with SEO Optimization
detail.loadingPreview
Effortlessly import products from Google Sheets to WooCommerce while automatically generating SEO-optimized meta titles and descriptions using AI. Streamline your e-commerce operations and enhance product visibility with intelligent automation.
About This Workflow
Managing an e-commerce store often involves tedious manual product entry and the complex task of crafting SEO-friendly content. This n8n workflow revolutionizes your WooCommerce product management by automating the entire import process directly from a Google Sheet. Beyond just importing product details like titles, descriptions, images, prices, and stock, it integrates an advanced AI model via OpenRouter to dynamically create compelling and SEO-optimized meta titles and descriptions for each new product. This not only saves countless hours but also ensures your products are primed for higher search engine rankings from day one. Say goodbye to manual data entry and hello to smarter, faster product launches.
Key Features
- Automated Product Import: Seamlessly transfer product data (titles, descriptions, SKUs, prices, stock, images, categories) from Google Sheets to WooCommerce.
- AI-Driven SEO Content Generation: Leverage an integrated LLM (via OpenRouter) to automatically generate SEO-optimized meta titles (max 60 chars) and meta descriptions (max 160 chars) for every new product.
- Dynamic Category Mapping: Automatically parse and map comma-separated category IDs from your Google Sheet to WooCommerce categories.
- Workflow Tracking: Update your Google Sheet with the WooCommerce product ID and permalink, and mark products as "DONE" after successful import.
- Flexible AI Model Integration: Easily switch or configure your preferred OpenRouter-compatible AI model for content generation.
How To Use
- Connect Google Sheets:
- Obtain your Google Sheets Document ID (from the URL).
- Ensure your Google Sheet contains columns for
TITLE,CATEGORY(comma-separated IDs),IMAGE,SKU,REGULAR PRICE,SALE PRICE,STOCK QTY,SHORT DESCRIPTION,DESCRIPTION, and aDONEcolumn. - Configure the "Get products" node with your Google Sheets credential, Document ID, and Sheet Name.
- Connect WooCommerce:
- Set up a WooCommerce API key (go to WooCommerce > Settings > Advanced > REST API).
- Configure the "Create product" node with your WooCommerce credential (store URL, consumer key, consumer secret).
- Connect OpenRouter:
- Sign up for an OpenRouter account and generate an API key.
- Configure the "OpenRouter" credential with your API key.
- (Optional) Adjust the
modelin the "OpenRouter Chat Model" node if you prefer a different LLM.
- Review Mappings: Verify that the field mappings in "Create product" node and the SEO prompt in "SEO Expert" node align with your Google Sheet column headers and desired SEO output.
- Run the Workflow: Execute the workflow manually or set up a schedule to automatically import and optimize your products.
Apps Used
Workflow JSON
{
"id": "dd398544-0b96-4ff2-85a7-b6f2c09c1c01",
"name": "AI-Powered WooCommerce Product Importer with SEO Optimization",
"nodes": 7,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: dd398544-0b96...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Related Workflows
Discover more workflows you might like
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.