This tutorial is excellent. Brendan explains each stage very well, and even when I had made a mistake, he kindly took a look at work to try and figure out where I had gone wrong. got there in the end! I would highly recommend his videos
Wow Brendan - thank you so much for this! - in a few weeks I need to set up an import from Google Sheets to CPTs just like you show here. I was wondering how it was done - now I know!
Sir Can you please create a tutorial to use loops in custom API, so if we add multiple entries at once in google sheet it can be tracked and all row entries after the last one which is posted by ActivePiece gets posted in one run when the program triggers
I will try and do something on that soon. You can use the loop feature in activepieces to accomplish this, where it will import many records at once using the loop and create post option (and you can delete them the same way)
@@BrendanOConnellWP thankyou for your kind reply sir, but the loop is fetching only the latest available row even when we add get multiple rows option of GoogleSheets, which is fetching multiple rows but the loop is using the last row only , if possible help with tutorial
Areeee broo, am too stuck with the same problem, when am Adding the Get Next Row(s) it gets all the desired row but the same time the Loop on items uses only the last row of google sheets and that's why the loop runs only once, also there's a little confusion for API call where the data should now be send to API from Loop on Items instead of your trigger
Great video, once again Brendan! 😊 Did you find what was causing the query loop to not work as expected? Maybe because you did not actually select "Post" as the query source? Anyway, that was not the point of the video and I have learned a lot about Activepieces and REST API, so thank you!!! 😊
Thank you, hope it helps some folks. I haven't gone back to check but I think it's just that I had a secondary page layout that was overriding the brand new custom post archive template. But yeah didn't want to get distracted yet again (I already do that freely every day 😊)
Brendan, I am new to working with the Rest API. I see Activepieces can pull in custom fields of a custom post type. Can it grab only posts that have a specific Relationship? In other words, I have a CPT called Location. I want to only display CPT Events that are related to a specific Location? I am using the ACF Relationship field to create this relationship.
it should be able to pull in any data that can be fed in via JSON, so arrays should work as well. I havent had a chance to mess around with it much yet. Let me know if you end up trying it. I suspect it should work fine.
@@BrendanOConnellWP will do. I may be trying out WP Get API plugin. Most likely I will be contacting them to see if their plugin can do it. I’m a ways away from actually doing it… I’m building the host site I want to pull from. So if I need to change the architecture of the host site, now is the time to know / change it.
@@BrendanOConnellWP have not tried it yet. I am going down the RSS feed rabbit hole now. I prefer this route since it can be used by anyone. Even low tech people. If I cannot do what I need with RSS feeds, I will go down the WP Get API plugin route.
yes it will do all body content and images i believe. if you mean writing blog content, it can also do that with adding in gpt to the flow it can rewrite your blog posts and repost them on your other sites. lots of possibilities! thanks for watching!
awesome can you show us a creating a template and how can we use that to create pages using google sheets and active-pieces please if possible . thanks again for this video
@@BrendanOConnellWP lets say i want to do programatic seo with google sheet records to create a product reviews like url, content within parts like (product description, how can it help , who can benefit from product, pros and cons ,how to use . product specification) and finally summary and FAQs
@@codemasterdevops OK, yes I can try something like that like. I do that for Service area pages, category pages, and singles of each with Bricks templates, so you can import say 200 cities and all 50 states and have it build out using one template and then rendering dynamic data per city name, info per city, etc. You can sell this to clients for sure, and you can set up monthly packages where you add X number of cities, in this example. i'll try and put something together without making it super long
yeah i believe you can, dang i should have added that. i did it from that same spreadsheet - it was importing the google business images, so the images i think need to be in a URL format. only problem is trying to bring in data directly from other sites API (like i did in the part 1) because I believe WP has to have the media in the folder already. i think there can be a step to the flow added right before to do a api request on posting to media folder, then mapping to the posts. maybe i'll do this in part 3, cuz there's some things left to test as you mentioned
@@rubengarciajr i have a client that needs this right now too so if i remember, i'll report back how i do it. where are the images currently? can they be fetched independent of WP and then added to the flow upload step?
How do you delete or update custom post types this way? For example, if America's Advantage Remodeling also had a repeating field of sale items that changed weekly, how would you remove the old sale items and add the new sale items?
I used GET to get the data, and POST to create new data. You can use the actions of PUT to edit/update data and DELETE to delete them. GET POST PUT DELETE are the common features of HTTP
@@BrendanOConnellWP Thanks so very much. While there are about 3 quadrillion channels showing the basic and intermediate stuff about WordPress, I can find very few that explain the more in-depth stuff in a simple manner. Thanks for the videos!
I've got this working for PATCH and PUT methods to update data in real time from external sheets into WP Custom fields. You can do the same WooCommerce but its a little more involved, and you can't rest api edit the original price field, only the sale price. are you using Woo?
I am using the Cloud version here. You can do quite a lot with the free cloudplan (1000 tasks a month) and each 1000 are $1 more. I have installed it self hosted but didn't get it finished. might try again, but the cloud is maybe cheaper than self-hosting at least initially
@@AIWithMohammed havent used zapier in a long time. it looks like this is similarly priced to Make (around $1/1000 tasks). I think either can work for you. Take a look at the integrations - if make has 1 you definitely need check it out. You can usually custom call into anything though, so just pick the one that looks easiest to learn and maintain and sell to potential clients.
if you dont mind setting it up, you can host activepieces and have unlimited tasks yourself. there are several quick install options with docker i believe. otherwise the cloud and pay-as-you go pricing for tasks, seems pretty appealing vs committing to a monthly subscription and have tasks you arent using.
Hi Brendan, I am a beginner but I hope to make my question understandable. I need to implement a procedure to capture preregistration from my target audience. Since this is a business critical activity I need to build something solid so, I am wondering if procedures that make use of system calls are more prone to fail resulting in users being unable to register. My service is restricted to a specific category of organizations that must be mandatorily registered in a category registry. The body that governs the registrations to the register releases a cumulative dataset (old and new registrants) on Excel on a monthly basis. Today there are about 130k rows with an estimated growth to 280k. The following is a description of the structure and capture process that I have planned to implement and on which I am asking your opinion. The dataset converted to CSV will populate a CPT with custom fields mirroring the dataset's columns header, to which I will add a field to collect the email and a field to identify which and how many users are actually registered. I was thinking of using a checkbox field. The CPT will feed a form made with WS Form. The user will enter the social security number (I will use a select field with the Select2 search feature enabled. If the match is positive, it means the user is qualified for registration, so he/she will enter the email address, give GDPR consent, and complete the registration. With this procedure WS For will write the new information into the CPT. I need to projecting a solution for organizations that have applied for albo registration and since the process takes 30gg, I may have eligible users (very likely) for whom the tax code match will fail because my excel is not up to date. In conclusion, could you please give me your opinion and tell me if you would recommend for my case the solution shown in the tutorial? Many thanks
this sounds doable with the method shown in this vid to populate the CPT, then webhooks from WSForm and apis calls to the sheet to search by the input fields. I see no reason this can't be done except perhaps GDPR concerns? I think all these tools mentioned are GDPR compliant, but i'm not an expert. Do you have the automation tool already in line? That could get pricey if youre paying per automation. Might be better to self host, which also eliminates most GDPR concerns as well i believe. let me know if this tracks or send me an email and we can discuss further. As for "I am wondering if procedures that make use of system calls are more prone to fail resulting in users being unable to register." I'm not entirely sure what that refers to?
Excellent tutorial, I have a question about the integration, for some reason it is possible to create the posts correctly from the Google Sheet, however every time a post is created in WordPress (Which is being created from the Google Sheet), I also get it creates in Google Sheet, how can I avoid this behavior?
Thanks for your video if the type of the custom post type field is not a text is not working like if i use a select or links or WSWIG is not working But when the type a just text is working do you know how to correct this ?
Yes the ACF text fields will strip out any html like links or headings/lists, etc. What is the data stored in? Some spreadsheets don't accept markup or html? Could try airtable. Can you try a wysiwyg field in acf instead of text field and try import again?
Yes definitely better ways to do this type of thing. I've been trying to check out headless more, but it's a lot to undertake. i'd like to eventually get into it more
This tutorial is excellent. Brendan explains each stage very well, and even when I had made a mistake, he kindly took a look at work to try and figure out where I had gone wrong. got there in the end! I would highly recommend his videos
Another great video Brendan. Loving this series - really useful and lots of potential for various applications. thank you.
Great to hear! Hope you found something useful. Thanks
Awesome! Thanks for walking us through the entire process.
Thanks, I hope it made sense!
Wow Brendan - thank you so much for this! - in a few weeks I need to set up an import from Google Sheets to CPTs just like you show here. I was wondering how it was done - now I know!
happy to share! REST API is a fantastic tool. thanks for watching. Hope you are successful w/ your import... Let me know if you have any questions!😀
Sir Can you please create a tutorial to use loops in custom API, so if we add multiple entries at once in google sheet it can be tracked and all row entries after the last one which is posted by ActivePiece gets posted in one run when the program triggers
I will try and do something on that soon. You can use the loop feature in activepieces to accomplish this, where it will import many records at once using the loop and create post option (and you can delete them the same way)
@@BrendanOConnellWP thankyou for your kind reply sir, but the loop is fetching only the latest available row even when we add get multiple rows option of GoogleSheets, which is fetching multiple rows but the loop is using the last row only , if possible help with tutorial
Areeee broo, am too stuck with the same problem, when am Adding the Get Next Row(s) it gets all the desired row but the same time the Loop on items uses only the last row of google sheets and that's why the loop runs only once, also there's a little confusion for API call where the data should now be send to API from Loop on Items instead of your trigger
Great video Brendan!
thank you my friend!
Thanks for the tutorial. Very helpful. Please do more like this :)
Thanks for watching. What do you want to automate
excellent Brendan
Glad you enjoyed! You think of a good use case for your projects?
Great video, once again Brendan! 😊 Did you find what was causing the query loop to not work as expected? Maybe because you did not actually select "Post" as the query source? Anyway, that was not the point of the video and I have learned a lot about Activepieces and REST API, so thank you!!! 😊
Thank you, hope it helps some folks. I haven't gone back to check but I think it's just that I had a secondary page layout that was overriding the brand new custom post archive template. But yeah didn't want to get distracted yet again (I already do that freely every day 😊)
Brendan, I am new to working with the Rest API. I see Activepieces can pull in custom fields of a custom post type. Can it grab only posts that have a specific Relationship? In other words, I have a CPT called Location. I want to only display CPT Events that are related to a specific Location? I am using the ACF Relationship field to create this relationship.
it should be able to pull in any data that can be fed in via JSON, so arrays should work as well. I havent had a chance to mess around with it much yet. Let me know if you end up trying it. I suspect it should work fine.
@@BrendanOConnellWP will do. I may be trying out WP Get API plugin. Most likely I will be contacting them to see if their plugin can do it. I’m a ways away from actually doing it… I’m building the host site I want to pull from. So if I need to change the architecture of the host site, now is the time to know / change it.
@@JohnChvatalGSTV Let me know what you think of WPGETAPI. It's been on my mind to try it.
@@BrendanOConnellWP have not tried it yet. I am going down the RSS feed rabbit hole now. I prefer this route since it can be used by anyone. Even low tech people. If I cannot do what I need with RSS feeds, I will go down the WP Get API plugin route.
Coool! Is there a way to do a much longer content like a blogpost?
yes it will do all body content and images i believe. if you mean writing blog content, it can also do that with adding in gpt to the flow it can rewrite your blog posts and repost them on your other sites. lots of possibilities! thanks for watching!
awesome can you show us a creating a template and how can we use that to create pages using google sheets and active-pieces please if possible . thanks again for this video
Can you give me more info on what you mean exactly?
@@BrendanOConnellWP lets say i want to do programatic seo with google sheet records to create a product reviews like url, content within parts like (product description, how can it help , who can benefit from product, pros and cons ,how to use . product specification) and finally summary and FAQs
@@codemasterdevops OK, yes I can try something like that like. I do that for Service area pages, category pages, and singles of each with Bricks templates, so you can import say 200 cities and all 50 states and have it build out using one template and then rendering dynamic data per city name, info per city, etc. You can sell this to clients for sure, and you can set up monthly packages where you add X number of cities, in this example. i'll try and put something together without making it super long
Thank you very much looking forward for this video.I am struggling with this and it would be a great help for me .
this is a really good video, the only question, can you import images this way???
yeah i believe you can, dang i should have added that. i did it from that same spreadsheet - it was importing the google business images, so the images i think need to be in a URL format. only problem is trying to bring in data directly from other sites API (like i did in the part 1) because I believe WP has to have the media in the folder already. i think there can be a step to the flow added right before to do a api request on posting to media folder, then mapping to the posts. maybe i'll do this in part 3, cuz there's some things left to test as you mentioned
i need this for a client to update two websites at the same time but the images were the annoying part lol
@@rubengarciajr i have a client that needs this right now too so if i remember, i'll report back how i do it. where are the images currently? can they be fetched independent of WP and then added to the flow upload step?
How do you delete or update custom post types this way? For example, if America's Advantage Remodeling also had a repeating field of sale items that changed weekly, how would you remove the old sale items and add the new sale items?
I used GET to get the data, and POST to create new data. You can use the actions of PUT to edit/update data and DELETE to delete them. GET POST PUT DELETE are the common features of HTTP
@@BrendanOConnellWP Thanks so very much. While there are about 3 quadrillion channels showing the basic and intermediate stuff about WordPress, I can find very few that explain the more in-depth stuff in a simple manner. Thanks for the videos!
@@myboringdesktop Let me know if you find more, I am looking for those as well
@@BrendanOConnellWP Will do. I may make a few if I can't find them.
I've got this working for PATCH and PUT methods to update data in real time from external sheets into WP Custom fields. You can do the same WooCommerce but its a little more involved, and you can't rest api edit the original price field, only the sale price. are you using Woo?
Are you using the cloud version of active pieces or self hosted
I am using the Cloud version here. You can do quite a lot with the free cloudplan (1000 tasks a month) and each 1000 are $1 more. I have installed it self hosted but didn't get it finished. might try again, but the cloud is maybe cheaper than self-hosting at least initially
@@BrendanOConnellWP worth getting this vs make or zapier
@@AIWithMohammed havent used zapier in a long time. it looks like this is similarly priced to Make (around $1/1000 tasks). I think either can work for you. Take a look at the integrations - if make has 1 you definitely need check it out. You can usually custom call into anything though, so just pick the one that looks easiest to learn and maintain and sell to potential clients.
if you dont mind setting it up, you can host activepieces and have unlimited tasks yourself. there are several quick install options with docker i believe. otherwise the cloud and pay-as-you go pricing for tasks, seems pretty appealing vs committing to a monthly subscription and have tasks you arent using.
Thanks for the video.
Is there a way to trigger a one shot import instead of a recurring one every n minutes?
Hi Brendan, I am a beginner but I hope to make my question understandable.
I need to implement a procedure to capture preregistration from my target audience.
Since this is a business critical activity I need to build something solid so, I am wondering if procedures that make use of system calls are more prone to fail resulting in users being unable to register.
My service is restricted to a specific category of organizations that must be mandatorily registered in a category registry. The body that governs the registrations to the register releases a cumulative dataset (old and new registrants) on Excel on a monthly basis. Today there are about 130k rows with an estimated growth to 280k.
The following is a description of the structure and capture process that I have planned to implement and on which I am asking your opinion.
The dataset converted to CSV will populate a CPT with custom fields mirroring the dataset's columns header, to which I will add a field to collect the email and a field to identify which and how many users are actually registered. I was thinking of using a checkbox field.
The CPT will feed a form made with WS Form. The user will enter the social security number (I will use a select field with the Select2 search feature enabled. If the match is positive, it means the user is qualified for registration, so he/she will enter the email address, give GDPR consent, and complete the registration. With this procedure WS For will write the new information into the CPT.
I need to projecting a solution for organizations that have applied for albo registration and since the process takes 30gg, I may have eligible users (very likely) for whom the tax code match will fail because my excel is not up to date.
In conclusion, could you please give me your opinion and tell me if you would recommend for my case the solution shown in the tutorial?
Many thanks
this sounds doable with the method shown in this vid to populate the CPT, then webhooks from WSForm and apis calls to the sheet to search by the input fields. I see no reason this can't be done except perhaps GDPR concerns? I think all these tools mentioned are GDPR compliant, but i'm not an expert. Do you have the automation tool already in line? That could get pricey if youre paying per automation. Might be better to self host, which also eliminates most GDPR concerns as well i believe. let me know if this tracks or send me an email and we can discuss further. As for "I am wondering if procedures that make use of system calls are more prone to fail resulting in users being unable to register." I'm not entirely sure what that refers to?
@@BrendanOConnellWP Hi Brendan, I sent you an email with the subject: YT follow up
Excellent tutorial, I have a question about the integration, for some reason it is possible to create the posts correctly from the Google Sheet, however every time a post is created in WordPress (Which is being created from the Google Sheet), I also get it creates in Google Sheet, how can I avoid this behavior?
are you using activepieces? do you have an action in google sheets to create a new row? you shouldn't need to duplicate that
Thanks for your video
if the type of the custom post type field is not a text is not working like if i use a select or links or WSWIG is not working
But when the type a just text is working do you know how to correct this ?
Yes the ACF text fields will strip out any html like links or headings/lists, etc. What is the data stored in? Some spreadsheets don't accept markup or html? Could try airtable. Can you try a wysiwyg field in acf instead of text field and try import again?
We need a WEB CAM!!!
🤨 do we?
WP headless? Or not, drop google sheets and use Supabase! WAYYYYY more functionality then using an insecure google sheet.
Yes definitely better ways to do this type of thing. I've been trying to check out headless more, but it's a lot to undertake. i'd like to eventually get into it more