REST API Google Sheet & Wordpress | Crocoblock JetEngine

No video

REST API Google Sheet & Wordpress | Crocoblock JetEngine

Рет қаралды 7,991

Күн бұрын

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...

Пікірлер: 98

@rafinhaprado 9 ай бұрын

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.

@MoxetKhanPK 9 ай бұрын

Thank you, another Sheet to Wordpress Tutorial is coming in few days :)

@bunediyo Жыл бұрын

Omg. You are great bro. Really you are the best.

@moallaacademy Жыл бұрын

ur tutorials are always different. I love your tutorials

@anthonyespino7214 Жыл бұрын

gracias por compartir tus conocimientos amigoo. Saludos desde Perú.

@SamWereb 8 ай бұрын

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

@MoxetKhanPK 8 ай бұрын

Thank you, i ll add it to description

@SamWereb 8 ай бұрын

Thank you for the things you publish here. You're really helped me understand JetEngine.

@rafinhaprado 6 ай бұрын

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?

@josephogbaji2660 11 ай бұрын

Thank you so much, very helpful. Please can you do this thing with CPT listing instead.

@abdulhamid.469 Жыл бұрын

Thanks learn something new from you. ❤

@Sashad2003 Жыл бұрын

Thank you very much. Very useful tutorial 👍

@matthieudondey8844 2 ай бұрын

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 😅😅)

@chetanram797 11 ай бұрын

I have created a full fledged login with firebase OTP verification and used Google sheet as a database.

@Art-01 Жыл бұрын

Thank u so much. Please make more videos👍🏻🙏

@mihaiciobanu01 Жыл бұрын

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.

@SamWereb Жыл бұрын

Thank you for this. Very useful.

@techplayblog 5 ай бұрын

awesome * 1000000000000 !!!! very useful!! 🤩

@onafetstube 5 ай бұрын

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

@litefilos 9 ай бұрын

¡GENIAL, MUCHAS GRACIAS POR COMPARTIR! :)

@deslogsales6045 Жыл бұрын

Awesome tutorial. Thanks alot

@YasirShabbir Жыл бұрын

Jazak Allah bro for your time :)

@JubranZakri Жыл бұрын

Thanks for this amazing tutorial

@ajlg-vzla 5 ай бұрын

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!

@MoxetKhanPK 5 ай бұрын

Worst case scenario, use datatable, it has pagination, search and what not.

@nurislam5379 Жыл бұрын

Wow 😱 really amazing ❤

@pezweb 10 күн бұрын

hi! how can u retrieve only 1 item, for example, the latest one and not the 3 of them?

@MoxetKhanPK 9 күн бұрын

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); }

@gamingp661 Жыл бұрын

Awesome

@baliflorent6971 Жыл бұрын

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 ?

@MoxetKhanPK Жыл бұрын

With custom code only.

@pixelharmonie-webdesign 6 ай бұрын

Horrey Moxet! Do you know how to filter by querys in Jetengine in your showed case? (at Timestamp 04:15)

@schulleroscar2037 4 ай бұрын

Hello, is it possible that when the data is changed on the google sheet, the change is deployed on wordpress without refresh the page?

@alan_jonatan 7 ай бұрын

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!

@MoxetKhanPK 7 ай бұрын

Modify the code in range section and define your own range

@PauloSilvadg 4 ай бұрын

Hola, y si quiero que cada campo de la tabla de Google sheets la otra utilizar en campos en el front con Cpt

@endless3171 6 ай бұрын

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.

@MoxetKhanPK 6 ай бұрын

Possible, you can fetch these values to query builder than charts

@endless3171 6 ай бұрын

thank you i know there are multiple ways to do that it just little overwhelming. Btw big fan of your content.@@MoxetKhanPK

@MoxetKhanPK 6 ай бұрын

@@endless3171 welcome 🎉

@rookiesmarts Жыл бұрын

Nice 😃 How can I do the opposite? Send data from Jetformbuilder to Google Sheets?

@MoxetKhanPK Жыл бұрын

Already made a video, check in channel

@visualmodo Жыл бұрын

Excellent video :)

@danrh14 Жыл бұрын

Thanks for this tutorial

@russcastella 7 ай бұрын

Thanks. About to play with it. What about multiple sheet tabs?

@MoxetKhanPK 7 ай бұрын

You can add gazillion sheet as fas as you maintain the code 😁

@Elsteck Жыл бұрын

