Wordpress

WordPress is one of the most widely used content management systems in the world, powering everything from personal blogs to enterprise websites. With Coupler.io, you can pull your WordPress site's content, users, media, and more into your preferred destination for reporting, analysis, or automation.

Why connect WordPress to Coupler.io?

• Centralize your content data — pull posts, pages, comments, and media into Google Sheets, BigQuery, or any other destination without manual exports

• Track content performance over time — combine WordPress data with analytics sources to see what's driving traffic and engagement

• Automate reporting — keep stakeholders updated with fresh WordPress data on a schedule you control

• Use AI to analyze your content — send posts or comments to ChatGPT, Claude, Gemini, or other AI destinations for summarization, tagging, or sentiment analysis

Prerequisites

• A WordPress site with the REST API enabled (enabled by default on WordPress 4.7+)

• An Application Password generated from your WordPress user profile (go to Users → Profile → Application Passwords in your WordPress admin)

• Your WordPress site URL

• Your WordPress username

Coupler.io connects to self-hosted WordPress sites via the REST API. WordPress.com hosted sites may have different API access rules. If your site is behind a firewall or CDN like Cloudflare, you may need to whitelist Coupler.io's IP addresses.

Quick start

If you want to export WordPress posts to Google Sheets for editorial tracking or content reporting, start with the Posts entity — it's the most commonly used and gives you the richest dataset right away.

1

Create a new data flow in Coupler.io and select WordPress as your source.

2

Enter your credentials. You'll need your WordPress site URL (e.g., https://yoursite.com), your WordPress username, and the Application Password you generated from your user profile. Note that Application Passwords are different from your login password — make sure you're using the one from the Application Passwords section.

3

Select an entity to import. Choose from Posts, Pages, Comments, Users, Media, and more. See the table below for the full list.

4

Choose your destination — Google Sheets, Excel, BigQuery, Looker Studio, or an AI destination like ChatGPT or Claude for content analysis.

5

Run the data flow manually to confirm everything is working before setting up a schedule.

Available entities

Entity	What it contains
Posts	Published and draft blog posts with metadata
Pages	Static site pages and their content
Page revisions	Version history for pages
Comments	Reader comments with author and status info
Users	Registered users and their roles
Categories	Post categories and hierarchy
Tags	Post tags
Taxonomies	Custom taxonomy definitions
Types	Registered post types
Media	Uploaded files and image metadata
Editor blocks	Gutenberg block definitions
Plugins	Installed plugins and their status
Themes	Installed themes
Statuses	Available post statuses
Settings	Site-level settings