Google Sheets to WordPress Custom Post Types with REST API
Vložit
- čas přidán 21. 07. 2024
- Last time we made an API to show Google Sheet records in our #Wordpress website using #JetEngine REST API but today we will directly insert our sheet data as CPT or CCT in Wordpress.
Google Apps Script:
softemblems.com/google-sheets...
Topics:
00:00:00 Introduction & Demo
00:01:35 Creating Custom Post Types
00:02:25 Insert CPT using Postman
00:04:33 REST API Authorization
00:05:50 Google App Script Code
00:09:00 Setup Trigger
Download #Elementor:
elementor.com/?ref=16401
Download #Crocoblock:
crocoblock.com/?ref=4088
Need to build dynamic websites?
softemblems.com
Track: Peruvian Woods - Dave Osorio [Audio Library Release]
Music provided by Audio Library Plus
Watch: • Peruvian Woods - Dave Osorio | Free B...
Free Download / Stream: alplus.io/peruvian-woods - Věda a technologie
This is awesome, please do more of these tutorials on JetEngine, i think you are one of the best devs on this topic. Cheers!
Thank you, keep coming :)
Great tutorial, as always. You show the real power of JetEngine, thank you so much and keep going. :)
This is a great tutorial, would be great to see more posts like this in the future
Sure, will cover them..
your tutorials are great, so useful and nothing else like them.
Thank you
Excellent video and instruction - Thank you for sharing.
Nice video as always! It would be nice if you could do a video how to optimize a WordPress website, especially a website with crocoblock plugins
Perfect ! .. i will test this
This is awesome, thank you
Thank you for the useful tutorial. A featured image tutorial would be nice
You can check these documentation for image
stackoverflow.com/questions/63830915/read-images-from-system-or-url-using-google-apps-script-in-google-sheets-and-pos
Very good content :)
awesome sir. keep it up
Thank you very much, very useful! With the setup you show in the video, If you update or create a post (Lead) from WP will it be shown in GSheets? Thanx again
Nope, its one way sync
Great tutorial!
I have a question. How I can add terms to the post from this sheet to WP? Thanks in advance for your answer.
@Moxet Khan Great to learn something new.
Hello! How can I pass data as select field, or checkbox field instead of text field on JetEngine post types?
I love your tutorials, do you think is possible to do it with cct? maybe some advise on how to do it? thanks!
Thank you, it has same concept, CCT also provides endpoints.
Thank you, brother Moxet Khan, for your excellent tutorials.
I have a question for you:
Is it possible to replace the date field used in JetFormBuilder with the bootstrap-datepicker or any other service so that it appears uniformly across all browsers?
Thank you for your fantastic efforts!
Yes possible but you need to contact crocoblock support to give you the right direction. Worst case scenario you can use jquery.
Excelente tutorial, me sirvió mucho. Sería genial un plugin que haga esa conexión. Pero como crear el postman mi propio? no entendi la integración con wordpress
Do I need to perform any other configuration to generate the ID via macro? Or add some other permission... Everything worked perfectly in Postman
Make sure your code run onChange event so the time you type and leave the cell it will trigger the API and insert ID
Good Day Master Moxet, is it possible to use jetform builder vice versa? if you edit the fields via form , is there a possible way to sycnhronize post types and googlesheet? this googlesheet method is one of the best way to import or update post types, but what if i want to update post type via form, and it will also update the googlesheet data, if you have tutorials can you share it with us?
How to add meta repeater field data so that it works without errors? I tried many options but it doesn't help
Thank you! Would you mind showing how to use other meta fields than textfield - say for example checkbox?
Well for each type we need to pass data accordingly, for example checkbox accept direct value, switcher should be true or false and date should be date format and so one. Please try sending meta["checkbox_meta"]="pre-set-check-box-value"
Will try! Thanks! And...do you know a way to change the slug of the page with a column that is not Post Title? @@MoxetKhanPK
Basicly - when the post title is the same for many posts I dont want it to be /marketingoffer2, /marketingoffer2 etc. So a way to easily customize it. Hope you understand what I mean :)
@@kevinwedin4293 Yes you can have unique slugs as per the documentation here. developer.wordpress.org/rest-api/reference/posts/#schema-slug
So good thanks! Another question: I have created two CPT - "Education programs" and "Cities". So I have like 800 programs and 150 cities. Is there a way on the CPT for cities, when I create the single post template, to in the listing grid connect each "cities" that I have as a texonomy on the "educations" CPT? I know I could yous the cities taxonomy as a page - but I dont think its optimal in SEO-terms. @@MoxetKhanPK
I wanted to learn about hooks , how to create php functions like you did for enail code validation to update check , crocoblock the best way
What source you would recommend me
i know elementor , figma designs
I am learning dyanmic features for wordpress using crocoblock
This is amazing! In App Script, what type of deployment do I need to select? There is 4 options: Web App, API Executable, Add-on and Library. Thank you for your training video.
I figured out my question. A great addition to this video would be field mapping and how to build out your page or post with this data from a UI perspective.
@@popopp2297 That is the most simplest thing, once you transfer CPT from Google to Worpdress the rest of the methodology is similar, there are dozens of tutorial covers how to design the UI.
Can we connect over email? Have some custom project.
Hi friend. Greetings from Peru. You are big. I have a question. Can you relate to an author (user) from Google Sheets?, since said post has to be related to an author (user).
What about other tabs inside of google sheet? How does that work? If I want to create a food menu and want to use cct and create another field with Food type or Drink type, and that field is a drop down selection, how would that work?
As explained in 6:10 you can choose your sheet. You need to customize the code to meet your requirements.
Could this or something similar work with ACF fields in a CPT? I'm trying to create a verb conjugator, so verbs are my custom posts, and each post's content is full of ACF fields for all the different verb forms (I am, you are, he is, etc.).
It must work, i never used ACF with this sort of integration but the flow/mechanism is more or less same. They also use REST API.
Hello Sir! Do we need to add 'post_' before each meta variable?
Nope
Again Great Tutorial!! Question: Can we achieve this also with cct?
Same method, you need to change the endpoint url to your cct url.
@@MoxetKhanPK This is not the same method, I've tried this several times with cct and the CCT value names are not the same, For Ex. You're not working with Post IDs, but rather _ID (ITEM ID), alot changes, a simple url swap for the endpoint doesn't work
@@AnthonyTilahun You need to learn the logic, offcourse it can't be 100% same if the instances are not same.
Hi, this works both ways? If I edit the post on wordpress he will update on gogle sheets?
Nope, one sided
@Moset Khan is it possible to load in allready made Wordpress post and Edit it with googlesheet so you can do it faster ?
i don't see any benifits of importing wordpress to sheet, edit and publish it again unless it is a tabuler data.
Yes it is possible..
@@MoxetKhanPK Because for example i have a 2000 Posts that i need to update fields and ( put in info for the new felds ) and doing that manual takes around 5 - 10 mins per Post right now.. i was hoping to do it faster in google sheets and using maybe ChatGPT or something .. That why i am asking
Please send full videos how to enbale also restAPI
Hello, I generated a formula to add 20% to a value but since it is not typed and it is a calculation, it does not take the update, that is, the value is never sent to the CPT, I tried typing a value in that box and there it is Send correctly, any idea what it could be?
You need to change the trigger from change to save i guess.
Did anyone get it and could help me?
I tried every possible way, in Postman it works perfectly, but when I switch to Google Sheet it doesn't work. Problem with the spreadsheet, it doesn't generate the Id or the Status, I've tried to configure it in different ways but I can't, I've been trying for a week and nothing, could anyone help me?
how to set the thumbnail image?
Claiming to make a complete tutorial from scratch.
complete tutorial for?
@@MoxetKhanPK WordPress post will upload into Google Sheets same as this, please
@@shahinulislam9304 i already made it here czcams.com/video/6MeA0qdhlmI/video.html
Do You have codes for CCT? tried using the code in CCT but cant able to run it, i change post_title to my CCT Title like sample_title
There is one shared by Haxrat Bilal in Facebook group do check.
can you send us a link for this group?@@MoxetKhanPK
I've made Meta Field for "date" in my CPT. But when typing the date in the Google Sheets, it does not happen anything with the Meta Field inside the post. Is there a specific way to write the date in Google Sheets to make it get in as a date? Thanks in advance.
Parse date in code before sending it to wordpress in proper format. Most probabaly push it as string
Hmm. What would that be for say 08/03/2024 (March 8 2024)?@@MoxetKhanPK
@@MoxetKhanPK Hmm...Nothing happens when I push "2024-03-16" in Google sheets. Can't send picture here to show, do you have any reccomendation?
when im updating phone its says error 400. but when im inserting text in phone its updating but not updating with just numbers. why?
got it the data type in google sheet for the number was numeric it should be plain text
02:53 and 06:12 Where do i find my endpoint URL? Is it the same as yours, but with my root domain name url?
Exactly! just change my website URL to yours and the CPT slug with yours, i am using leads as cpt you might have posts or something else.
@@MoxetKhanPK Thank you!
@@MoxetKhanPK how I enable RestAPI and postman??
@@codemilestone7697 explained in first part of video
@@MoxetKhanPK can you please send me the first part video link please?
what if we want to add an image, and what code do we add in the app script. can you show and write the code please
chatgpt and google is your friend, do a bit research and use base64 encoded image.
@@MoxetKhanPK i don't have coding skill, i'm stil new in this, can you help me
@@uminurlis you can send message on my fiverr to discuss in details
Can you do a video of dynamic function for jet engine thanks
What exactly you need in dynamic function?
@@MoxetKhanPK I would like add a calculation function with meta fields or rest API fields values
I'm tring to pass meta field information as numbers but I keep getting an error Failed: 307 or an error Failed: 400 whenever I try to add in data for the meta fields. Why would that be? Could someone help? Is the process different if the meta field is not a "Text" but a "Number" ?
Ok after maaaaany hours of trying to pass a number to a meta field of type "Number", I found the solution! (I kept having a Failed: 307 error)
var post_numberMeta = sheet.getRange(affectedRow, 4).getValue().toString(); // Ensure post_numberMeta is a string
Key is to add the ".toString()" function. In the CPT, it is still interpreted as a number.
Sir please making a video about create chatting function with jet engine.
Already shared
hi, its postible insert to CCT?
Same method, you need to change the endpoint url to your cct url.
thanks, its amazing and save my time anf all my clients time
@@MoxetKhanPK i have next question :) how delete cpt in WP if i delete row in google sheet?
@@PROSIMSI custom code
Can you also delete a post this way?
Yes you can, you can follow this guideline
wordpress.stackexchange.com/questions/400993/delete-request-using-wp-rest-api
Hi, I followed the whole setup but for some reason its not working? How does the sheets connect to wordpress?
It connects with REST API
Hi, when I did all the things you did above its not connecting to the website. When I add something on the sheets the status shows "Failed: 404"
I even created the same cpt as you and same metafields with same ID and everything. Do you maybe know why its doing that? @@MoxetKhanPK
Hi, when I start adding items in sheets the table says Failed: 400 of Failed: 404. I added the exact same cpt as you with the same metafields and still its not working. When I use Postman it creates the posts but when i add to sheets after everything its not working? @@MoxetKhanPK
Hi, I finally got it! It was my Jetengine fields that was corrupt for some reason. I now have another question, I am pushing data from zoho flow to sheets. So now sheets is not seeing the trigger "on edit" so its not publishing the posts... How can I somehow make the trigger run when flow pushes the data? @@MoxetKhanPK
Moxet helped with this, thanks so much. Quick and reliable :)
Sorry this is not clear... do i need postmade to use Google sheet , ?? Pls make better steps for what is whats ir feels like have of Infos are missing 😢 😢😢
On How to connect with taxonomy like city ??
Send city ID from your sheet
@@MoxetKhanPK I already did with taxonomy id using Array but It's not working dynamically please can you help me?
@@MoxetKhanPK if you want can I share you my code??
@@codemilestone7697 why array? You should pass integer value of term ID just like i did in this tutorial
@@MoxetKhanPK its not working I did lots time on google sheet Apps script then I going to help Chat GPT and try to work like 3 days still not solve this issue can you please help me this one time my humble request please
boss Brother Just boss
Thank you for your tutorial, but i believe your are missing an important thing, lets say you need to load a big chunk of data, how would you do it? as far as i understand, here you explain how to do it one by one, but when you have loads and loads of rows, this example its not really a good idea, is it?
I know that, two solutions- the trigger should be changed to save and the code must be alter as well. Alternatively use free plugin if data is a lot.
Why don't you link to postman?
Why should i do?
@@MoxetKhanPK Not to your post man link but just to the url itself, it would be helpful to those that are just beginning.
@@AnthonyTilahun the video is not about postman
It seems like a step in this tutorial is missing.
Which is?
@@MoxetKhanPK In the status column, Failed 404 / 403 appears. The ID in the Post ID field does not appear automatically. I've followed everything.
@@unggulkirindi6556 403 mean you dont have enough permission or your REST API has error.
Mine, after managing to activate the code and stop giving errors, I have the same problem, it doesn't generate the automatic ID and apparently it prevents the information from being passed to Wordpress.
I already added Rest API authorizations anyway, but unfortunately it won't work.
PErfect
Hello there, why don’t you create a discord server and people with like minded can help each other
Did anyone get it and could help me?
I tried every possible way, in Postman it works perfectly, but when I switch to Google Sheet it doesn't work. Problem with the spreadsheet, it doesn't generate the Id or the Status, I've tried to configure it in different ways but I can't, I've been trying for a week and nothing, could anyone help me?
Same Question From my side as well how Post ID and Status generated automatically ?