Realtime Unity Data with Google Sheets | Third Aurora Augmented Reality Tech Company
Vložit
- čas přidán 13. 09. 2024
- In this Unity tutorial Luke Chaffey is going to show us how to utilise Google Sheets with Unity to provide realtime data through SimpleJSON scripting.
Stay in Touch with Third Aurora
--------------------------------------------------------
Website: thirdaurora.com/
Facebook: / third-aurora
Instagram: / thirdaurora
I cant get the link for the Json page to work. I pasted my sheets ID after publishing it to the web but the link is broken .
i love the perfect programmer comedy gold of "i don't know why, but it works"
Great tutorial indeed. But it is kind of outdated right? I can't seem to make it work. Google has updated the way of using Google sheets API (v4). if you could make a tutorial of it, that would be great!
any idea how yet?
same, what can I do now? can anyone help?
@@joaquinfraustoalfarorocco8177 here I solved it in my video : czcams.com/video/fNKegWGnTAc/video.html
@@ninakn5791 yep, here is the solution video I made to this problem: czcams.com/video/fNKegWGnTAc/video.html
OMG, thanks so much dude!!!!! I've been trying to get do this for 2 days now so I can do an update checker!!!!
If you ar ehaving issues with the web page only displaying the first row, change the part where he sets it to "Sheet1" to "Entire Doccument"
Thank you so much! apreciate the great content
is it possible to do the opposite of what you did in this video, i.e sending data like coordinates of a gameObject, in real time, to a google sheet ?
It doesn't working anymore :(
This is so cool!
Looks like this doesn't work anymore because of Sheets V3 API being deprecated. How does this work with the Sheets V4 API? Any help is appreciated
Create an API key here:
console.cloud.google.com/apis/credentials
Then use this URL:
sheets.googleapis.com/v4/spreadsheets//values/?key=
@@ShredsauceOfficial Thanks. Will test this out when I have some time and get back if I need help. Appreciate the reply!
@@TheLazyIndianTechie hello friend did you manage to check if the friend link above worked? I'm trying to do it anyway, please tell me how you dealt with the API V4 link
@@ShredsauceOfficial hello friend is this real? I will try thank you very much
@@Guardabarranc Haven't tried yet. Been caught up with some other stuff, sorry! I will try to get to it over next week and post my results.
Excellent tutorial - for the concepts!
Really useful
bro i need to link the 3d objects with time given in google sheet such that the object appears on the selected date could you help me how to do that???
excellent tutorial thank you so much for this great idea .
Very helpful. Thanks!
thanks this is very helpful!
This is amazing! but i have a question, is there a way we can use a similar technique but call a certain cell to display? lets say, we just put inside unity we wanna show the data in the cell "C6" ??
Is there a new URL for the Sheets v4 API? The one in the notepad don't work anymore :(
yes its new v4 API, cant pass here code
Here is the link for the solution video: czcams.com/video/fNKegWGnTAc/video.html
This is great :)
it's outdated :(
Google does not publish its webpage as json anymore.
I published it as a CSV with more or less the same workflow => no json though
I don't think this method is supported any longer
why not
Yes it's not as the api version has changed to 4
@@cruztriziaannei2825 because google changed the api version from 3 to 4
You can check my video out where I solved the problem and showed the working live on one of my projects
Link: czcams.com/video/fNKegWGnTAc/video.html
This is what i looking for!❤❤ such a Brilliant experience.. Subsribe😃
Great tutorial
can insert image and display too?
hello my name is bachtiar and i have question for u. can i use this method to make some quiz game and "admin" can easily edit the question in sheet? really need your answer
Hi, thanks for a useful tutorial.
I am stuck in one part, when I use, with the ID of my GoogleSheets.
I get the following error "Sorry, unable to open the file at this time. Please check the address and try again.";
-I already tried creating another
-Closing the Google accounts
But I can't solve it.
same, stuck here
@@JiteshGosar Google sheets has updated their V3 API and changed it to V4. I'm trying to figure it out as well
@@JiteshGosar here is the solution video: czcams.com/video/fNKegWGnTAc/video.html
doesn't work in 2024 :(
Do you know why?
Anyone having an issue with the version 3 and 4 of google sheets can refer to the video on my channel about how to fix it (included with a functional sample project) 🤝
A link to the video would be great
@@trinivet really sorry for the delayed reply, well here is the video link: czcams.com/video/fNKegWGnTAc/video.html
need a tutotiral for sending the real time time spent in the game to google sheets
Thank you man!!!
does it work the same with android platform?
pretty cool
Great tutorial. can you go the other way, saving game play data Back into google sheets? Any help much appreciated
any clue on this?
want to save data into a spreedsheet.
Actually, I guess we can do it as well, but it will take some time for me to come up with a fully functional way of doing it, till then I would recommend you use playerprefs in a similar way.
@@pabloarielnicoli7888 yes, actually to write the data back to sheets will take me some time to figure the functional way. Till then I would recommend that you use playerprefs in a similar way.
Suppose you wanted to make table with 2 colums, one for player Id and other for player score, then you can go ahead and declare a playerpref by the name player_id and store the id of your player in that and to score the player score you can declare another playerpref by the name player_score and store player score in it.
I know it is very time and memory wasting method but I guess it will work just fine. One thing to note here is that, since playerprefs are stored in cache memory hence if your user clears his/her cache for this particular app then all the id and score will be lost... So it is a 50-50 risk😅
thx helped a lot
Is this work for webgl export??
stepping stone for online income
thank you for this great tutorial. Can you please make a tutorial about making several augmented reality images in real time? Which AR SDK do you recommend?
19:35 okay, but using a string instead of a StringBuilder here is bad.
Does this requires work account