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:
- Automatically import products into WooCommerce.
- Map categories, stock, images, and pricing.
- Generate SEO-optimized meta titles and descriptions using AI (via OpenRouter & LangChain).
- Update both WooCommerce and Google Sheets with final product and SEO data.
- 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.
