PICKED FROM N8N.IO · ONLINE STORE
This workflow writes SEO meta titles and descriptions for WooCommerce products. It reads product IDs from a Google Sheet that lack them, fetches each product's details, and asks an AI model through OpenRouter to write the meta tags. It then updates the product in WooCommerce and marks the sheet.
Template by Davide Boizza · 7.5k views on n8n.io · listed there as “Automate WooCommerce SEO with Yoast & AI-powered meta tag generation for FREE”
- DIFFICULTY
- Intermediate
- NODES
- 9
- USES AI
- Yes
- PUBLISHED
- February 2025
001 / WHAT HAPPENS
- 01
A manual or schedule trigger starts the run.
- 02
Google Sheets returns product IDs that have no meta title or description yet.
- 03
WooCommerce returns the product's name, descriptions and categories.
- 04
An AI model through OpenRouter writes a meta title and description.
- 05
WooCommerce is updated with the new tags and the sheet row is updated.
WHO IT SUITS
Suits a WooCommerce store with hundreds of products and no meta descriptions, where writing each one by hand is not realistic.
CONNECTS
- WooCommerce
- Google Sheets
- OpenRouter
- Yoast SEO
002 / BEFORE YOU USE IT HERE
- !Product text is sent to an overseas AI provider through OpenRouter, which is a cross-border disclosure under APP 8 only if it contains personal information. Product copy usually does not.
- !It writes straight into live product fields. Review a sample first, and check the AI does not invent claims about your products.
- !The description says it targets Yoast, so confirm the meta field names match your SEO plugin. The template uses a free model that may change or be withdrawn.
LOCAL SWAP
Swap the OpenRouter model for an OpenAI or Anthropic chat model node if you prefer.
Need n8n and the AI hosted in Australia? →003 / MORE FOR ONLINE STORE
- 31 NODESAI
ONLINE STORE
Answer WooCommerce order and DHL tracking questions with AI chat
WooCommerceDHLOpenAIAdvancedby Jan Oberhauser20.7k views - 8 NODES
ONLINE STORE
Mark digital Shopify orders as fulfilled automatically on a schedule
ShopifyShopify Admin APIBeginnerby bangank366.1k views - 9 NODES
ONLINE STORE
Log weekly Shopify sales totals in Google Sheets and Slack
ShopifyGoogle SheetsSlackIntermediateby Lorena5.5k views
004 / QUESTIONS
Anything else is quicker to answer on a call. Thirty minutes, free, with the people who would build it.
Yes. Every template on this list is free on n8n.io. You need an n8n account (n8n Cloud or self-hosted) and accounts for the apps it connects to, some of which charge for API use.
We adapt templates to your systems, add approval steps where customers are involved, host n8n in Australia when the data calls for it and hand it over documented.
Book a free call→