Writing SEO titles and meta descriptions for hundreds of WordPress posts is slow, repetitive work. If you use Rank Math SEO, manually opening each page to craft metadata can eat up hours or even days. The faster approach: use generative AI to create optimized Rank Math SEO titles and descriptions in bulk, directly inside a spreadsheet interface.
With WP Sheet Editor – AI, you can view all your Rank Math SEO fields in a spreadsheet, connect to an AI provider like OpenAI or OpenRouter, and let a large language model generate titles and descriptions across dozens or thousands of posts at once. You keep full control over the prompts, you can preview results before saving, and you never have to leave your WordPress dashboard.
Quick Summary
| Step | What You Do |
|---|---|
| 1. Install the tools | WP Sheet Editor – Post Types, WP Sheet Editor – AI, and an API key from an AI provider |
| 2. Create global prompts | Save reusable AI prompts for SEO titles and descriptions in the AI settings panel |
| 3. Open the spreadsheet | Navigate to WP Sheet Editor > Edit posts to see all posts in a spreadsheet |
| 4. Generate cell by cell | Type ai:prompt-slug into any Rank Math Title or Description cell |
| 5. Or bulk generate | Filter posts, then use the Bulk Edit tool with your saved AI prompt to update hundreds at once |
| 6. Preview and save | Use Show preview to verify output, then click Execute Now |
Table of Contents
What you need to bulk manage Rank Math SEO fields with AI
We assume you already have Rank Math SEO installed and activated. Beyond that, here’s what you need to start generating SEO metadata with generative AI from a spreadsheet:
1. WP Sheet Editor – Post Types
This plugin lets you view and manage WordPress posts, pages, and custom post types using an intuitive spreadsheet. It includes 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 generative AI into every WP Sheet Editor spreadsheet. You can connect with different AI providers and language models and use artificial intelligence across all spreadsheets in the WP Sheet Editor suite. It supports cell-level editing, bulk operations, and saved global prompts you can reuse with simple shortcuts.
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, or any provider that follows the OpenAI API format. You need an account with the provider and an API key to connect.
WP Sheet Editor – AI is compatible with these AI providers:
- OpenAI for text and images (more info here)
- OpenRouter (more info here)
- Any other provider that uses the same format as OpenAI.
Which provider you choose comes down to your preferences around model quality, speed, and cost. OpenAI’s models produce consistently strong SEO copy, and OpenRouter gives you access to multiple providers, including Anthropic’s and Google’s models, through a single API. Either works well for generating metadata, and you pay the provider directly at standard API rates rather than through a bundled subscription.
Follow this guide to learn how to set up AI providers in WP Sheet Editor – AI.
Why the spreadsheet approach works better for bulk SEO tasks
Rank Math already includes a bulk actions dropdown for generating SEO titles and descriptions with its own Content AI. That method works, but it has limits: you select posts from a list, choose an action, and wait. You cannot filter posts by complex criteria first, preview exactly what the AI will produce before committing, or customize prompts per post type. Rank Math’s Content AI also runs on a paid subscription with a usage credit allowance, so heavy bulk runs can hit a cap. The spreadsheet method connects to your own OpenAI or OpenRouter account instead, so you’re paying standard API rates with no credit ceiling to run into.
The spreadsheet approach gives you more granular control. You can:
- Filter posts that are missing SEO titles, missing descriptions, or both, using advanced search conditions
- Sort by post date, category, or any column to prioritize your most important content first
- Write and save your own AI prompts, tuned to your specific niche, audience, and brand voice
- Preview the generated output row by row before saving anything to the database
- Apply different prompts to different rows. Product pages get one prompt style, blog posts get another
- Use the same spreadsheet to edit other Rank Math fields like focus keywords, canonical URLs, or schema data in the same session
- Connect your own API key instead of relying on a bundled AI subscription with usage limits
For sites with a large content library, mixed post types, or specific metadata requirements, the spreadsheet gives you precision that a one-click bulk action cannot match.
AI prompts for generating SEO titles and descriptions
The quality of your AI-generated metadata depends almost entirely on the prompt you use. A vague prompt produces generic output. A specific prompt that references your content and your target keyword produces metadata that actually matches what the page delivers.
Below are two prompts designed to work with WP Sheet Editor – AI. They reference column values from your spreadsheet: $Title$, $Content$, and $Rank Math Focus Keyword$. The AI reads the actual data from each row before generating the output, so every title and description is unique to that page.
AI prompt for generating Rank Math SEO titles
Use this prompt to create concise, keyword-rich SEO titles:
Generate a concise, engaging SEO title (50-60 characters) based on the $Title$ and $Content$, ensuring it includes the $Rank Math Focus Keyword$. The title should be natural and compelling. Return plain text, free of quotation marks or unnecessary punctuation.
AI prompt for generating Rank Math SEO descriptions
Use this prompt for meta descriptions:
Generate a compelling SEO description based on the $Rank Math Title$ and $Content$, including the $Rank Math Focus 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.
Tips for customizing these prompts
The prompts above are a solid starting point, but you can adjust them to better fit your site. A few examples of useful customizations:
- Add a brand name: Append “End the title with | YourBrandName” to the title prompt.
- Control tone: Add “Use a professional tone” or “Use a conversational, friendly tone” depending on your audience.
- Include a call to action: For the description prompt, try adding “Include a soft call to action like ‘Learn more’ or ‘Read the full guide.'”
- Specify what to avoid: Add “Do not use clickbait phrasing or exaggerated claims.”
- Handle missing focus keywords: If some posts lack a focus keyword, add a fallback: “If the focus keyword field is empty, use the post title to guide the SEO title.”
You can save different prompt variations for different post types. For example, an ecommerce product description prompt might emphasize features and benefits, while a blog post prompt might emphasize informational value and readability.
Saving prompts as global prompts for reuse
Once you have prompts you like, save them as global prompts so you can reuse them with a simple shortcut instead of retyping the full prompt every time.
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 can use as a shortcut like ai:seo-title or ai:seo-description.
- Prompt: Enter the prompt text here.
- Click on Save.
We have shown you how to create the SEO title global prompt. Now you can do the same with the SEO description prompt.
Having both prompts saved as global shortcuts means you can switch between generating titles and descriptions in seconds, without ever opening the settings panel again.
Open the WordPress posts spreadsheet
To open the posts spreadsheet, go to WP Sheet Editor > Edit posts, and you will see all your posts listed in the spreadsheet. The columns include your standard WordPress fields (title, content, date, status) alongside Rank Math SEO columns like Rank Math Title, Rank Math Description, and Rank Math Focus Keyword.
If you are working with custom post types like WooCommerce products, portfolio items, or course lessons, you can access those spreadsheets from the WP Sheet Editor menu as well. The process for generating SEO metadata is identical regardless of the post type.
Generate Rank Math SEO titles with AI in individual spreadsheet cells
With your global prompts saved, go to the Rank Math Title column and start generating SEO titles. You have two options for invoking the AI:
- Use the global prompt’s shortcut. Type ai:prompt-slug, replacing prompt-slug with the actual slug of your global prompt. For example, if your prompt slug is “seo-title”, type ai:seo-title in the cells of the Rank Math Title column.
- Use the full prompt. Type ai:prompt, replacing prompt with the complete prompt text. This is useful for one-off generations where you do not want to create a saved global prompt.
In this example, we will use the ai:seo-title shortcut to generate our SEO titles with generative AI.
The AI will start working. You will see a loading icon in the cell for a few seconds. When it finishes, the generated SEO title appears in the cell.
You can generate multiple SEO titles across the spreadsheet by pasting the prompt or prompt shortcut into multiple cells at once. Select a range of cells, paste, and the AI processes each row independently using that row’s own title, content, and focus keyword.
After generating the SEO titles, click Save to commit the changes to the database. Unsaved changes will be highlighted so you can review them before saving.
Bulk generate Rank Math SEO titles with AI
When you need to generate SEO titles for hundreds of posts at once, the cell-by-cell method works but the Bulk Edit tool is faster. It lets you update any field across thousands of posts in a single operation. The key is filtering your posts first so the AI only runs on the rows that actually need new titles.
Start by opening the Search tool to filter posts that are missing an SEO title.
Now select these values in the Search tool to find posts without an SEO title:
- Tick the Enable advanced filters checkbox.
- Field: Rank Math Title
- Operator: =
- Value: Leave this field empty.
- Click on Run search.
After filtering the posts you want to edit, open the Bulk Edit tool.
Now select these values to generate the SEO titles using AI. You have two options for how to supply the prompt:
Option 1: Using a global prompt
- Select the rows that you want to update: Edit all the rows from my current search.
- What field do you want to edit: Rank Math Title
- Select type of edit: Choose a pre-saved global prompt. In this example, we select our saved SEO title prompt, displayed as AI command: SEO Title. This way, you do not have to type the prompt again.
- AI Provider: If you have configured multiple providers, select the one you want to use for this task.
- Click Show preview to see the results before saving.
- Click Execute Now and the AI will start generating your SEO titles.
Always use Show preview before executing. It lets you spot-check a sample of generated titles for accuracy, keyword inclusion, and character length. If the output does not look right, you can adjust your prompt and preview again before committing to the bulk update.
Option 2: Using a full prompt in the Bulk Edit tool
- Select the rows that you want to update: Edit all the rows from my current search.
- What field do you want to edit: Rank Math Title
- Select type of edit: AI prompt
- AI Provider: If you have configured multiple providers, select the one you want to use.
- Prompt: Enter the full prompt here. This is the right option when you want to test a prompt variation without saving it as a global prompt first.
- Click Show preview to verify the output.
- Click Execute Now and the AI will start generating your SEO titles.
Generate SEO descriptions with AI in spreadsheet cells
The process for generating meta descriptions follows the same pattern as titles. Go to the Rank Math Description column and start generating AI-powered SEO descriptions. You have the same two options:
- Use the global prompt’s shortcut. Type ai:prompt-slug, replacing prompt-slug with the actual slug of your global prompt. If your prompt slug is “seo-description”, type ai:seo-description in the cells of the Rank Math Description column.
- Use the full prompt. Type ai:prompt, replacing prompt with the complete prompt text.
In this example, we will use the ai:seo-description shortcut to generate descriptions.
The AI will process the request. A loading icon appears in the cell for a few seconds, and then the generated SEO description replaces the shortcut text.
You can paste the same prompt or prompt shortcut into multiple cells to generate several SEO descriptions at once, just as you would with titles.
After generating the SEO descriptions, click Save to write the changes to your site.
Bulk generate Rank Math SEO descriptions using AI
To bulk generate descriptions, first filter for posts that are missing them. Open the Search tool.
Now select these values to filter posts without SEO descriptions:
- Tick the Enable advanced filters checkbox.
- Field: Rank Math Description
- Operator: =
- Value: Leave this field empty.
- Click on Run search.
After filtering, open the Bulk Edit tool.
Now select these values to generate the SEO descriptions using AI:
Option 1: Using a global prompt
- Select the rows that you want to update: Edit all the rows from my current search.
- What field do you want to edit: Rank Math Description
- Select type of edit: Choose a pre-saved global prompt. In this case, select the saved SEO description prompt, displayed as AI command: SEO Description.
- AI Provider: If you have multiple providers configured, pick the one for this task.
- Click Show preview to check the output before saving.
- Click Execute Now and the AI will start generating your SEO descriptions.
Option 2: Using a full prompt in the Bulk Edit tool
- Select the rows that you want to update: Edit all the rows from my current search.
- What field do you want to edit: Rank Math Description
- Select type of edit: AI prompt
- AI Provider: If you have multiple providers, choose the one for this task.
- Prompt: Enter the full prompt.
- Click Show preview to verify the output.
- Click Execute Now and the AI will start generating your SEO descriptions.
What to check before you publish AI-generated SEO metadata
Even with well-crafted prompts, AI output deserves a human review pass before it goes live. Here is a checklist of what to verify:
- Character length: Titles should stay under 60 characters. Descriptions under 155 characters. Longer text gets truncated in search results. The prompts above include these limits, but spot-check a few rows to confirm the AI respected them.
- Focus keyword inclusion: The primary keyword should appear naturally in both the title and description. If a post does not have a focus keyword set, the AI may substitute generic phrasing. Fill in focus keywords for your most important posts before running the generation.
- Uniqueness: Each title and description should be distinct. If you notice near-duplicate output across similar posts, try adding more specific instructions to your prompt or including the post title as a stronger anchor in the prompt text.
- Accuracy: The metadata should reflect what the page actually contains. The AI only knows what you feed it through the
$Content$variable. If a post’s content is thin or poorly structured, the generated description may be vague. - Brand consistency: If your site follows a specific naming convention or always includes a brand suffix, make sure that pattern is reflected. Adjust your prompts to enforce it automatically rather than editing each row afterward.
Running through these checks on a preview sample takes a few minutes and prevents publishing metadata that could hurt your click-through rates.
Once your global prompts are set up, generating SEO titles and descriptions for a large site comes down to filtering the right posts, running the Bulk Edit tool, and reviewing the preview before you save. The same spreadsheet also holds every other Rank Math field, so you can clean up focus keywords or canonical URLs in the same session instead of switching between tools.
You can sign up here:
Sign up to the WP Sheet Editor - AI Service - or - Check the features
Frequently Asked Questions
Can I use this method for custom post types and WooCommerce products?
Yes. WP Sheet Editor provides spreadsheets for every post type on your site, including WooCommerce products, portfolio items, course lessons, and any custom post type registered by your theme or plugins. The Rank Math SEO columns appear in every spreadsheet, and the AI prompt shortcuts work the same way regardless of the post type. You can create separate global prompts tailored to each post type if their metadata needs differ. For example, a product SEO title prompt might reference price or category fields, while a blog post prompt references the content and focus keyword.
What happens if a post does not have a focus keyword set in Rank Math?
The AI will still generate a title and description based on the post title and content alone, but the output may be less targeted. The prompt references $Rank Math Focus Keyword$ as a variable. If that field is empty, the AI typically works around it or substitutes a relevant term from the content. You can improve results by filtering for posts with missing focus keywords first, filling them in manually or using a separate AI prompt designed for keyword research, and then running the SEO title and description generation afterward.
How do I review AI-generated SEO titles and descriptions before they go live?
You have two built-in review mechanisms. For cell-level generation, the AI output appears directly in the spreadsheet cell. You can read and edit it inline before clicking Save. Unsaved changes are visually marked. For bulk generation, the Show preview button in the Bulk Edit tool displays a sample of what the AI will produce across your selected rows. If the preview does not meet your standards, close the tool, adjust the prompt in your global prompt settings, and preview again. Nothing is written to the database until you click Execute Now.
Which AI model produces the best SEO metadata?
There is no single best model for everyone. OpenAI’s models tend to produce concise, keyword-focused output, Anthropic’s Claude models often write more natural, engaging descriptions, and Google’s Gemini models handle structured prompts well. Since model quality shifts as providers release new versions, the more reliable approach is to test: WP Sheet Editor – AI supports multiple providers, so you can compare output on a small batch of posts before committing to one for the full bulk run.
Can I use different prompts for different post categories or post types?
Yes. You can save multiple global prompts, each with its own slug. For example, you might have ai:seo-title-blog for blog posts and ai:seo-title-products for WooCommerce products. When working in the spreadsheet, filter by category or post type first, then apply the relevant prompt shortcut or bulk edit command. This approach keeps your metadata aligned with the content type and audience expectations of each section of your site.
Will this overwrite existing Rank Math SEO titles and descriptions?
Only if you explicitly apply the AI prompt to rows that already have values. The safest workflow is to filter for empty fields first, using the advanced search with the operator set to = and the value left blank. This ensures the AI only fills in gaps. If you intentionally want to regenerate metadata for posts that already have it, you can skip the filter, but you should preview the output carefully to confirm the new version is an improvement over the existing one.
You can sign up here:
Sign up to the WP Sheet Editor - AI Service - or - Check the features