How to access an API with Google Apps Script

In this video you will learn how to access an API with Google Apps Script.

#apiGoogleAppsScript #googleappsscript #API #chanelgreco #saperis

Want to learn how to be more productive with Google Workspace? 🤩

saperis - Be more productive by mastering Google Workspace!

[Jeff-fcnf]

I been using app scripts to try and learn to code. I am super familiar with spreadsheet and their built in functionality but I am pushing myself to learn to code for more advanced customization. I want to learn how to work with API’s and wow this was such an amazing tutorial. Absolutely perfect. Cant wait to check out more of your content.

[HuwSarah]

30+ years of programming and still learning every day. Thank you for filling yet another gap in my knowledge with you clear and concise video.

[KarlGingerich]

To see you code and explain it as you go makes learning for me a breeze, even if it takes a bit longer. Love your teaching methods, Chanel! 😊

[earlpreas]

Hey, Chanel - Thanks for the interesting post. I visit here, every 10 to 14 days, looking for a new training. Today, it is a skill I don't even need ... today ... but I have written notes and a searchable entry in my training log. Thanks!

[frmcf]

This is exactly the kind of thing that I'm trying to learn, and pitched at exactly the right level for my ability. Thanks so much! :)

[PiraveenKamalathas_PIRA_]

Was really helpful! Thanks a lot for this demo, inspired me to write automation scripts to export sheets processed data to CSV and other formats for external systems 🙌

[jamesbond_]

Great video -- covered a lot of techniques all at once. Looking forward to hacking weather info and the spreadsheet API.

[TJTHEFOOTBALLPROPHET]

It's astonishing how much I've learned from you - I even my daughters are learning to code the correct way from your channel. God has blessed you with the amazing ability to take complicated development topics and explain them with the clarity of a first grade teacher. Being a 52 year old man entering the world of software development for the first time - I needed to start at 'A IS FOR APPLE!' Thank you and Much love from New Orleans!

[ruzaqir]

Thx very much for this...even im not using it for google based app but now i know how to use api on my website. Hopefully ur succes on your journey saperis

[woswxfx]

woww you have made such a great platforms to learn. love the way you teach.

[johnsaintfleur]

Love your work, keep up the amazing content!

[kevpad]

Excellent tutorial. A one-click code download link would be nice, too!

[douglasteixeiradeabreu]

muito bom o onEdit seria ainda mais legal! parabéns amei

[sybqrng]

I am able to redirect URI which has auth_code (within URL) and this url showing specific error, How can I get the auth_code in HTML page or can get specific sheet cell ?

[djackio]

Hi, in your example you know your headers in advance. Can you pull data and create two dimensions without specifying the header names?

[lucamonti]

Hi Chanel, thanks a lot for this tutorial, it's great. I've implemented others elements about response... I'd like to try to make a forecast request, it's simple but i don't know how manage the response for others days... Can you help me please

[bambangpriantoro]

Love your explanation.
but if i may suggest or you can say it's a request.
since we have this 2 giants tech industries competing each others. i mean, microsoft now have microsoft graph and google have google app script. could you considering to make a video how to connect to Azure AD or MS Graph from GAS? Thank you.

[tiffenberg]

Hi, how do I replace the url when using OpenWeather or Visual Crossing? Am a beginner and have entered all this code, but Weather API is not free anymore. Not sure what code http code I need to enter? Thanks

[Podsolnoox]

Thanks for the case. For some reason, the picture quality is not very good, although the resolution in the application is set to maximum when viewing. If the zoom in the browser when recording was larger, it could help, but.... but now you have to look closely.

[thhillbillyinventor]

Is it possible to setup google sheets to post into google chat certain data when a keyword is sent?