How to access an API with Google Apps Script

Подписаться 29 тыс.

Просмотров 61 тыс.

50% 1

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 RU-vid channel for more Google Workspace, Gmail, Google Docs, Google Drive, etc. videos: / saperis
saperis website: saperis.io/

Опубликовано:

27 июн 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 97

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

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

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

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

@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 🙏🏽

@jamesbond_007 2 месяца назад

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

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

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

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

@user-wo5sw9xf1x Год назад

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

@saperis Год назад

Thank you 😀

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

@kevpad1 Год назад

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

@saperis Год назад

Thanks for watching 😀

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

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

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

@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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-OHd_xEabivg.html

@johnsaintfleur6514 Год назад

Love your work, keep up the amazing content!

@saperis Год назад

Thanks a ton!

@lastgirlonearthvr 9 месяцев назад

Very cool

@saperis 8 месяцев назад

Glad you like it 😃

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

@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

@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

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

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

@santoshdhere8033 4 месяца назад

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 4 месяца назад

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

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

@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

@misyhaa 10 месяцев назад

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

@saperis 10 месяцев назад

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

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

@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 RU-vid. So I generally can't promise to make videos for specific requests.

@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

@phuongnamnguyen9856 4 месяца назад

Hello,can appsheet connect with local network api?

@saperis 4 месяца назад

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

@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 5 месяцев назад

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

@edwinlow8065 5 месяцев назад

thank you@@saperis

@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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-q6V5Yeni9dI.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!

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

@vikrammohokar3740 8 месяцев назад

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 RU-vid love form India

@saperis 8 месяцев назад

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 RU-vid channel: www.youtube.com/@googleworkspacedevs

@trustedplaylist7725 5 месяцев назад

well deserved like

@saperis 5 месяцев назад

Thank you very much 😃

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

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

@SoumitriD 5 месяцев назад

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

@saperis 5 месяцев назад

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 5 месяцев назад

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

@sbbillusionist 7 месяцев назад

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

@saperis 7 месяцев назад

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.

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

@jenk971k8 5 месяцев назад

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

@saperis 5 месяцев назад

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 5 месяцев назад

Would creating a library meet my needs?

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