n8n Workflow: Export WordPress Posts for SEO

Analyze WordPress Content Structure with n8n and Google Sheets

A few weeks ago, a digital marketing manager approached me with a challenge:

“We have hundreds of posts on our WordPress site, but no easy way to review which categories or tags are actually used. Can we automatically export everything into Google Sheets for analysis?”

That request inspired the Analyze WordPress Content Structure workflow - a simple, yet powerful automation for auditing your site’s taxonomy and content organization.

The Problem

For content managers and SEO teams, keeping track of categories and tags across dozens or hundreds of posts is tedious.
You often need to log in to WordPress, navigate between screens, or rely on third-party plugins that don’t quite match your reporting needs.

This workflow solves that by directly connecting to your WordPress REST API and automatically exporting all relevant post data - including mapped category and tag names — into a Google Sheet.
From there, you can easily review, filter, and optimize your site structure.

The Solution: n8n + WordPress REST API + Google Sheets

The workflow pulls all your WordPress content into one structured dataset using n8n’s automation power.
It connects to the WordPress REST API, fetches posts, categories, and tags, merges them, and sends the enriched data straight into a Google Sheet.

The result? A clear, spreadsheet-based view of your entire content taxonomy — ready for auditing or SEO optimization.

Who It’s For

• Content managers who need to audit and clean up categories or tags.
• SEO specialists looking to analyze content grouping and keyword alignment.
• Website owners who want an overview of how their WordPress site is organized.

What It Does

This workflow automatically:

• Connects to your WordPress REST API.
• Fetches posts, categories, and tags.
• Merges the data streams and maps category/tag names to each post.
• Exports everything into a Google Sheet for easy review.

You’ll get a simple and organized table of your website’s content structure, perfect for spotting inconsistencies or optimization opportunities.

How It Works

Here’s a detailed breakdown of the workflow:

1. Form Trigger
   You start by submitting a simple form with:

   • Your website URL
   • The number of posts to analyze

2. Fetch WordPress Data
   The workflow makes three API requests:

   • /wp-json/wp/v2/posts
   • /wp-json/wp/v2/categories
   • /wp-json/wp/v2/tags

3. Merge Data
   It combines the three datasets using the Merge node, linking posts with their corresponding categories and tags.

4. Code Transformation
   A Code node replaces category and tag IDs with their human-readable names, creating an enriched and clear dataset.

5. Google Sheets Export
   Each post is appended to your connected Google Sheet with columns:

   • URL
   • Title
   • Categories
   • Tags

6. Completion Form
   Once all data is exported, the workflow displays a confirmation message and a direct link to your Google Sheet.

If the WordPress API isn’t accessible, the workflow automatically returns an error message with troubleshooting tips.

Requirements

• A WordPress site with the REST API enabled (/wp-json/wp/v2/).
• A Google account connected to n8n with access to Google Sheets.
• A Google Sheet with the following columns in the first row:
  URL, Title, Categories, Tags.

How to Set Up

1. Import this workflow into n8n.
2. Connect your Google Sheets account using credentials.
3. Ensure your WordPress API is publicly accessible.
4. Adjust the Post limit (per_page) in the form node if needed.
5. Run the workflow and check your Google Sheet for the results.

How to Customize

• Add more WordPress data: Duplicate and modify the HTTP Request nodes to fetch additional endpoints like authors or comments.
• Change the destination: Replace Google Sheets with Airtable, Notion, or another integration.
• Extend metadata: Modify the Code node to include SEO details (meta descriptions, featured images, etc.).
• Schedule it: Add a Schedule Trigger node to refresh your content audit automatically (e.g., weekly).

Where Could You Find the Workflow

You can find this workflow in the (n8n Community Workflows)[https://n8n.io/workflows/10031-export-wordpress-posts-with-categories-and-tags-to-google-sheets-for-seo-audits/] It’s also shared on the n8n Community Forum, where you can view examples, import the .json file, and adapt it for your own site.

If you prefer self-hosting, you can import the workflow JSON directly from the GitHub repository (link coming soon) and connect your own credentials.

Do You Need Customization or Another Workflow?

If you’d like to:

• Analyze additional content elements such as authors or SEO metadata
• Automate weekly content audits
• Integrate the workflow with analytics tools like Looker Studio or Notion
• Or create an entirely new automation for your marketing or content operations

I can help you customize or develop a new workflow that fits your exact needs.
Reach out to discuss how we can streamline your WordPress or content management process using n8n.