Thank you for the lessons. Even without knowing English, simply turning on the translation of titles and watching the video, everything is accessible and understandable. Could you make a video on how to use websocket? And in general, can it be used in Google spreadsheets? For example, if I need to receive real-time stock data. Thanks again for your hard work!!!
If you're asking about this developer.mozilla.org/en-US/docs/Web/API/WebSockets_API then you should be able to use it, since it's in the browser. You won't be able to create websockets on the server side though.
@@ExcelGoogleSheets Thank you so much. Yes, I set up a trigger so now when the spreadsheet is opened, it fetches the new data. I was using a buggy extension but now this makes it much much better
nice video! thanks a lot! can u make a video explaing how scraping data from windwuru? and put in the spreadsheet? thanks again for ours videos! cheers from Argentina!
Hi my name is Vlad I am own of Apex LCC and I need your help with Google sheets with xml import function. I do Google Search separate AppSheet organize Company Database and AppSheet don’t have any Functions like (IMPORTXML/HTML) but Google Sheets has and problem is, I not can take any data from. (Google Shopping or My Collection in my account) Thanks
@@ethancomstock214 I got the same error, and I fixed it when I realized that the JSON I was getting has two levels to access the list of objects. Something like: { "success":true, "data":[ {_here is the data I need_ }, {_and here_}, {_and so on} ], "page":0, "lastPage":135 } so I had to access by data.data.map(.......), being the first "data" the variable that contains the results, and the second "data" the first level key in the JSON. I hope this makes sense.
Hi I am using import json in my google sheets, but i have a variable. If in that field don't have value i need put zero and next to line to organize data. EX: Call to json find a video_view value, but some lines don´t have this value. So json import in sequece and I lost organize data. Do you know a solution?
@@ExcelGoogleSheets How can I send a email with a picture to explain the problem, because I used noTruncate in importJson, but i need complet some columns to reference in DataStudio
I'm not sure what the response JSON looks like, but if you just want one then you could use [0] , example ["order"]["item"][0] otherwise you would need to loop though all of them and build the output.
@@ExcelGoogleSheets yep i was trying to build output for a trigger that grabs info about sales from external API to google sheets, so i tried this one: const data = JSON.parse(json) var p = ws.getLastRow()+1 for (var i = 0; i
omg the first part of this is a trudge. why do you need to past the url in a comment, to just copy paste it into the url variable............................................................ also, it's 2022, no need to teach people that variable names should be small. spell things out. it makes code more readable and self-documenting, especially for noobs.
Here is my opinion: this video was made for non-programmers. If you're a programmer then why are you watching this? You should be able to figure it out yourself. I don't watch programming videos, I just open the documentation and it's much faster for me to work that way then watch a video. Have you taught in an actual classroom in 2022? I have. I can tell you most people have no clue what a variable is and they have hard time understanding how to work with them.
@@ExcelGoogleSheets neither of the things I mentioned are helping people. I've seen people take things so literally they would put the url in the comment and leave it there, because you did thinking it does something. also like I said, it's 2022, we aren't abbreviating variable names anymore. if you are teaching that you are teaching bad habits. always spell out variable names for self documentation. and yes I did watch this video, because I have literally not used Google stuff like this before and piecing their documentation together can sometimes be annoying AF. I don't use Google stuff very often and seeing it all strung together in one video of EXACTLY what I was trying to do was very useful. all I did was say maybe you shouldn't be teaching bad habits to noobs.
@@BarryOnSports good for you. I am just telling him that he is teaching things that aren't convention. I'm glad you learned but he literally said he is doing this for noobs and he did 2 things that are bad to teach noobs. period. it doesn't matter if you learned something from it. I learned as well since I don't do much with Google products and this saved me a ton of time of reading Google's hard to read documentation. that doesn't mean his video was perfect just because there was good stuff in it.
@@SeraphX2 who give a shit if his video was perfect? You learned something, and so did I. So instead of being a dick about it, just drop a thanks and keep it moving, because other than being an asshole, what did you really accomplish here? Nothing. 🤡
Google changed the authorization process this year, and the bypass method no longer works. I got around this by putting: /* *@OnlyCurrentDoc */ and /* * @NotOnlyCurrentDoc */ in the beginning of the script, but sometimes it doesn't work and Google still blocks my script from running. Any idea on how to get around this?
@@ExcelGoogleSheets Weird. Every time I try to run a script, I get the authorization dialogue box, but then it brings me to a page that says, "This app is blocked," and it doesn't give me a way to get around it. It's a real headache.
Are you a part of a domain/organization? That could be one reason why. Other reasons could be if you have one add-on or other scripts there were blocked by Google because they were not updated to keep up with their terms then your entire account will get blocked from authorizing any scripts.
There is always something to learn. Thank you. Cool
excellent! straight to the point.
Thank you so much for listening to my suggestion in regards to Apps Scripts, keep up the great work! All videos watched now 😉
🤘
Hey man, really helpful thanks!
This video saved my job
Excellent tutorial! Thanks. How can I add titles for each column automated in the code?
I am getting 'data.map is not a function' error. Any way how I can solve this?
Wow excelente vídeo, mil gracias 😊
:)
Saved me, bro. Thanks
Glad to hear
Thank you for the lessons. Even without knowing English, simply turning on the translation of titles and watching the video, everything is accessible and understandable.
Could you make a video on how to use websocket?
And in general, can it be used in Google spreadsheets?
For example, if I need to receive real-time stock data.
Thanks again for your hard work!!!
If you're asking about this developer.mozilla.org/en-US/docs/Web/API/WebSockets_API then you should be able to use it, since it's in the browser. You won't be able to create websockets on the server side though.
This may work to receive real-time stock data in google sheet ua-cam.com/video/RkyfN0JhJYI/v-deo.html
data.map not a function, how would I fix this?
Excellent video and easy to follow. Will that function run every time the spreadsheet is opened?
Yes, assuming it wasn't already open in a different browser tab.
@@ExcelGoogleSheets Thank you so much. Yes, I set up a trigger so now when the spreadsheet is opened, it fetches the new data. I was using a buggy extension but now this makes it much much better
hi can you make a video on the API post method that has the user and API keys and several parameters to pass to the endpoint
I too would like this content, did you go looking and find anything helpful?
nice video! thanks a lot! can u make a video explaing how scraping data from windwuru? and put in the spreadsheet? thanks again for ours videos! cheers from Argentina!
It looks like they have an API, so I would look into that instead of scraping
stations.windguru.cz/json_api_stations.html
@@ExcelGoogleSheets Nice Info!! I'll take a look at it! So thanks!!
Hi my name is Vlad I am own of Apex LCC and I need your help with Google sheets with xml import function.
I do Google Search separate AppSheet
organize Company Database
and AppSheet don’t have any Functions like (IMPORTXML/HTML)
but Google Sheets has
and problem is, I not can take any data from. (Google Shopping or My Collection in my account)
Thanks
Hi! How can I add all elements in array, instead of pointing them manually?
Very useful video, but I am getting an error of 'data.map is not a function'. I did exactly same things still. can you please guide me?
im getting the same error
@@ethancomstock214 I got the same error, and I fixed it when I realized that the JSON I was getting has two levels to access the list of objects. Something like:
{
"success":true,
"data":[ {_here is the data I need_ }, {_and here_}, {_and so on}
],
"page":0,
"lastPage":135
}
so I had to access by data.data.map(.......), being the first "data" the variable that contains the results, and the second "data" the first level key in the JSON. I hope this makes sense.
Hi
I am using import json in my google sheets, but i have a variable. If in that field don't have value i need put zero and next to line to organize data.
EX: Call to json find a video_view value, but some lines don´t have this value. So json import in sequece and I lost organize data.
Do you know a solution?
instead of
post["video_view"]
use
post.hasOwnProperty('video_view') ? post["video_view"] : null
@@ExcelGoogleSheets I need use it in my script impor or in the import formula?
@@ExcelGoogleSheets How can I send a email with a picture to explain the problem, because I used noTruncate in importJson, but i need complet some columns to reference in DataStudio
cool vid, but having a problem
construction of post["order"]["item"] returns null
mb its because each order can have many items inside?
I'm not sure what the response JSON looks like, but if you just want one then you could use [0] , example ["order"]["item"][0]
otherwise you would need to loop though all of them and build the output.
@@ExcelGoogleSheets yep
i was trying to build output for a trigger that grabs info about sales from external API to google sheets, so i tried this one:
const data = JSON.parse(json)
var p = ws.getLastRow()+1
for (var i = 0; i
Please script code i need
omg the first part of this is a trudge. why do you need to past the url in a comment, to just copy paste it into the url variable............................................................
also, it's 2022, no need to teach people that variable names should be small. spell things out. it makes code more readable and self-documenting, especially for noobs.
Here is my opinion: this video was made for non-programmers. If you're a programmer then why are you watching this? You should be able to figure it out yourself. I don't watch programming videos, I just open the documentation and it's much faster for me to work that way then watch a video. Have you taught in an actual classroom in 2022? I have. I can tell you most people have no clue what a variable is and they have hard time understanding how to work with them.
@@ExcelGoogleSheets neither of the things I mentioned are helping people. I've seen people take things so literally they would put the url in the comment and leave it there, because you did thinking it does something.
also like I said, it's 2022, we aren't abbreviating variable names anymore. if you are teaching that you are teaching bad habits. always spell out variable names for self documentation.
and yes I did watch this video, because I have literally not used Google stuff like this before and piecing their documentation together can sometimes be annoying AF. I don't use Google stuff very often and seeing it all strung together in one video of EXACTLY what I was trying to do was very useful.
all I did was say maybe you shouldn't be teaching bad habits to noobs.
I, for one, really appreciate the way he explained EVERYTHING. If you didn't, then this video wasn't/isn't for you.
@@BarryOnSports good for you. I am just telling him that he is teaching things that aren't convention. I'm glad you learned but he literally said he is doing this for noobs and he did 2 things that are bad to teach noobs. period. it doesn't matter if you learned something from it. I learned as well since I don't do much with Google products and this saved me a ton of time of reading Google's hard to read documentation. that doesn't mean his video was perfect just because there was good stuff in it.
@@SeraphX2 who give a shit if his video was perfect? You learned something, and so did I. So instead of being a dick about it, just drop a thanks and keep it moving, because other than being an asshole, what did you really accomplish here? Nothing. 🤡
Google changed the authorization process this year, and the bypass method no longer works. I got around this by putting:
/*
*@OnlyCurrentDoc
*/
and
/*
* @NotOnlyCurrentDoc
*/
in the beginning of the script, but sometimes it doesn't work and Google still blocks my script from running. Any idea on how to get around this?
I haven't seen any changes in authorization. Works the same way for me.
@@ExcelGoogleSheets Weird. Every time I try to run a script, I get the authorization dialogue box, but then it brings me to a page that says, "This app is blocked," and it doesn't give me a way to get around it. It's a real headache.
Are you a part of a domain/organization? That could be one reason why.
Other reasons could be if you have one add-on or other scripts there were blocked by Google because they were not updated to keep up with their terms then your entire account will get blocked from authorizing any scripts.