How to access an API with Google Apps Script

Рет қаралды 59,669

2 жыл бұрын

In this video you will learn how to access an API with Google Apps Script.
Check out ‪@benlcollins‬ blog post on API authentication: www.benlcollins.com/apps-scri...
#apiGoogleAppsScript #googleappsscript #API #chanelgreco #saperis
Want to learn how to be more productive with Google Workspace? 🤩
bit.ly/productivity-for-creat...
saperis - Be more productive by mastering Google Workspace!
Sign up to our KZfaq channel for more Google Workspace, Gmail, Google Docs, Google Drive, etc. videos: / saperis
saperis website: saperis.io/

Пікірлер: 99

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

@saperis Жыл бұрын

Thank you for learning with our videos 😀

@quranlearningbangla Жыл бұрын

is it possible to make a copy disable for editor in google sheet?

@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! 😊

@saperis Жыл бұрын

Happy to hear you're learning with these videos. 😀

@Jeff-fc7nf 2 жыл бұрын

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.

@saperis 2 жыл бұрын

Happy to hear the video was helpful. 😀

@earlpreas6861 2 жыл бұрын

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!

@saperis 2 жыл бұрын

Love how you're into learning new things! Google Apps Script is super versatile and you never know when it might come in handy. 😀

@frmcf 2 жыл бұрын

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! :)

@saperis 2 жыл бұрын

Happy to help! 😀

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

@saperis Жыл бұрын

Great to hear! 😀

@jamesbond_007 2 ай бұрын

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

@TJTHEFOOTBALLPROPHET 7 ай бұрын

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!

@saperis 7 ай бұрын

Hearing that you and your daughters find these videos useful means the world to me. Thank you very much 🙏🏽

@ruzaqir354 Жыл бұрын

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

@saperis Жыл бұрын

Glad it was helpful! 😀

@oeaoo Жыл бұрын

Very interesting. Thankie!

@saperis Жыл бұрын

You are welcome 😀

@johnsaintfleur6514 Жыл бұрын

Love your work, keep up the amazing content!

@saperis Жыл бұрын

Thanks a ton!

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

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

@saperis 11 ай бұрын

Thank you 😀

@lastgirlonearthvr 8 ай бұрын

Very cool

@saperis 8 ай бұрын

Glad you like it 😃

@douglasteixeiradeabreu 2 жыл бұрын

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

@saperis 2 жыл бұрын

Yes, you could use the onEdit trigger to automatically get the new weather data.

@Podsolnoox 24 күн бұрын

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.

@kevpad1 Жыл бұрын

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

@saperis Жыл бұрын

Thanks for watching 😀

@user-sy6bq1rn4g 7 ай бұрын

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 ?

@trustedplaylist7725 5 ай бұрын

well deserved like

@saperis 4 ай бұрын

Thank you very much 😃

@TheDervMan 2 жыл бұрын

This is really helpful, thanks. 👍🏻

@saperis 2 жыл бұрын

You're welcome

@TheDervMan 2 жыл бұрын

@@saperis I've already built on your example. We have an event that runs once a month outdoors. I've updated the GAS that emails everyone involved with attendance numbers updates etc to include the weather forecast for the day 🙂

@saperis 2 жыл бұрын

@@TheDervMan Wow! Super happy to hear that you were able to use the demo from the video!

@lucamonti3679 Жыл бұрын

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

@saperis Жыл бұрын

Thanks for watching this video. I'm sorry, but I don't offer any coding services or mentoring.

@vikrammohokar3740 7 ай бұрын

Hi I am beginner to Google Apps script please make a video on how to use Google sheet API service directly on Google app script like Sheets.Spreadsheets.Values.get(spreadSheetId,dataRange) not anyone had made videos on this topic on entire KZfaq love form India

@saperis 7 ай бұрын

Thank you for watching this video. I don't do any Apps Script videos anymore on this channel. But I invite you to check out the Google Workspace Developers KZfaq channel: www.youtube.com/@googleworkspacedevs

@djackio Жыл бұрын

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

@saperis Жыл бұрын

Do you mean the column headers? In my tutorial I don't refer to any column headers.

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

@saperis Жыл бұрын

I don't do any Apps Script videos anymore on this channel. Find out why: kzfaq.info/get/bejne/ha6Uktt2xsjNpps.html

@santoshdhere8033 3 ай бұрын

Hi Chanel, Thanks a lot!! You are doing great work and sharing your valuable knowledge with us.. I am trying to access the api through the app script code but received DNS error. Could you please help me out or suggest

@saperis 3 ай бұрын

Maybe the API endpoint (e.g. the address) has changed? Please check the API providers documentation.

@SoumitriD 4 ай бұрын

This was really helpful. I was wondering how do we connect to sharepoint and download a file using this. Thanks in advance

@saperis 4 ай бұрын

I don't know. Does Sharepoint have an API you can use? When you wan to use an API, you always have to A) check if the creator of the system provides an API and B) check their documentation on how to use the API.

@SoumitriD 4 ай бұрын

@@saperis if interested I can get back to u with information

@matheusasilva1170 Жыл бұрын

Very good video helped a lot. I would like to save an image as well, I saw that google drawings allows saving, publishing and getting an html code that can be used in HTML projects. Could you help me create a script that also saves images? Thanks

@saperis Жыл бұрын

We don't release any new Apps Script videos on this channel and neither do we create scripts for others. To nudge you in the right direction I suggest you check out the documentation for Google Drawing class: developers.google.com/apps-script/reference/spreadsheet/drawing

@sbbillusionist 6 ай бұрын

Great Video! Quick Question: What if the API has restricted access? Is there a way to sign into the service?

@saperis 6 ай бұрын

