WooCommerce AI Product Import & SEO

This workflow automates the entire WooCommerce product creation process by connecting Google Sheets with your WooCommerce store. Simply enter product details into a spreadsheet, and the workflow will:

1. Automatically import products into WooCommerce.
2. Map categories, stock, images, and pricing.
3. Generate SEO-optimized meta titles and descriptions using AI (via OpenRouter & LangChain).
4. Update both WooCommerce and Google Sheets with final product and SEO data.
5. Send a Telegram notification once the process is complete.

Perfect for e-commerce owners, digital marketers, or agencies managing multiple product imports and SEO at scale.

✨ Features

• 📊 Google Sheets Integration – Manage products from a simple spreadsheet.
• 🛒 WooCommerce Automation – Auto-create products with images, pricing, and stock.
• 🤖 AI-Powered SEO – Automatically generate optimized meta titles & descriptions for each product.
• 🔄 Category Mapping – Clean handling of product categories for WooCommerce compatibility.
• 📝 Yoast SEO Integration – Updates Yoast SEO fields (_yoast_wpseo_title & _yoast_wpseo_metadesc) directly in WooCommerce.
• ✅ Progress Tracking – Updates Google Sheets with product ID, permalink, and SEO data.
• 📢 Notifications – Sends Telegram alerts when the workflow completes.
• ⚡ Scalable & Repeatable – Easily extend for bulk imports or multilingual SEO.