AutomationMart
Home/Browse/Automate WooCommerce SEO with Yoast & AI-powered meta tag generation for FREE
n8n

Automate WooCommerce SEO with Yoast & AI-powered meta tag generation for FREE

n8nn8n9 modulesv1.0
Google SheetsWooCommerceLinkedInGemini

This workflow is designed to automate the generation and updating of SEO meta titles and descriptions for WooCommerce products using n8n. It leverages Google Sheets for data input, a FREE language model (Gemini 2.0 Flash Exp. via OpenRouter) for generating SEO-optimized meta tags, and WooCommerce for updating product details. How It Works: 1. Trigger: The workflow can be triggered manually or on a schedule. The manual trigger allows for testing, while the schedule trigger can be set to run at re

At a glance

Automate WooCommerce SEO with Yoast & AI-powered meta tag generation for FREE is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, WooCommerce, LinkedIn, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, WooCommerce, LinkedIn, Gemini
Modules
9
Price
Free
Version
v1.0
Automate WooCommerce SEO with Yoast & AI-powered meta tag generation for FREE workflow diagram

About this workflow

This workflow is designed to automate the generation and updating of SEO meta titles and descriptions for WooCommerce products using n8n. It leverages Google Sheets for data input, a FREE language model (Gemini 2.0 Flash Exp. via OpenRouter) for generating SEO-optimized meta tags, and WooCommerce for updating product details. How It Works: 1. Trigger: The workflow can be triggered manually or on a schedule. The manual trigger allows for testing, while the schedule trigger can be set to run at regular intervals (e.g., every few minutes) to process new products. 2. Data Retrieval: - The workflow starts by retrieving product IDs from a Google Sheets document. It looks for products that do not yet have meta titles or descriptions. - Using the retrieved product ID, the workflow fetches the corresponding product details from WooCommerce, including the product name, description, short description, and categories. 3. Meta Tag Generation: - The product details are passed to a language model (Gemini 2.0 Flash Exp) via OpenRouter. The model generates SEO-optimized meta titles and descriptions based on the provided content. - The generated meta tags are structured and validated to ensure they meet SEO best practices, such as character limits and keyword inclusion. 4. Update WooCommerce: - The generated meta title and description are then updated in the WooCommerce product metadata using the Yoast SEO fields. 5. Update Google Sheets: - Finally, the workflow updates the Google Sheets document with the newly generated meta tags, along with the product URL, title, and the timestamp of the update. Set Up Steps: 1. Google Sheets Setup: - Create a copy of the provided Google Sheets template and insert WooCommerce product IDs in column "B". - Ensure the Google Sheets document has columns for METATITLE, METADESCRIPTION, URL, TITLE POST, and DATA (timestamp). 2. n8n Workflow Configuration: - Google Sheets Node: Configure the "Get product ID" node to connect to your Google Sheets document. Use OAuth2 for authentication. - WooCommerce Node: Set up the WooCommerce nodes to connect to your WooCommerce store using the WooCommerce API credentials. - OpenRouter Node: Configure the "Gemini 2.0 Flash Exp" node with your OpenRouter API credentials to access the language model. - Structured Output Parser: Ensure the output parser is set to handle the structured data format for meta titles and descriptions. 3. Workflow Execution: - Trigger the workflow manually to test the process or set up a schedule trigger to automate the workflow at regular intervals. - Monitor the workflow execution to ensure that meta tags are generated and updated correctly in both WooCommerce and Google Sheets. 4. Validation: - After the workflow runs, verify that the meta titles and descriptions in WooCommerce are correctly updated and that the Google Sheets document reflects the changes. This workflow streamlines the process of optimizing WooCommerce product pages for SEO, saving time and ensuring consistency in meta tag generation. --- Need help customizing? Contact me for consulting and support or add me on Linkedin.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Add new rows to a Google Sheets spreadsheet from new orders in GoodBarber eCommerce

Every time a new order is created in GoodBarber eCommerce, a new row will be added to a Google Sheets spreadsheet.

Free

Build your first AI data analyst chatbot

Enhance your data analysis by connecting an AI Agent to your dataset, using n8n tools. This template teaches you how to build an AI Data Analyst Chatbot that is capable of pulling data from your sources, using tools like Google Sheets or databases. It's designed to be easy and efficient, making it a good starting point for AI-driven data analysis. You can easily replace the current Google Sheets tools for databases like Postgres or MySQL. How It Wor

Free

Route and audit Odoo draft orders with GPT‑4o and Arabic semantic scheduling

What it is Manual order entry in retail and e-commerce often results in fragmented data. Sales representatives might skip mandatory address fields or write critical delivery instructions in unstructured, regional slang inside the POS notes. This workflow acts as an automated QA Auditor and Logistics Dispatcher. It polls Odoo for new draft orders and uses an OpenAI LLM (gpt-4o-mini) to semantically analyze the payload. The AI intelligently distinguishes between automated website orders (which ar

Free

Save new Invoiced invoices to a Google Sheets spreadsheet

Every time a new invoice is created in Invoiced, Make will automatically add it to a new row in your Google Sheets spreadsheet. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1_vTvIrK8oOKxvapqd_oIm-LYimd9_I6EQmbJo0sO-8A/edit?usp=sharing).

Free

Auto-sync local events to Google Calendar with n8n

Description This workflow automates the process of finding local events and adding them directly to your Google Calendar. It eliminates the need for manual event tracking by automatically scraping event information and creating calendar entries. Overview This workflow automates the process of finding local events and adding them to your Google Calendar. It uses Bright Data to scrape event information from a specified source and then creates new events in your calendar, ensuring you

Free

Create AI-ready vector datasets for LLMs with Bright Data, Gemini & Pinecone

Who this is for? This workflow enables automated, scalable collection of high-quality, AI-ready data from websites using Bright Data’s Web Unlocker, with a focus on preparing that data for LLM training. Leveraging LLM Chains and AI agents, the system formats and extracts key information, then stores the structured embeddings in a Pinecone vector database. This workflow is tailored for:​ - ML Engineers & Researchers building or fine-tuning domain-specific LLMs. - AI Startups needing clean, struct

Free

Fetch real-time stock quotes to Google Sheets with OpenAI, Octagon and GitHub

Octagon Stock Quote Skill → Google Sheets Automate real-time stock quote enrichment in Google Sheets using n8n, OpenAI, and Octagon Agent. This workflow reads ticker symbols from a spreadsheet, fetches the live stock-quote Skill from GitHub, uses an OpenAI prompt-builder step to generate the best Octagon Agent query, executes the quote request through Octagon, then writes structured market data back into Google Sheets. How this n8n workflow works 1. Fetches the live SKILL.md file from Gi

Free

Automate conference travel approvals with Deepseek AI, Gmail and Google Sheets

Introduction Automates overseas conference approval requests to CEO. Generates emails with conference details, flight quotes, accommodation, expense breakdown, and admin procedures. Ensures consistency and saves time. How It Works Manual trigger initiates: fetches exchange rates/conference details, parses flight quotes, uses AI to calculate expenses and generate draft, checks budget, formats messages, merges versions, creates PDF, sends to CEO, logs to tracker. Workflow Template Manu

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free