Create WordPress users from Airtable

In this guide, we’ll walk you through the steps to import and sync users from your Airtable base into your WordPress website using the Air WP Sync plugin. With this feature, it is now possible to create WordPress accounts directly from Airtable, simply by mapping your table content with WordPress user properties.

Setting up your Airtable base

Before diving into the synchronization process, make sure that your Airtable base contains column properties that align with WordPress user properties.

You can set up the following columns:

• Username
• First Name
• Last Name
• Nickname
• Website Url
• Email
• Biographical Info
• Role
• Locale

❗Warning: The “Username” and “Email” fields are mandatory, while others are optional.

Connecting Airtable to WordPress

1. Log in to your WordPress dashboard.
2. Navigate to the Air WP Sync plugin, listed on the left-hand side menu.
3. Click on the “Create a new connection” button.
4. Enter your Airtable API access token.
5. Choose your Airtable base, table, and view (optional).

Setting Up Users Import

1. Select “User” in the “Import as” Dropdown menu.
2. Define the default role for the imported users.

Email Configuration (Optional)

Activate the “send email” option. When enabled, it sends an email alert to users upon syncing, prompting them to set up their account password.

Mapping Airtable Fields with WordPress

While editing your connection in Air WP Sync plugin, you will find the “Field Mapping” section.

In this section:

1. Choose an Airtable Field: From the dropdown menu, you’ll select which field in your Airtable base you want to synchronize to WordPress. For instance, if you have a column named “First Name” in Airtable, you’d start by selecting that.
2. Select a WordPress user property: After choosing your Airtable field, you’ll match it to a corresponding property or field in WordPress where you want that data to appear. If you selected “First Name” from Airtable, you’d map it to the “First Name” field in WordPress.
3. Repeat Steps 1 and 2 for Each Field: Ensure you go through each field in Airtable that you want to synchronize, mapping it to its corresponding WordPress property.

After mapping your Airtable fields to the corresponding WordPress user fields, click on “Update“, followed by “Sync now” to import user data from Airtable.

Reviewing Imported Users

1. In the WordPress dashboard, select “Users” from the side menu.
2. The list displays all users imported from your Airtable base.

Reviewing User Details

For a more granular view, click on an individual user. You’ll see a complete profile with all the synced data from Airtable.

Scribe Tutorial (Summary)

In this Step-by-Step Scribe tutorial, we explain how to synchronize WordPress users from your Airtable base.

To do so, follow these simple steps :