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”

THE WORKFLOW9 NODES
MWhen clicking‘Test workflow’{}Structured OutputParser◷Schedule Trigger▦Get product IDWGet product✦Generatemetatitle e meta…WUpdate product▦Update SheetLGemini 2.0 FlashExp
DIFFICULTY
Intermediate
NODES
9
USES AI
Yes
PUBLISHED
February 2025

001 / WHAT HAPPENS

  1. 01

    A manual or schedule trigger starts the run.

  2. 02

    Google Sheets returns product IDs that have no meta title or description yet.

  3. 03

    WooCommerce returns the product's name, descriptions and categories.

  4. 04

    An AI model through OpenRouter writes a meta title and description.

  5. 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? →

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→