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.
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!
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!
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 🙌
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
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.
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.
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
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
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 TH-cam love form India
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 TH-cam channel: www.youtube.com/@googleworkspacedevs
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 ?
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
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.
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
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
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.
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
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
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
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!!!
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: th-cam.com/video/q6V5Yeni9dI/w-d-xo.html
@@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 🙂
How come the entire script worked, except 1 column of the final outcome: as in the icon doesn't show, all the numbers are correct. Any thoughts? Thanks!
@@saperis Yes, the icon is a part of the data but not showing. Here's what the code is , should be same as yours: let icon = data.current.condition.icon; let targetRange = sheet.getRange('A4:C4'); targetRange.setValues(weather); let iconRange = sheet.getRange('D4'); iconRange.setFormula('=IMAGE("${icon}")');
@@SuitOfHearts I had similar problem. My solution: 1. correct the line: let icon = 'https:'+data.current.condition.icon; 2. note the characters ' '. You have to use ` ` instead in the line: iconRange.setFormula(`=IMAGE("${icon}")`);
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.
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.
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.
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
![Beginners Intro to Pulling API Data into Google Sheets [BONUS: Secret APIs]](http://i.ytimg.com/vi/9VBxRZgY8_4/mqdefault.jpg)
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.
Thank you for learning with our videos 😀
is it possible to make a copy disable for editor in google sheet?
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.
Happy to hear the video was helpful. 😀
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! 😊
Happy to hear you're learning with these videos. 😀
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!
Hearing that you and your daughters find these videos useful means the world to me. Thank you very much 🙏🏽
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!
Love how you're into learning new things! Google Apps Script is super versatile and you never know when it might come in handy. 😀
Great video -- covered a lot of techniques all at once. Looking forward to hacking weather info and the spreadsheet API.
woww you have made such a great platforms to learn. love the way you teach.
Thank you 😀
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! :)
Happy to help! 😀
Very interesting. Thankie!
You are welcome 😀
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 🙌
Great to hear! 😀
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
Thanks for watching this video. I'm sorry, but I don't offer any coding services or mentoring.
Very cool
Glad you like it 😃
Hi, in your example you know your headers in advance. Can you pull data and create two dimensions without specifying the header names?
Do you mean the column headers? In my tutorial I don't refer to any column headers.
Hmm… I wonder if I could convert this to google sheets using some css for ui… probably a GitHub thing.
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.
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.
I don't do any Apps Script videos anymore on this channel. Find out why: th-cam.com/video/OHd_xEabivg/w-d-xo.html
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
Glad it was helpful! 😀
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
Maybe the API endpoint (e.g. the address) has changed? Please check the API providers documentation.
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 TH-cam love form India
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 TH-cam channel: www.youtube.com/@googleworkspacedevs
Excellent tutorial. A one-click code download link would be nice, too!
Thanks for watching 😀
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 ?
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
Thanks for your request. I can't promise that I will make such a video.
This was really helpful. I was wondering how do we connect to sharepoint and download a file using this. Thanks in advance
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.
@@saperis if interested I can get back to u with information
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?
Have a look at this Stackoverflow answer: stackoverflow.com/questions/65197929/google-app-script-urlfetchapp-fetch-api-key-header-getting-401-error
thank you@@saperis
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
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
Great Video! Quick Question: What if the API has restricted access? Is there a way to sign into the service?
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.
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
You always have to use the URL that the API provider gives you. Usually this should be in the API documentation.
Love your work, keep up the amazing content!
Thanks a ton!
Is it possible to setup google sheets to post into google chat certain data when a keyword is sent?
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
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
Sure, that's possible. There is no video on this channel showing how to do so though.
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!!!
I try to create videos for topics that are often searched for on TH-cam. So I generally can't promise to make videos for specific requests.
Can u make video how to read google sheet data using jason and display in html table format pls
Sorry, since I've been hired to work for Google, I don't release any new Apps Script videos on this channel anymore.
Hello,can appsheet connect with local network api?
AppSheet can call any API that is publicly available through the internet.
Hey
I am not able to get the icon for some reason
well deserved like
Thank you very much 😃
is it possible to make a copy disable for editor in google sheet?
No, a user with permission rights can copy a file or a script. There is no way of you disabling that.
muito bom o onEdit seria ainda mais legal! parabéns amei
Yes, you could use the onEdit trigger to automatically get the new weather data.
Hi, How did you get response body. For me still API key has been disabled
It is possible that this API has changed since this video was made.
Can the App script send incoming data from the Telegram bot and then send the data to a spreadsheet?
It depends on if there is a Telegram API you can use or if the Telegram bot provides a webhook you can use.
why do you use let instead of var? any advantages?
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: th-cam.com/video/q6V5Yeni9dI/w-d-xo.html
@@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!
This is really helpful, thanks. 👍🏻
You're welcome
@@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 🙂
@@TheDervMan Wow! Super happy to hear that you were able to use the demo from the video!
How come the entire script worked, except 1 column of the final outcome: as in the icon doesn't show, all the numbers are correct. Any thoughts? Thanks!
Don't know. When you get the data from the API, is the icon part of the data?
@@saperis Yes, the icon is a part of the data but not showing. Here's what the code is , should be same as yours:
let icon = data.current.condition.icon;
let targetRange = sheet.getRange('A4:C4');
targetRange.setValues(weather);
let iconRange = sheet.getRange('D4');
iconRange.setFormula('=IMAGE("${icon}")');
@@SuitOfHearts I had similar problem. My solution:
1. correct the line:
let icon = 'https:'+data.current.condition.icon;
2. note the characters ' '. You have to use ` ` instead in the line:
iconRange.setFormula(`=IMAGE("${icon}")`);
Is there any code to export reports from Google admin console to google sheet using appscript and API's
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
Hi! how about script that protect and unprotect sheet or range? thanks in advance. :)
Check this documentation to see how you can set protection with Google Apps Script: developers.google.com/apps-script/reference/spreadsheet/protection
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.
Do a Google search with the error message you receive. That's what I do whenever I have code that doesn't work.
Any chance you can share your script?! Saves me typing it all out again 😉
Nope, we don't share any scripts. The typing is part of the fun of creating an automation script. 😀
Ma'am, How do I get the API key?
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.
how to hide a script in google app script for users, how a service provider to client
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.
Would creating a library meet my needs?
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
We do not create scripts for others. We share our knowledge through our videos so you can learn and create your own scripts.
hello
- A correction in November 2024
Replace your line 27 by the following:
let icon = 'https:' + data.current.condition.icon;
✨ 𝖕𝖗𝖔𝖒𝖔𝖘𝖒