Call Rest API on Google Sheets using Google Apps Script

In this video, I show an example of a Rest API call using Google Apps Script on Google Sheets.
Video, Code, and Documentation can be found at:
codewithcurt.c...

[@chriscampbell8991]

We’ll done, video is simple, to the point and clear. Thanks for taking the time!

[@Khujandiho]

very informative . thank you 🎉 you deserve b.j. with eye contact

[@tonmoitanvi1773]

Hey curt, it was a great video. I have learned something new from you. thanks! though i have been using an API tool of sheet best for years.

[@karthikpangala9854]

Thank you. This helped me a lot

[@MarzioBresciani]

Thank you very much for your video!

[@coryjohnson1515]

Perfect. I would have got there eventually (probably!) but you've sped things up for me at work no end. Cheers!
Subbed and liked!

[@NA-yr3ni]

Can you help us out with post method API which have basic authentication in API like API with basic auth and wanted to call using post method with some parameters

[@hassanshabbir1777]

hi any update on this ?

[@technolucent]

Hey ,great work<
How can make POST api calls to add data via API passing data as RAW json along with authentication in header like API key and content-type : json
Also, many key value pairs needed to picked from a CSV.
Solution is highly appreciated.

[@aprendegis6384]

Any update on this?

[@keychera]

@@aprendegis6384 There is an example on how to make Post api call, specifying contentType , and passing a json payload in Google App Script documentation on UrlFetchApp
(can't post the link because it would be put on hold)
hope this helps

[@abdullahquhtani4247]

Is it possible to do the reverse?! I mean to retrieve JSON data from google sheets?

[@CodeWithCurt]

I believe you can. Check out the video below. I currently do have a video on this but found this on the web.
trevorfox.com/2015/03/rest-api-with-google-apps-script/

[@abdullahquhtani4247]

Code With Curt Could you send your video plz.
Thank you 🙏

[@sachinsharma8980]

What is cost per api after reaching the free quota limit?

[@SD-rg5mj]

hello could you give me a method to use the gpt4 API in Google sheet
thank you very much for your videos

[@noname-jl1vc]

can we posting it to blogspot from google sheet ? thanks

[@cgc2300]

hello