REST API Google Sheet & Wordpress | Crocoblock JetEngine
Vložit
- čas přidán 30. 07. 2024
- We already discussed REST API with #Wordpress, 3rd Party & #Woocommerce as well, today we will use a short code snippet in Google Sheet to fetch all records via JSON to our wordpress website.
GitHub Code:
gist.github.com/thisbit/8027e...
Topics: (Thanks to Sam Wereb)
00:00:20 Preview of a JSON script
00:00:49 Create a Google Sheet
00:01:45 Paste the code as an Extension
00:03:14 Find the endpoint
00:03:27 Connect the endpoint via REST
00:03:47 Add new Query for the API data
00:04:22 Create table or listing
00:05:58 Display the data on a page
Download #Elementor:
elementor.com/?ref=16401
Download #Crocoblock:
crocoblock.com/?ref=4088
Need to build dynamic websites?
softemblems.com
Follow me on Social Media
Facebook: / mxtchamkani
Instagram: / moxet
Twitter : / sokaniwaal
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
ur tutorials are always different. I love your tutorials
So helpful! Thank you so much, this opens up so many possibilities with Crocoblock. I had to follow you in both my accounts to not miss any new videos! You are a star. Greetings from Brazil.
Thank you, another Sheet to Wordpress Tutorial is coming in few days :)
Omg. You are great bro. Really you are the best.
Thank you very much. Very useful tutorial 👍
Thanks learn something new from you. ❤
gracias por compartir tus conocimientos amigoo. Saludos desde Perú.
Awesome tutorial. Thanks alot
Thank you for this. Very useful.
Wow 😱 really amazing ❤
Thank u so much. Please make more videos👍🏻🙏
Thanks for this amazing tutorial
awesome * 1000000000000 !!!! very useful!!
🤩
Jazak Allah bro for your time :)
Hello! How are you? I really enjoyed your video on this topic, which brought me a part of something I'm developing. Can you tell me if it is possible to fetch values from a spreadsheet to make calculations through a JetEngine form? I need to create a calculator on a website, but the results must be based on data from a specific spreadsheet.
Great tutorial as always!
One question: is it possible to create a form with jerformsbuilder or any other builder with REST API data, i mean populate some fields from API data and then do some calculation or get a response?
Ex: I have a API with car details data: make, model, engine, price etc.
I need to create a form that will populate these fields from API and then when clicked the submit to show for ex the price of a car based on selections of the fields.
¡GENIAL, MUCHAS GRACIAS POR COMPARTIR! :)
Thank you so much, very helpful. Please can you do this thing with CPT listing instead.
Great! Thank you!
Excellent video :)
Thank you!
Thanks for this tutorial
Hi Moxet, thank you so much for your video. I'm still quite new to jet-engine. For several of my clients, I have a "numbers section" and I usually create an Options page with Jet Engine. But using a google sheet would be perfect! What would you recommend if I don't want a table but just a few numbers? Would it be possible to do Google Sheet -> Options -> Elementor display? (sorry if this is a stupid question 😅😅)
Finally was able to use it in a project! Worked really well. Just a question: I tried to use JetSmartFilter to filter the REST API data, but I wasn't able to make it work. Would that be possible?
Just Boom 💥
Hi Moxet, thank you so much for your tutorials! I created a listing instead of a table. Is there a way to reverse the order of the listing? the first one before the googleSheet is shown as the first item of the listing, instead I would like the last line of the googleSheet to be shown as the first item of the listing
Hi, I have a question that I couldn't find an answer to anywhere. In addition to MAKE or Zapier, is it possible to insert data from Google sheet into CCT / CPT?
It would be a really useful feature.
Would you be able to give advice on how to achieve this?
00:20 Preview of a JSON script
00:49 Create a Google Sheet
01:45 Paste the code as an Extension
03:14 Find the endpoint
03:27 Connect the endpoint via REST
03:47 Add new Query for the API data
04:22 Create table or listing
05:58 Display the data on a page
Thank you, i ll add it to description
Thank you for the things you publish here. You're really helped me understand JetEngine.
I have created a full fledged login with firebase OTP verification and used Google sheet as a database.
Thanks!
Hello, is it possible that when the data is changed on the google sheet, the change is deployed on wordpress without refresh the page?
Hola, y si quiero que cada campo de la tabla de Google sheets la otra utilizar en campos en el front con Cpt
Can I manage those data from a post type?
hello Moxet, I have a question that is outside the content of your video, I have many days researching and I can not find a solution, with the jetengine form plugin I will create a form that contains select type fields: city, population and neighborhood, I need that when I select a city only show the populations that correspond to them and likewise, when you select a neighborhood, show only the neighborhoods belonging to that city, can you guide me how I can achieve it.
You need to use hierarchical select, but city should have relavent population as child taxonomy.
I am not sure about the structure of your site but it can be taxonomy or relationships.
Thanks. About to play with it. What about multiple sheet tabs?
You can add gazillion sheet as fas as you maintain the code 😁
Hi!
Thanks for your tutorial!
Do you happen to know how to implement a search filter on that table that actually works? i've been trying for sometime now but i believe i have an error on the variables im setting on the filter.
Thanks!
Worst case scenario, use datatable, it has pagination, search and what not.
Hi There, is it also possible to include cell formatting such as currency and color with this method?
The more you refine the code, the more better result you can get.
Thank you Moxet. I am using the above to manage a clients big phone list. Is there a way to have multiple tabs/sheets in a single google doc, then display each sheets on a separate page? or do I need to create a separate google doc for each sheet?
You can use 1 doc with different sheet, but either you need two .gs file or you need to optimize the code to push data to relavent end points. for example staff phone numbers has staff.gs file which push data from staff sheet to staff cct and so on.
Alternatively you can have 1 gs file but with different data variable and end point but that would be a bit difficult to manage.
@@MoxetKhanPK thanks fro getting back to me Moxet, do you have a video on how to do this please?
Horrey Moxet! Do you know how to filter by querys in Jetengine in your showed case? (at Timestamp 04:15)
Thanks sir. I have questions:
1- how can I load data in a jetEngine table without refresh the page? How can we do Ajax?
2- How can I add checkboxes in a column so I can select some rows and do bulk actions ?
With custom code only.
Could you make a tutorial or help me to show only a range of data from said table? Thank you very much and good video!
Modify the code in range section and define your own range
can we use this method for a dynamic chart builder. for instance, im looking for updating the values of charts from google sheets like daily or hourly updates.
Possible, you can fetch these values to query builder than charts
thank you i know there are multiple ways to do that it just little overwhelming. Btw big fan of your content.@@MoxetKhanPK
@@endless3171 welcome 🎉
What do I do if there are multiple sheets in the data?
you want to link it with 1 page or different?
Awesome
Nice 😃
How can I do the opposite? Send data from Jetformbuilder to Google Sheets?
Already made a video, check in channel
Hey, do you happen to have an idea why the dates are different? For example: in sheets, the date is 02/07/2023 and in the jet, it is displayed as 03/07/2023 (adding one day). Thanks!
Im not sure i ll check it but try to set google sheet timezone to yours as well.
Due to Time zone
hi this is great tutoria; but i have question.. how to define checkbox/select/radio field from JETFORMBUILDER to not write the value on google sheet? ived tried this tutorial but using chechbox but it give me the value not the label on google sheet.. very appreciate if u can answer this thx
Checkboxes/select etc tend to store values not labels, if you need to store labels make sure label and value are same
@@MoxetKhanPK ahh ok thank you for the answer, your tutorial is really great..
Oh great, thanks mate, how I can add filter to search anything in this type of data
check my video about datatable in the channel
@@MoxetKhanPK Can you please share the link, I want to show records form the same sheet by search, does it show anything from any cell if we search, I think I have to use smart filter please advice.
@@bazeto czcams.com/video/iVoWDs5S-9A/video.htmlsi=mTtS8kcmo9CxjJ0a
Hi, thanks for your tutorial. My goal its create a possibility to make a product table where registred user can enter a quantity of products, and to send a request to me clicking a button. How its possible to make?
Yes it is possible, i already have a tutorial send elementor data to google sheet. please check that.
Hello Abdul!
Your tutorial are really helpful. Can you tell me that how we can you third part API? I've watched your other tutorial in which you used rapid API but he API I've is not Rapid API
It is more or less the same, you need to add credentials and fetch the requestes.
@@MoxetKhanPK I'm getting Forbidden error message upon Send Request
is it possible to create charts with the same method?
Yes possible.
How do we create/update CCT items from Google Sheets data?
I have a Google Sheets Document with data, and I want to use the data from it to create CCT or CPT items. Is this possible?
Hi, I have the same problem.
Could you solve it?
@@matiasgongorapowditch255 Hello, could you do it?
How to gate date with right timezone
make sure your google and wordpress timezone are matching.
How to put a "delete" button to delete a row?🤔
You need to use hook which transmit the data to Google Sheet with a CCT ID & then delete it, but for sure you need Google Sheet API integrated.
Thanks for the feedback...
Could you create a video explaining how to do it?@@MoxetKhanPK
How can I contact you for custom work?
softemblems.com
Can this also be done with multiple sheets within one Google spreadsheet?
Yes you can work with multiple sheet, different code.
Can you please write the code for this? I cant figure it out :(
@@PELLO987654321 paid tasks on my fiverr account
@@MoxetKhanPK okay, whats your username?
How do we create/update CCT items from Google Sheets data?
I have a Google Sheets Document with data, and I want to use the data from it to create CCT or CPT items. Is this possible?
Tutorial coming soon.
@@MoxetKhanPK Thanks friend, we look forward to that tutorial. Greetings from Peru