Hi, when i copy and paste my google forms id with the json url you showed, it says ‘sorry, unable to open the file at this time’. Please can somebody help me🙏🙏
Hi Thanks for the video! I followed your instructions but get an error page. "Sorry, unable to open the file at this time. Please check the address and try again." I've published the specific sheet and copied its ID. What can be the problem?
amazing video! However, I noticed the way to parse data from google sheet is changed as Spreadsheet has upgraded since 2021 September (probably for security issue)
Hi Amarindaz! you are a great mentor. you tried to make us understand everything easily. it's pleasure to learn Something New. I am using an API tool of Sheet Best for this.
Hi @Amarindaz, This is a very helpful video. I have a quick question for my case. # I've got new data stored in the MySQL Database anytime during the day. (E-commerce food ordering platform). I'd really like to get this data into the Google Sheet immediately. (Whenever the new orders are placed) Could you please give me some advice how to integrate this script? or Could you please advise me on any possible solution for the beginner? :D
Very helpful! Im using this to create a Discord bot that will fetch google sheets data. Make sure you format as list, not cells. Otherwise you'll get the cells in a row formatted as a string like "1, Joe, Michael, Google" instead of as an object.
@@TheKukamonga Are you using JSON.parse() to parse the file? Json is always formattrd as a string by default, do you need to parse it for it to be valid json.
Almost worked - when I try to put in the json URL I receive an error that says I don't have permission to view the page and it says I'm logged in as the same user that created it.
You are always making amazing videos ✌️👌😁. But, I am currently struggling with Google sheet online in which I am trying to create a protection in the enter sheet only those cells and columns that has a specific word, so in a nutshell, I want to make automatic protection based on conditional. For instance, I have a data entry in which the team leaders fill it and I have a column to approve them, if I said yes then automatically lock these cells for them, and if it was no then leave it as it is. Thanks in advance. I have searched a lot but didn't find anything like this.
Yes, but right now it seems to be down constantly. Working 1/10 at the moment for me, last week it was 8/10..... Something has changed with Google.... hopefully they can sort it out soon.
*Convert GSheets to JSON instantly* 👉 bit.ly/GoogleSheetDB
thanks man!
thanks man!
Hi, when i copy and paste my google forms id with the json url you showed, it says ‘sorry, unable to open the file at this time’.
Please can somebody help me🙏🙏
same here, did you find a solution?
Finally a clever guy showed how to display google sheets data on a website.
Finally!!!
Thanks Amarindaz.
THIS IS WORKING? PLEASE TELL ME, IS WAS WORKING WEEKS AGO, BUT NOW IS NOT WORKING
This API was depreciated.
Is the data published to web is updating live?
Hi
Thanks for the video!
I followed your instructions but get an error page.
"Sorry, unable to open the file at this time.
Please check the address and try again."
I've published the specific sheet and copied its ID.
What can be the problem?
I am getting the same issue
@@Royredfirelion same here, did you find a solution?
same here, did you find a solution?
thanks alot bro
it worked for one page, but how to fo it if i want to get the whole document ?
amazing video! However, I noticed the way to parse data from google sheet is changed as Spreadsheet has upgraded since 2021 September (probably for security issue)
this video is great but i think shared as a link so everybody have access, what will be the solution
Recenntly I am receiving this kind of error: Sorry, unable to open the file at present.
Please check the address and try again.
How do I fix this?
I got the same issue, did you solve it?
Did you solved?
@@camilomedina8029 what about you?
I have used google appscript to generate my data to JSON format.
I don't see the option Publish to the web...
it's now File - Share->
Hi, is it possible to convert a JSON link to a google sheets?
yes
Hi Amarindaz! you are a great mentor. you tried to make us understand everything easily. it's pleasure to learn Something New. I am using an API tool of Sheet Best for this.
Hi @Amarindaz,
This is a very helpful video. I have a quick question for my case.
# I've got new data stored in the MySQL Database anytime during the day. (E-commerce food ordering platform). I'd really like to get this data into the Google Sheet immediately. (Whenever the new orders are placed)
Could you please give me some advice how to integrate this script? or Could you please advise me on any possible solution for the beginner? :D
hi @amarindaz there is lots of video in english to learn google app script but not available in hindi can you make app script tutorial in hindi
how to convert sheet 2,3,4 .... into json. in your video only have sheet 1
I’ve taught that in the following videos on this series. Please check it out
This is very helpful! Thanks for sharing!
Really this si working?
@@matikarev3807 It worked initially, but after you asked I checked again and now I get 404. I think Google removed this hack.
@@berniestudio yes. Now we need a token, key and oAuth
@@matikarev3807 Thanks for the update. Now just got to figure out how to set that up. Have a great weekend!
Very helpful! Im using this to create a Discord bot that will fetch google sheets data. Make sure you format as list, not cells. Otherwise you'll get the cells in a row formatted as a string like "1, Joe, Michael, Google" instead of as an object.
Hi! i formated my spreadheet as list but still getting my data as string.
@@TheKukamonga Are you using JSON.parse() to parse the file? Json is always formattrd as a string by default, do you need to parse it for it to be valid json.
this doen't work anymore as ggl shut done V3 API
do you know how to do this with new API V4?
@@Project_88 No idea, I abandoned my previous project.
Thanks heaps! Saved me A LOT of time :)
I'm glad :)
Thanks Sir.. How to create this one below from Google Sheets Sir?
var subjectObject =
{
"Front-end": {
"HTML" : ["Links", "Images", "Tables", "Lists"],
"CSS" : ["Borders", "Margins", "Backgrounds", "Float"],
"JavaScript": ["Variables", "Operators", "Functions", "Conditions"]
},
"Back-end": {
"PHP": ["Variables", "Strings", "Arrays"],
"SQL": ["SELECT", "UPDATE", "DELETE"]
}
}
Almost worked - when I try to put in the json URL I receive an error that says I don't have permission to view the page and it says I'm logged in as the same user that created it.
Simply go to "Share" and inside it you will get "Get Link" option, change it into "Anyone with the link" and you will get your output
You are always making amazing videos ✌️👌😁. But, I am currently struggling with Google sheet online in which I am trying to create a protection in the enter sheet only those cells and columns that has a specific word, so in a nutshell, I want to make automatic protection based on conditional. For instance, I have a data entry in which the team leaders fill it and I have a column to approve them, if I said yes then automatically lock these cells for them, and if it was no then leave it as it is. Thanks in advance. I have searched a lot but didn't find anything like this.
How do u get chrome to view JSON like that is it an extension?
yeah its a json formater
Thanks man...
It doesn't work for me ===>Sorry, unable to open the file at this time.
Facing some problem
Any solution?
thank you congratulations
Thank you too
THIS IS NOT WORKING NOW, TRY IT, WEEKS AGO THIS WAS WORKING, BUT NOW IS NOT WORKING
Yes ! The process has started breaking that I set up a few years back.... can't connect and get the JSON version.
@@cryptolvecryptoeducation928
🥺😕😟🙁☹️
Can you guys check this alternate solution ua-cam.com/play/PLe_F6wC3FvdpHeBcwqP4eLl3vbwWUIa05.html
If anyone getting "404: not found" only sometimes?
Working 8/10 times
Yes! I have this same problem. Network tab only shows successful sometimes. If you find the solution- please share! Thank you.
Yes, but right now it seems to be down constantly. Working 1/10 at the moment for me, last week it was 8/10..... Something has changed with Google.... hopefully they can sort it out soon.