That depends on the API. Usually, you will find information on how to access an API that requires payment or something else, on the API's provider website.

@helloitsme7702 2 жыл бұрын

Hello!!! Can you also tackle on how to duplicate a template google sheet automatically if a date changes using apps script? Thank you for these helpful videos!!!

@saperis 2 жыл бұрын

I try to create videos for topics that are often searched for on KZfaq. So I generally can't promise to make videos for specific requests.

@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

@saperis Жыл бұрын

You always have to use the URL that the API provider gives you. Usually this should be in the API documentation.

@edwinlow8065 5 ай бұрын

Hi, can I ask if the API key is in their header rather than as part of the URL, how should we adjust the code?

@saperis 4 ай бұрын

Have a look at this Stackoverflow answer: stackoverflow.com/questions/65197929/google-app-script-urlfetchapp-fetch-api-key-header-getting-401-error

@edwinlow8065 4 ай бұрын

thank you@@saperis

@quranlearningbangla Жыл бұрын

is it possible to make a copy disable for editor in google sheet?

@saperis Жыл бұрын

No, a user with permission rights can copy a file or a script. There is no way of you disabling that.

@rajeshsingh-joomla-expert 2 жыл бұрын

Hi, Can you make a video on how we can sell gsute addon on google workspace marketplace, and how to licensing process will be integrated in the addon that we want to sell

@saperis 2 жыл бұрын

Thanks for your request. I can't promise that I will make such a video.

@phuongnamnguyen9856 3 ай бұрын

Hello,can appsheet connect with local network api?

@saperis 3 ай бұрын

AppSheet can call any API that is publicly available through the internet.

@gomito158 Жыл бұрын

Hi All, Currently I have the same issue when I ran the code to call an API, it show an issue, I made the same changes in my code but it was unsuccessful. The problem occurs on APPSCRIPT but when I ran the code on POSTMAN or SWAGGER it works well.

@saperis Жыл бұрын

Do a Google search with the error message you receive. That's what I do whenever I have code that doesn't work.

@thhillbillyinventor105 Жыл бұрын

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

@saperis Жыл бұрын

Yes, you could do that. Have a look at how to create a webhook, which probably would be the best of doing what you want to achieve: developers.google.com/chat/how-tos/webhooks

@misyhaa 9 ай бұрын

Can the App script send incoming data from the Telegram bot and then send the data to a spreadsheet?

@saperis 9 ай бұрын

It depends on if there is a Telegram API you can use or if the Telegram bot provides a webhook you can use.

@P_double_H Жыл бұрын

why do you use let instead of var? any advantages?

@saperis Жыл бұрын

var was the original way to create variables. A couple of years ago let was added and can be considered somewhat superior to var. If you want the full details check this video: kzfaq.info/get/bejne/p5yGaLyW08-dlH0.html

@P_double_H Жыл бұрын

@@saperis thank you so much for the explanation. I got used to using var, but really good to know you could use let too. Good day!

@SunilKumar-ob6vs Жыл бұрын

Can u make video how to read google sheet data using jason and display in html table format pls

@saperis Жыл бұрын

Sorry, since I've been hired to work for Google, I don't release any new Apps Script videos on this channel anymore.

@dharishkumar6082 9 ай бұрын

Hi, How did you get response body. For me still API key has been disabled

@saperis 9 ай бұрын

It is possible that this API has changed since this video was made.

@chavdapalan8548 Жыл бұрын

Hi saperis I want to auto populate some field in Google form and i am using Google sheet as backend is that possible?all my data i have to populate is in Google sheet I hope you reply soon

@saperis Жыл бұрын

Sure, that's possible. There is no video on this channel showing how to do so though.

@engineeringeducation2634 Жыл бұрын

Is there any code to export reports from Google admin console to google sheet using appscript and API's

@saperis Жыл бұрын

That's not a topic I've ever looked into so I have no experience. Check the official documentation here: developers.google.com/apps-script/reference

@dammitbobby283 5 ай бұрын

What If the city has a typo during user input?

@saperis 5 ай бұрын

Good question. To find the answers, you would have to check the API documentation. I'm assuming that the request would fail.

@MrChrisgapo 2 жыл бұрын

Hi! how about script that protect and unprotect sheet or range? thanks in advance. :)

@saperis 2 жыл бұрын

Check this documentation to see how you can set protection with Google Apps Script: developers.google.com/apps-script/reference/spreadsheet/protection

@TheDervMan 2 жыл бұрын

Any chance you can share your script?! Saves me typing it all out again 😉

@saperis 2 жыл бұрын

Nope, we don't share any scripts. The typing is part of the fun of creating an automation script. 😀

@codewithatharv Жыл бұрын

Ma'am, How do I get the API key?

@saperis Жыл бұрын

From the API provider. Let's say you want to use a specific weather API. You have to check on the website of the API provider how you can get the necessary key.

@immi1498 Жыл бұрын

Can you help expert? Create a Simple flow 5-10 orders in 1st sheet, 2rd. Sheet input order in Google sheets 50 cells, Copy respected cells paste in format Google Docs Send as PDF to (cc,bcc,to: Gsheets!48,49,50) Workflow for next 10 order process..... To be continued

@saperis Жыл бұрын

We do not create scripts for others. We share our knowledge through our videos so you can learn and create your own scripts.

@jenk971k8 5 ай бұрын

how to hide a script in google app script for users, how a service provider to client

@saperis 4 ай бұрын

Well, it depends. If they have to use or run the script, you can't "hide" it from them. If they absolutely shouldn't have access to the script, you should consider publishing the add-on or app to the Google Workspace Marketplace.

@jenk971k8 4 ай бұрын

Would creating a library meet my needs?