Great! Thank you!

@jahid7656 Жыл бұрын

Just Boom 💥

@wasiqkhan886 9 ай бұрын

Thank you!

@ianndellagiustina8914 Жыл бұрын

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.

@PROSIMSI 8 ай бұрын

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?

@Tim-Thompson 5 ай бұрын

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?

@MoxetKhanPK 5 ай бұрын

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.

@Tim-Thompson 5 ай бұрын

@@MoxetKhanPK thanks fro getting back to me Moxet, do you have a video on how to do this please?

@theblacktrini Жыл бұрын

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?

@matiasgongorapowditch255 10 ай бұрын

Hi, I have the same problem. Could you solve it?

@anthonyespino7214 8 ай бұрын

@@matiasgongorapowditch255 Hello, could you do it?

@firstudionl 7 ай бұрын

Hi There, is it also possible to include cell formatting such as currency and color with this method?

@MoxetKhanPK 7 ай бұрын

The more you refine the code, the more better result you can get.

@user-ss7lg1xb1w Жыл бұрын

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

@MoxetKhanPK Жыл бұрын

Checkboxes/select etc tend to store values not labels, if you need to store labels make sure label and value are same

@user-ss7lg1xb1w Жыл бұрын

@@MoxetKhanPK ahh ok thank you for the answer, your tutorial is really great..

@MrShumy92 8 ай бұрын

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?

@MoxetKhanPK 8 ай бұрын

Yes it is possible, i already have a tutorial send elementor data to google sheet. please check that.

@bazeto 4 ай бұрын

Oh great, thanks mate, how I can add filter to search anything in this type of data

@MoxetKhanPK 4 ай бұрын

check my video about datatable in the channel

@bazeto 4 ай бұрын

@@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.

@MoxetKhanPK 4 ай бұрын

@@bazeto kzfaq.info/get/bejne/n7yfiqekmrmRaXU.htmlsi=mTtS8kcmo9CxjJ0a

@neotericangel 11 ай бұрын

What do I do if there are multiple sheets in the data?

@MoxetKhanPK 11 ай бұрын

you want to link it with 1 page or different?

@wcamaz Жыл бұрын

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.

@MoxetKhanPK Жыл бұрын

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.

@nguyenthuanhuynh3173 7 ай бұрын

How to gate date with right timezone

@MoxetKhanPK 7 ай бұрын

make sure your google and wordpress timezone are matching.

@DanielShuster96 Жыл бұрын

Thanks!

@aliyansajid Жыл бұрын

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

@MoxetKhanPK Жыл бұрын

It is more or less the same, you need to add credentials and fetch the requestes.

@aliyansajid Жыл бұрын

@@MoxetKhanPK I'm getting Forbidden error message upon Send Request

@mayurkurhade5400 11 ай бұрын

is it possible to create charts with the same method?

@MoxetKhanPK 9 ай бұрын

Yes possible.

@msandre19701 9 ай бұрын

How to put a "delete" button to delete a row?🤔

@MoxetKhanPK 9 ай бұрын

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.

@msandre19701 9 ай бұрын

Thanks for the feedback... Could you create a video explaining how to do it?@@MoxetKhanPK

@shakibkhan1921 Жыл бұрын

Can I manage those data from a post type?

@DanielShuster96 Жыл бұрын

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!

@MoxetKhanPK Жыл бұрын

Im not sure i ll check it but try to set google sheet timezone to yours as well.

@gamingp661 Жыл бұрын

Due to Time zone

@boxing_mantus 10 ай бұрын

How can I contact you for custom work?

@MoxetKhanPK 9 ай бұрын

softemblems.com

@PELLO987654321 7 ай бұрын

Can this also be done with multiple sheets within one Google spreadsheet?

@MoxetKhanPK 7 ай бұрын

Yes you can work with multiple sheet, different code.

@PELLO987654321 7 ай бұрын

Can you please write the code for this? I cant figure it out :(

@MoxetKhanPK 7 ай бұрын

@@PELLO987654321 paid tasks on my fiverr account

@PELLO987654321 7 ай бұрын

@@MoxetKhanPK okay, whats your username?

@matiasgongorapowditch255 10 ай бұрын

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?

@MoxetKhanPK 9 ай бұрын

Tutorial coming soon.

@anthonyespino7214 8 ай бұрын

@@MoxetKhanPK Thanks friend, we look forward to that tutorial. Greetings from Peru