How To Call External API Using Google App Script

Title: How To Call External API Using Google App Script

Tutorial Playlists:

What is google apps script?
Google Apps Script is a JavaScript cloud scripting language that provides easy ways to automate tasks across Google products and third party services and build web applications.

========================================================
Recommended books:

========================================================

In this video, you are going to learn how to call external API from google apps script and parse the JSON response to get the desired data.


You have to use URLFetch service to make the API request. That API will return response. You have to parse the response using JSON.parse method.

Some API call will also return response in XML. You have to use XMLservice to parse the same.

[bernardclabots]

thanks for sharing! What about basic auth?

[aaronvargas]

Excellent tutorial. Concise and well done. Thank you!~

[theauthenticleads]

Do you have a video or code where I use specific data from a cell to import as a variable into the url? Then whatever response I get from the api, would go into another column cell?

[alessandrograzzani]

Hi, excellent tutorial, as always.
I'm trying to connect google analytics 4 e create a function to take all the value of some metric and dimension in a certain period of time, and put it into a google sheet but I have to admit that i failed.

The main problem is that i do not understand hot to give the command for the estraction and in the same time put the values in columns in the google sheet. Can you help me?, you will be my hero and i'll share your channel everywhere🙏😂

[j.-b.cousinat]

This is clear, simple and efficient. Thanks !

[Marshallsbest]

so far so good in terms of content but may I suggest you zoom into your editor to make your code more easily seen and the star of the show

[oldschoolshoe]

Thank you for the tutorial. I had a quick question. Once the script has been run, you can see the results in the log file. However, how do you get that value in a cell on the google sheets you initially started with? Best regards.

[pjseoane]

Very useful video. What if i have to do a refresh every 5 secs for example.
Trigger allows only 1 minute updates.
Haow can I generate de array in sheet every 5 or 10 secs?

[marijnfly]

This video was recorded on a HP computer? Did you ever get rid of the annoying pop-up about the color scheme?

[sagerbhanushali]

hi really great video, i have another proble it willbe very great if you help me out in thi "How to export google sheets data to an external application
"

[charlesodi]

hey, just want a quick question : how about with bearer token? how will i execute -> header : {'authorization' : 'Bearer ' + <token>}

[rb]

Is json.parse no longer used by GAS in 2023? Tried following this tutorial exactly and get an error that

[carlearl]

Hi Amarindaz, thanks for the great videos!
I have a problem with the method :
I receive the following when I view the log:
[18-02-21 22:43:35:734 CET] undefined
Do you have any idea on how to solve this issue?

[ukvaishnav]

can you answer similar thing about zoom.

[davimendespimentel]

Great video, but the code could be better clean

[kfl-appsheet]

my query is how to consume other api when field updated.

[mohdharoon]

Wow great video.
Can u make a video of mini project with Google app script.

[Rexrules]

What about for API's that require an API key?

[reubenspremsamson]

Please assist in getting rid of this error:
ReferenceError: urlFetchApp is not defined (line 3, file "Code")

[yannfontaine]

Hi,
Thnak you for the video, you explain very well.
I get "This API endpoint is deprecated and has now been shut down. To keep using the Fixer API, please update your integration"