Import All Your WordPress Posts to Google Sheets with SheetXAI

Overview

Overview

This guide shows the fastest way to pull your WordPress posts into a spreadsheet.

Once your posts are in Google Sheets, you can:

• audit titles, slugs, categories, and publish status
• bulk update content fields (at scale)
• run SEO workflows like internal linking, summaries, and updates

Prerequisites

• Your WordPress credentials are set up in SheetXAI settings (URL + username + application password).
  • See: /help/how-to-get-wordpress-credentials-for-sheetxai

How to import your posts

1) Open SheetXAI chat

In Google Sheets: Extensions → SheetXAI → Open Chat

2) Ask to import your posts

Example request:

• “import all my WordPress articles”

You can also use variations like:

• “Import all my WordPress posts”
• “Import only published posts”
• “Import all my WordPress posts including title, URL, slug, status, categories, and content”

3) Confirm what you want

Depending on your setup, SheetXAI may ask you to confirm:

• whether it should proceed (“yes, please go ahead”)
• which site to use (if you have multiple WordPress sites)
• where to put the results (typically a new sheet)

4) Review the imported sheet

SheetXAI typically creates a new sheet and fills it with your posts.

Common columns you’ll see (varies by what you ask for):

• Title
• URL / Permalink
• Slug
• Status (draft/published)
• Categories / Tags
• Content (or excerpt)
• Featured image / media fields (when requested)

Next steps (what to do after import)

• Bulk edits: ask SheetXAI to rewrite titles/meta/excerpts, clean formatting, or update categories.
• SEO workflows: generate summaries, find internal links, and push updates back to WordPress.

Troubleshooting

No new sheet appears

• Double-check WordPress is connected in Settings.
• If SheetXAI asks for confirmation, reply “yes” to proceed.