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?
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.
Use a return statement in the function. The example in the video would be: return data.rates.INR . Then you can call this function by the name in the spreadsheet
@@christianfoster1665 Sorry for the delay. I wasn't sure where to look on YT for a reply. Two things learned. Thank you for the directions. Kind regards. Deen
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🙏😂
Hi. I want to write codes about the klines api in binance. The code is like "api.binance.com/api/v3/klines?symbol=BTCUSDT&interval=15m&limit=1" The code will be with 3 variables: Symbol,Interval and Limit. So the url will be the sum of these parameters and constant texts. I couldn't write these code, please could you help me?
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?
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 "
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?
Hi, Thnak you for the video, you explain very well. However, I guess the API have been changed, when I go to api.fixer.io/latest?base=USD, I get "This API endpoint is deprecated and has now been shut down. To keep using the Fixer API, please update your integration"
sir,the way approach was simply good,i have a doubt that . how can i run a url whenever there is an update in the data. like if the data in row like A3 changes there should be a run of the url:-like io.reteiot.com/api/user/************/############/devansh/on
You can pass the data from the spreadsheet as variable in google apps script. For example : api.coinmarketcap.com/v1/ticker/"+sh1.getRange(i, 2).getValue();
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
Checkout how to build Email Marketing Tool on google sheets 👉 ruclips.net/video/gy7ypKE6rbg/видео.html
How to get json result back to googlesheet
Excellent tutorial. Concise and well done. Thank you!~
thanks for sharing! What about basic auth?
This is clear, simple and efficient. Thanks !
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?
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.
Use a return statement in the function. The example in the video would be: return data.rates.INR . Then you can call this function by the name in the spreadsheet
@@christianfoster1665 Sorry for the delay. I wasn't sure where to look on YT for a reply. Two things learned. Thank you for the directions. Kind regards. Deen
Great video - thanks for sharing!
Is json.parse no longer used by GAS in 2023? Tried following this tutorial exactly and get an error that
Good video. Thanks.
This video was recorded on a HP computer? Did you ever get rid of the annoying pop-up about the color scheme?
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🙏😂
Excellent!
hey, just want a quick question : how about with bearer token? how will i execute -> header : {'authorization' : 'Bearer ' + }
Hi. I want to write codes about the klines api in binance. The code is like "api.binance.com/api/v3/klines?symbol=BTCUSDT&interval=15m&limit=1" The code will be with 3 variables: Symbol,Interval and Limit. So the url will be the sum of these parameters and constant texts. I couldn't write these code, please could you help me?
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
Noted!
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?
can you answer similar thing about zoom.
What about for API's that require an API key?
You can pass that key in URL itself
Amarindaz oh wow really? Could you maybe give a quick example in a comment?
Instead of using API URL, can we use API Token?
Yes you can
@@Amarindaz can you give some examples or what command we should use in app script?
my query is how to consume other api when field updated.
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
"
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?
+Carl Earl which means you're not getting anything in return.
How to auto refresh this script on daily basis
Great video, but the code could be better clean
Please assist in getting rid of this error:
ReferenceError: urlFetchApp is not defined (line 3, file "Code")
It's case sensitive. Please check
It should be like UrlFetchApp and not urlFetchApp
I get the auth error 401
Hi,
Thnak you for the video, you explain very well.
However, I guess the API have been changed, when I go to api.fixer.io/latest?base=USD,
I get "This API endpoint is deprecated and has now been shut down. To keep using the Fixer API, please update your integration"
Wow great video.
Can u make a video of mini project with Google app script.
+mohd Haroon sure soon you can expect
sir,the way approach was simply good,i have a doubt that .
how can i run a url whenever there is an update in the data.
like if the data in row like A3 changes there should be a run of the url:-like io.reteiot.com/api/user/************/############/devansh/on
You can pass the data from the spreadsheet as variable in google apps script. For example :
api.coinmarketcap.com/v1/ticker/"+sh1.getRange(i, 2).getValue();
You didn't show how it looks like in the google sheet!
👍🙏
Google Apps Script: You do not have permission to call fetch