Turn a simple spreadsheet into a fast product launcher for your store. Teams enter product data in Google Sheets and the flow publishes items in WooCommerce with clean SEO meta. It suits ecommerce and marketing teams that manage frequent product updates.

The run starts on demand. Rows are read from Google Sheets in batches to avoid timeouts. A code step converts category IDs from a comma list into the format WooCommerce expects. Each product is created with title, price, SKU, categories, description, and images. After creation, the system writes the product ID, permalink, and done flag back to the sheet. AI then generates a meta title and a meta description using OpenRouter with a structured parser to keep fields clean. Those SEO fields are saved into WooCommerce using the Yoast meta keys, and a Telegram message confirms completion.

Set up WooCommerce and Yoast, enable the REST meta keys, and connect your accounts. Copy the sample sheet and keep the column formats provided so price, text, and HTML are handled correctly. Expect faster launches, less manual entry, and consistent SEO across your catalog. It works well for new collections, seasonal drops, and catalog migrations.

• Manual start for safe, on demand publishing runs
• Reads product rows from Google Sheets and loops them in batches
• Code step converts comma separated category IDs into the correct number array
• Creates WooCommerce products with title, description, price, SKU, image and categories
• Writes product ID, permalink and done flag back to the sheet
• Generates meta title and meta description using OpenRouter with a structured parser
• Updates Yoast SEO meta fields on the product through WooCommerce
• Sends a Telegram message when processing is complete

• Reduce product upload time from 30 minutes per item to 2 minutes
• Automate up to 90 percent of repetitive catalog work
• Improve SEO meta accuracy by 95 percent with structured outputs
• Connect Google Sheets, WooCommerce, OpenRouter and Telegram in one flow
• Handle large imports safely with batch processing
• Keep the sheet and store in sync with IDs, permalinks and status

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets, WooCommerce, Telegram and OpenRouter. See the Tools Required section above for links to create accounts with these services.
3. In WordPress, install WooCommerce and Yoast SEO. Enable the WooCommerce REST API and add the provided function in your theme functions.php to expose Yoast meta keys in the REST API.
4. In your WooCommerce admin, create REST API keys. In n8n, open the WooCommerce nodes and in the credential dropdown choose Create new credential. Enter your store URL, Consumer Key and Consumer Secret, then save.
5. In n8n, open the Google Sheets nodes. In the credential dropdown select Create new credential and choose Google Sheets OAuth2. Follow the on screen steps to grant access to your Google account.
6. Copy the sample Google Sheet. Keep column formats: B, E and F as text, C as the image URL, G and H allow HTML, and I as numeric. Fill rows A to I with product data.
7. Open the Get products node and set the correct Spreadsheet ID and Sheet name. Ensure the filter uses the DONE column so only rows not marked done are processed.
8. Open the OpenRouter Chat Model node. In the credential dropdown choose Create new credential. Get your API key from the OpenRouter website, paste it, and select the model google/gemini-2.0-flash-exp or another model you prefer.
9. Open the Telegram Send message node. Create a new Telegram Bot in BotFather, copy the bot token, then in n8n create the Telegram credential. Set your chat ID in the Chat ID field and send a test message.
10. Check the Code node that maps categories. Ensure your sheet has category IDs separated by commas and that these IDs exist in WooCommerce.
11. Optionally adjust the Split in Batches size to respect your API rate limits. Smaller batches help avoid timeouts on large catalogs.
12. Click Test workflow to run. Verify a new product appears in WooCommerce, the sheet updates ID, permalink and DONE, SEO meta is present in the product, and a Telegram message is received. If meta is missing, confirm the functions.php code and API permissions.