Publish blog drafts faster without copy paste work. Content teams and solo writers can push posts from Airtable into WordPress on a schedule, add a featured image, and track status in one place.

A timed trigger checks Airtable for items marked To Post. Records pass a filter so you do not repost the same article. Key fields are prepared, then the blog body is converted from markdown to clean HTML. A draft is created in WordPress with the title and content. Next, the flow searches Pexels using the keyword, downloads the image, uploads it to WordPress media, and sets it as the featured image for that post. Finally, the Airtable record is updated with the WordPress post ID and new status. This end to end chain removes busy work and keeps both tools in sync.

You need an Airtable base with Title, Keyword, and blog content, a WordPress site with application password access, and a Pexels API key. Expect to cut publish time for each post and reduce errors from manual steps. Helpful for teams running AI generated drafts, agencies managing many sites, and marketers scheduling content in batches.

• Scheduled runs pull new records from Airtable using a To Post status filter.
• Duplicate control with a filter step so existing posts are not published again.
• Field prep with a Set node to map Title Keyword and IDs for later steps.
• Markdown to HTML conversion so content is ready for WordPress formatting.
• Draft creation in WordPress with title and HTML body.
• Keyword based image search on Pexels through an HTTP request with API key.
• Image download and binary handling so media uploads correctly.
• Media upload to WordPress with the right headers and file naming.
• Featured image assignment on the published draft using the media ID.
• Write back to Airtable with the WordPress post ID and updated status.

• Reduce manual posting from 30 minutes per post to about 5 minutes
• Automate 90 percent of repetitive steps across writing and upload
• Cut publish errors by 80 percent by removing copy paste work
• Handle up to 10 times more posts per week with the same team
• Connect Airtable WordPress and Pexels in one consistent flow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with WordPress, Airtable and Pexels. See the Tools Required section above for links to create accounts with these services.
3. In Airtable, create a table with fields Title, Keyword, Blog Body and Status. Add a few sample rows and set Status to To Post for items you want to publish.
4. Open the Get content to post node. In the n8n credentials manager, create an Airtable credential. Choose Create new credential, then follow the on screen steps. Use your Airtable API key or OAuth as prompted.
5. Confirm the Airtable Base and Table match your setup. Keep the filter formula SEARCH("To Post", {Status}) so only ready items are pulled.
6. Open the Filter by existing Blogs node and adjust conditions to match how you mark already published items. This prevents reposts.
7. Open the Post on WordPress, Upload Media, and Set Featured Image nodes. In each, create or select a WordPress credential. Use your site URL and an application password or basic auth as supported by your site.
8. Open the Get Image node. Add your Pexels API key in the Authorization header. Create the key in your Pexels account and paste it exactly as required.
9. Check field mapping: Edit Fields should pass Title and Keyword. Markdown to HTML should write to Blog Body so the WordPress post uses HTML content.
10. Set the Schedule Trigger to the run rate you want, for example every day or every hour.
11. Run once manually to test. Confirm a draft appears in WordPress with the HTML body, the featured image is set, and the Airtable row updates with the post ID and new status.
12. If you see 401 or 403 errors, recheck WordPress or Pexels credentials. If media upload fails, confirm the binary field name is data and headers like content type are set. Make sure the WordPress API URL in Set Featured Image points to your site.
13. When tests pass, turn on the workflow so it runs on the set schedule.