Airtable logo
WordPress
Import and sync data in Airtable

Connect Airtable and WordPress

Import posts, pages, comments and more using a simple no-code API integration. Sync data from WordPress and thousands of other apps into Airtable automatically with Data Fetcher.

Trusted by leading Airtable teams

IBM Logo
Amazon Logo
Warner Records Logo
Harvard Logo
Stanford Logo
NBA Logo
Time Logo
DraftKings Logo

The no-code solution for connecting WordPress to Airtable

It takes just 4 simple steps to get up and running with Data Fetcher’s no-code imports into Airtable

Step 1

Add the Data Fetcher extension

Get started with WordPress in Airtable by adding the Data Fetcher extension from the Airtable Marketplace. Create your free account directly within the extension after installation.

Add the Data Fetcher extension
Step 2

Connect to WordPress

Select the pre-built WordPress integration from our library. Data Fetcher handles all the technical API details, so you can connect without writing a single line of code.

Connect to WordPress
Step 3

Map the fields

Select which WordPress data fields you want to import and map them to your existing Airtable fields. Choose how new data should merge with existing records in your base.

Map the fields
Step 4

Automate your WordPress data sync

Keep your Airtable data fresh by scheduling automatic updates at any interval. You can also trigger syncs from WordPress when records change in your Airtable base.

Automate your WordPress data sync

About the tools

WordPress logo

WordPress

WordPress is a versatile content management system powering over a third of websites worldwide. It offers an intuitive interface for creating digital content while providing extensive customization through thousands of themes and plugins. The platform supports everything from simple blogs to complex e-commerce stores with robust media handling. WordPress balances accessibility for beginners with advanced capabilities for developers, making it suitable for projects of any size.

Airtable logo

Airtable

Airtable blends spreadsheets and databases, enabling organized, collaborative workflows. It features customizable templates, multiple viewing options like grid, calendar, and kanban boards, plus powerful data types. With integration capabilities, automation tools, and team collaboration features, Airtable helps businesses of all sizes manage projects, content planning, and data without technical expertise.

Data Fetcher logo

Data Fetcher

Data Fetcher is an Airtable extension that connects your bases with external data sources and APIs. Users can pull data from REST APIs and external systems without writing code. With support for automic syncs, data transformation and mapping, Data Fetcher helps businesses make Airtable their source of truth for all their third-party data. It acts as the missing connection between WordPress and Airtable.

How to Connect WordPress to Airtable

In this simple tutorial, we'll demonstrate how to integrate WordPress with Airtable using an Airtable extension called Data Fetcher. We'll use Data Fetcher to import WordPress blog posts into Airtable with no-code. We'll also schedule this to happen automatically.

Add Data Fetcher to Airtable

Add Data Fetcher to a new Airtable base via the Airtable marketplace. Sign up for a Data Fetcher account by entering a password and clicking 'Sign up for free'. Alternatively, you can use your Google login to create a new account. If you already have a Data Fetcher account use the 'Have an account?' text in the bottom left of the screen to log in.

Data Fetcher is a powerful Airtable extension that can be used to import different types of data from APIs or websites into Airtable.

Data Fetcher Sign Up

Import Wordpress Data to Airtable

Creating requests in Data Fetcher enables you to import data into your Airtable base. To begin, click 'Create your first request' on the home screen of the Data Fetcher extension.

Create your first request in Data Fetcher

For Application, select 'Custom' to set up the WordPress Airtable integration.

wordpress-airtable-1.jpg

Next, enter the URL of the WordPress post you would like to import data from using this format: https://your-site.com/wp-json/wp/v2/categories?context=embed (where your-site.com is replaced by the URL of your post.) 

Or for this example, you can use this URL: https://techcrunch.com/wp-json/wp/v2/posts?context=embed

By adding ?context=embed to the end of the URL, it means we get an overview of the article rather than all the text from the page. 

wordpress-airtable-2.jpg

Optional: Adding Pagination

Our WordPress posts response will be split into separate 'pages'. This is called pagination. If you want to add pagination to your WordPress request and import all the pages, you can do this by scrolling down and opening the Advanced settings in Data Fetcher.

Scroll to Pagination and select 'Page' as well as the following options:

  • number of pages: '3'
  • ⁠Page parameter: 'page'
  • Page size parameter: 'per_page'
  • Page size: '100'.
wordpress-airtable-4.jpg

You can give your request a name, such as 'Import WordPress Data' and click 'Save & Run'.

wordpress-airtable-3.jpg

The Data Fetcher request will run, and the Response field mapping modal will open. This is where we select which fields of data will be imported from WordPress to Airtable and how they will map to our output table. 

Select 'Filter all' to clear all the pre-selected fields, and use the Find field search bar to locate and select the following fields: 'Date', 'Slug', 'Link' and 'Title rendered'.

These will all map to new fields in our Airtable base.

Click 'Save & Run'.

wordpress-airtable-5.jpg

You'll now see that new fields have been created in Airtable and populated with our WordPress data.

wordpress-airtable-6.jpg

Importing Different Types of Data from WordPress

You can also import different types of data from WordPress into Airtable using other endpoints and query strings.

For example, to import categories:

https://your-site.com/wp-json/wp/v2/categories

Comments:

https://your-site.com/wp-json/wp/v2/comments

Or pages:

https://your-site.com/wp-json/wp/v2/pages

You can find a full list of WordPress endpoints in the WordPress REST API reference.

WordPress to Airtable Authentication

For this example, we are not using authentication, which means we can only access public WordPress API endpoints. If we want to access a private endpoint, which requires login details, for example, draft WordPress posts, we can install a plugin like WordPress REST API Authentication.

This will give us an API key that we can add to our request as a bearer token.

Automatic WordPress Airtable Integration

Currently, you'd need to manually run the request each time you want to import any new data from your WordPress post. It is however possible to automatically run the WordPress Airtable integration on a chosen schedule using Data Fetcher's paid scheduling feature.

To upgrade your account, In Data Fetcher, scroll to Schedule and click 'Upgrade'.

schedule options

Choose a plan from the different options depending on your needs and enter your payment details.

data fetcher upgrade pricing plans.png

In Data Fetcher, click 'I've done this'.

Schedule Data Fetcher

Under Schedule click '+ Authorize'.

Schedule Data Fetcher

A window will open where you'll be prompted to authorize the Airtable bases you want Data Fetcher to have access to.

We recommended selecting 'All current and future bases in all current and future workspaces' to avoid needing to unauthorize bases in the future.

Click 'Grant access'.

schedule-authorize-bases.jpg

In Data Fetcher, you'll see Schedule this request is now toggled to on.

Select a schedule for the WordPress Airtable integration to run. You can choose intervals of 'Minutes', 'Hours', 'Days' or 'Months', then click 'Save'.

Schedule this request

Now, if changes are made to the WordPress post this will be imported into Airtable automatically on your chosen schedule.

Ready to connect WordPress to Airtable?

Start syncing your data sources with Airtable today.