REST API Google Sheet & Wordpress | Crocoblock JetEngine
HTML-код
- Опубликовано: 3 окт 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.co...
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/...
Download #Crocoblock:
crocoblock.com...
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/peru...
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 :)
ur tutorials are always different. I love your tutorials
Omg. You are great bro. Really you are the best.
gracias por compartir tus conocimientos amigoo. Saludos desde Perú.
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?
Thank you so much, very helpful. Please can you do this thing with CPT listing instead.
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 😅😅)
Thanks learn something new from you. ❤
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! :)
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!
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.
Excellent video :)
Thank you very much. Very useful tutorial 👍
I have created a full fledged login with firebase OTP verification and used Google sheet as a database.
Horrey Moxet! Do you know how to filter by querys in Jetengine in your showed case? (at Timestamp 04:15)
Wow 😱 really amazing ❤
Thank u so much. Please make more videos👍🏻🙏
Jazak Allah bro for your time :)
Nice 😃
How can I do the opposite? Send data from Jetformbuilder to Google Sheets?
Already made a video, check in channel
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.
awesome * 1000000000000 !!!! very useful!!
🤩
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
Thank you for this. Very useful.
Thanks. About to play with it. What about multiple sheet tabs?
You can add gazillion sheet as fas as you maintain the code 😁
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
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.
hi! how can u retrieve only 1 item, for example, the latest one and not the 3 of them?
You can try this code
function getSheetDataAsJSON() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var range = sheet.getDataRange();
var values = range.getValues();
var headers = values[0];
var lastRow = values[values.length - 1]; // Get the last row
var rowObj = {};
for (var j = 0; j < headers.length; j++) {
rowObj[headers[j]] = lastRow[j];
}
return JSON.stringify(rowObj); // Return only the last row as JSON
}
function doGet() {
return ContentService.createTextOutput(getSheetDataAsJSON())
.setMimeType(ContentService.MimeType.JSON);
}
Awesome tutorial. Thanks alot
Thanks for this amazing tutorial
Just Boom 💥
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 🎉
Thanks for this tutorial
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?
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.
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..
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?
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?
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.
Great! Thank you!
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.
Thank you!
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 ruclips.net/video/iVoWDs5S-9A/видео.htmlsi=mTtS8kcmo9CxjJ0a
How to gate date with right timezone
make sure your google and wordpress timezone are matching.
Can I manage those data from a post type?
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.
What do I do if there are multiple sheets in the data?
you want to link it with 1 page or different?
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 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
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!
How can I contact you for custom work?
softemblems.com
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
Awesome
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?