In this tutorial, you’ll learn how to use AI to generate Yoast SEO titles and descriptions for your WordPress posts. Manually writing SEO titles and SEO descriptions can be challenging, especially if you manage hundreds of WordPress blog posts. Fortunately, WP Sheet Editor – AI can assist you in automatically generating SEO meta titles and meta descriptions with a few clicks.
As you will see in this tutorial, generating AI SEO titles and descriptions is as simple as writing a simple shortcut WP Sheet Editor cells or bulk editing Yoast SEO fields. Since WP Sheet Editor integrates with Yoast SEO, you’ll be able to manage your SEO data in spreadsheet columns. And with WP Sheet Editor – AI, all your SEO workflow will be AI-powered!
Something important is that this method doesn’t work for WordPress posts only, you can use it to bulk manage SEO for posts, pages, WooCommerce products and other custom post types.
What you need to bulk manage Yoast SEO fields with AI
We assume you already have Yoast SEO.
Here’s what you need to bulk edit SEO for your WordPress posts using generative AI:
1- WP Sheet Editor – Post Types
This plugin allows you to view and manage WordPress posts, pages, and custom post types using an intuitive spreadsheet with advanced search, bulk edit, export, and import tools. If you already have it, you can skip this.
You can download the plugin here:
Download Posts, Pages, and Custom Post Types Spreadsheet Plugin - or - Check the features
2- WP Sheet Editor – AI
This is a WordPress AI assistant service that brings the power of generative AI to every WP Sheet Editor spreadsheet. You can connect with different AI providers and LLMs, and integrate the use of artificial intelligence in all spreadsheets of the WP Sheet Editor suite.
You can sign up here:
Sign up to the WP Sheet Editor - AI Service - or - Check the features
3- External API provider
The AI functionality in WP Sheet Editor relies on an external API like OpenAI, OpenRouter, etc. You’ll need an account with the provider and an API key to connect.
WP Sheet Editor – AI is compatible with these AI providers:
- Open AI for text and images (more info here)
- OpenRouter (more info here)
- Any other provider that uses the same format as OpenAI.
Follow this guide to learn how to set up AI providers in WP Sheet Editor – AI.
AI prompts for generating SEO titles and descriptions
Here are some prompts you can use in order to automatically generate SEO titles and descriptions. Keep in mind that you need to test these prompts and customize them if necessary.
Note: This prompts assume you already have the post titles, content, and SEO keywords, so we’ll reference the corresponding fields for Title, Content, and SEO Keyword. You can customize these prompts, though.
Prompt for generating SEO titles
You can use this prompt for generating SEO titles for your WordPress posts:
Generate a concise, engaging SEO title (50-60 characters) based on the $Title$ and $Content$, ensuring it includes the $SEO Keyword$. The title should be natural and compelling. Return plain text, free of quotation marks or unnecessary punctuation.
Prompt for generating SEO descriptions
You can use this prompt for generating SEO descriptions for your WordPress posts:
Generate a compelling SEO description based on the $SEO Title$ and $Content$, including the $SEO Keyword$. The description should be engaging, summarize the key points of the post, and encourage reader interest. Keep it under 155 characters for optimal search engine visibility. Return plain text only.
You can save these prompts as global prompts in order to reuse them using a simple shortcut.
Go to WP Sheet Editor > AI > Settings > Prompts.
Once there, click on Add new.
Now you need to add the prompts:
- Name: Add prompt names that are easy to remember, like “SEO Title” and “SEO Description”. This is important because, once you save the changes, each prompt will automatically generate a prompt slug that you’ll be able to use as a prompt shortcut like ai:seo-title or ai:seo-description.
- Prompt: Enter the prompt text here.
- Click on Save.
You need to create the two global prompts.
Open your WordPress posts spreadsheet
To start creating Yoast SEO titles and descriptions with AI, you need to open the WordPress posts spreadsheet.
Go to WP Sheet Editor > Edit posts, and you’ll see all your posts displayed in the spreadsheet.
Generate Yoast SEO titles and descriptions with AI in the spreadsheet
If you want to generate Yoast SEO titles with AI in spreadsheet cells, you can use the prompt shortcut ai:prompt-slug.
In this case, since the prompt slug for our SEO title prompt is “seo-title”, we need to enter this in the cells of the SEO Title column:
ai:seo-title
Note: Optionally, you can add full prompts in the spreadsheet cells. For example:
ai:Generate a concise, engaging SEO title (50-60 characters) based on the $Title$ and $Content$, ensuring it includes the $SEO Keyword$. The title should be natural and compelling. Return plain text, free of quotation marks or unnecessary punctuation.
But if you use full prompts, you’ll have to type or copy/paste the full prompt in every cell.
The AI will start generating your SEO title, so you’ll see a loading icon in the cell for some seconds.
As you see, we have generated our first SEO title.
If you want to generate multiple SEO titles with AI, you can paste the prompt shortcut in multiple cells.
As you can see, we have generated SEO titles for multiple WordPress posts, so we will save the changes.
To generate Yoast SEO descriptions with AI, you need to do the same you did with SEO titles. Just make sure you add the prompt slug that corresponds to the SEO description prompt.
As you see, we have pasted the ai:seo-description shortcut in multiple cells.
And once our SEO descriptions are generated, we can Save the changes.
Bulk generate Yoast SEO titles and descriptions with AI
If you don’t want to optimize SEO for WordPress posts in the spreadsheet, you can generate Yoast SEO data with AI using the Bulk Edit tool.
In this example, we will show you how to search for posts missing SEO titles and descriptions and generate them quickly
Bulk generate SEO titles with AI
Let’s search for all the WordPress posts missing SEO titles. Start by opening the Search tool.
Now select these values to find all posts without SEO title:
- Tick the Enable advanced filters checkbox.
- Field: SEO Title
- Operator: =
- Value: Leave this field empty
- Click on Run search.
As you see, we have filtered the posts missing SEO titles; you can see the active search filters displayed above the spreadsheet.
Now open the Bulk Edit tool.
Once there, you need to select these values in order to generate Yoast SEO titles in bulk:
- Select the rows that you want to update: Edit all the rows from my current search.
- What field do you want to edit: SEO Title
- Select type of edit: Here you have two options:
- First option: You can select a pre-saved global prompt. For example, we will select our pre-saved SEO title prompt, displayed as AI command: SEO Title. This way, you don’t have to type the prompt.
- Second option: You can select AI Prompt, and you can paste or type the full prompt.
- AI Provider: If you have configured multiple providers, you can select the one you want to use to complete this task.
- You can click on Show preview to see the result before saving the changes.
- Now you can click on Execute Now and the AI will start generating your SEO titles.
Bulk generate Yoast SEO descriptions with AI
To bulk generate Yoast SEO descriptions with AI, we will start by filtering all the WordPress posts missing SEO meta descriptions.
Let’s open the Search tool.
Now select these values to find all posts without SEO description:
- Tick the Enable advanced filters checkbox.
- Field: SEO Description
- Operator: =
- Value: Leave this field empty
- Click on Run search.
After filtering all the posts missing SEO description, open the Bulk Edit tool.
Once there, you need to select these values in order to generate Yoast SEO descriptions in bulk:
- Select the rows that you want to update: Edit all the rows from my current search.
- What field do you want to edit: SEO Description
- Select type of edit: Here you have two options:
- First option: You can select a pre-saved global prompt. For example, we will select our pre-saved SEO description prompt, displayed as AI command: SEO Description. This way, you don’t have to type the prompt.
- Second option: You can select AI Prompt, and you can paste or type the full prompt.
- AI Provider: If you have configured multiple providers, you can select the one you want to use to complete this task.
- You can click on Show preview to see the result before saving the changes.
- Now you can click on Execute Now and the AI will start generating your SEO descriptions.
As you can see, we have generated Yoast SEO titles and descriptions using generative AI, saving hours of work.
WP Sheet Editor – AI is the perfect companion to generate and edit WordPress content with the power of generative AI. Optimizing SEO for your WordPress blog posts is now an easy task with WP Sheet Editor AI.