- Home /
How can I access Google Spreadsheets from Unity?
I would like to learn how to change a value in a Google Spreadsheet and have the power of a laser (for example) in a Unity project change in direct relation.
I'm aware that there are paid and free Unity plugins to access the spreadsheets, but I'm looking for something which will teach me how to do it myself. Essentially, I'm looking for a tutorial that can replace this one by Robert Yang, which, as far as I'm aware, was made defunct by later upgrades to the Google Spreadsheets system.
Does anybody know if such a tutorial exists? Does anybody have the knowhow to provide one? I'm not looking for extensive polish or Unity Editor integration (I can work on that myself!) - just the ability to have a Unity game look up a Google Spreadsheet and use that to update it's internal values!
Cough Anybody?
--Rev
Answer by peterpunk · Feb 06, 2018 at 10:26 AM
Check this project by Google itself: https://github.com/googlesamples/google-signin-unity
Holy cow, that's immensely cool, I'll look into that. Thank you. --Rev
Answer by Bunny83 · Mar 03, 2017 at 02:35 AM
Just look up the API that google offers. Reading / writing values. You can use that API using Unity's WWW class or the new UnityWebRequest class.
ps:
This has little to do with Unity as it's all about a web API that can be accessed from any system. It's well documented on the google side.
If you really just ask us to find you some tutorial videos you completely missed the point of UnityAnswers. We are not a search engine. Questions should be about concrete technical problems that arise from the use of Unity or questions about Unity itself.
Thank you, Bunny, this looks very promising.
I'm sorry to say that I'm somewhat self-taught as a Unity programmer, and have rarely stepped outside of the Unity / C# ecosystem. I DID try to find information on this within Unity sites / tutorials, etc, but my best hit was Robert Yang's tutorials.
For whatever reason, everything else I found seemed somewhat inpenetrable or relating to skills I had no grounding in (I've worked on some HT$$anonymous$$L / JAVASCRIPT / JQUERY tutorials, but very little seems to stick, or seem relevant to my Unity program$$anonymous$$g (I'm a moderately competent programmer w/in Unity)).
Hence I turned to Unity Answers - asking my peers for a Unity facing answer to a Google problem. I grant you that it's not an ideal use of the site, but I honestly didn't really know what to search for - my previous terms were along the lines of 'unity google spreadsheets'.
Now I know about UnityWebRequest, the Google Spreadsheet API (previously you had to download the API for NET and install .dlls into your project folder) and I have a lot of resources to back it up.
I now have plenty I can take TO a search engine. =)
Sorry if this still seems an inappropriate use of UA, but genuinely, thank you. I'll give this info a test run as soon as I can, and will probably mark your reply 'correct' tomorrow.
--Rev
Answer by Alond · May 15, 2019 at 12:05 PM
If anyone is still looking for a simple solution, this one works really good: https://designagame.eu/2018/02/getting-google-sheet-data-runtime-updates-in-unity/
Your answer
![](https://koobas.hobune.stream/wayback/20220612112328im_/https://answers.unity.com/themes/thub/images/avi.jpg)