boconnell
on
May 8, 2024

Automate ACF Custom Posts & Fields from Google Sheet with REST API & Activepieces For FREE

Video Tutorial
  1. Understanding sources
  2. Create Custom Post Types
    • Turn ON REST API in advanced settings
    • contractor-directory (or any new/custom or existing post directory appended to wp-json/wp/v2/
  3. Create Custom fields
    • Turn ON REST API in advanced settings
    • Keep track of your custom fields name (including the _ if 2 words for example street_address)
  4. Install JSON Plugin
  5. Activepieces
    • Decide on trigger (in this case, schedule every minute)
    • Add Google Sheets, authenticate, and decide on method. ‘Get Next Group of Rows’ works well
    • Authenticate WP in Activepieces
    • Add JSON body, post status in the custom API post
    • Test Data push
{
"title": "",
"content": "",
"acf": {
"street_address": "",
"city": "",
"state": "",
"website_url": "",
"phone": ""

}
}

Brendan O'Connell

Brendan is a longtime WordPress user and has built and managed hundreds of websites over the last decade.

Recent Posts

You're still here? Wow, dedication. Here are some of my latest ramblings.

I am a heading

If you’re curious, this is Website Ipsum. It was specifically developed for the use on development websites. Other than being less confusing than other Ipsum’s, Website Ipsum is also formatted in patterns more similar to how real copy is formatted on the web today.

  • This is a list item.
  • This is a list item.
  • This is a list item.

No spam, ever.

Get (in)frequent updates

I'll level with you - if your inbox is anything like mine, you will appreciate how I will never email you.

Sign up if you want to get early access/discounts for new courses, cool tools, and other freebies.