Unity to Google Spreadsheet - Sending Data the Easy Way
Вставка
- Опубліковано 11 лип 2024
- ✅Easy mode! Send data from Unity to Google Spreadsheets. No API. No 3rd party assets.
I forgot in the video to give credit to the guys at Gigabit Games (gigabitgames.com/) who did the original figuring out and, yes, actually asking ChatGPT how to do it.
🚀🚀🚀Deep Space Directive On Steam: store.steampowered.com/app/25...
Video Links
************
🚨Chat GPT Convo with Code: chatgpt.com/share/bc4dee72-28...
🦄OdinInspector: prf.hn/click/camref:1100lHSw/...
Support the Channel!
**********************
► Buy me a coffee: www.buymeacoffee.com/onewheel...
► Shop the Unity Asset Store (affiliate): assetstore.unity.com/top-asse...
► Become A Channel Member: / @onewheelstudio
► Or a Patron: / onewheelstudio
► My video and streaming kit: kit.co/onewheelstudio/tutoria...
► Buy a Game Design Book: kit.co/onewheelstudio/game-de...
Video Gear List (Amazon Affiliate)
***********************************
► Sony A6100 Camera: amzn.to/32logXz
► Sigma 16mm 1.4 Camera Lens: amzn.to/3KA4Wr4
► GoXLR (audio interface): amzn.to/35dmr03
► Shure SM7B Mic: amzn.to/3fNbV1E
► Blue Mic Arm: amzn.to/3tHgwdQ
Neewer Light: amzn.to/3rD8eRv
Light Softbox: amzn.to/3GUaHgQ
Neewer RGB Light: amzn.to/3rCTQJ9
Other Links
************
Discord: discord.onewheelstudio.com
Twitter: / onewheelstudio
Devlog: onewheelstudio.com/
Twitch: / onewheelstudio
Timestamps
*************
0:00 Intro
0:46 Getting Started
1:40 The Code
4:14 Google Form
6:03 Entry IDs
8:27 Response URL
9:35 It Works!
10:31 Linking to Spreadsheet
11:10 Security and Privacy!!!
11:56 One More Example
13:13 THE END
#GameDevelopment #Unity3D #indiedeveloper
06:50 You can right click and copy element which will copy the entire element or you can double click on it to grab just the field.
Nicely explained!
One thing for people to keep in mind when using this method in a production environment is the limits on Forms and Spreadsheets.
- each Form is limited to 2000 questions
- each response is limited to ~32000 characters
- each spreadsheet is limited to 5,000,000 cells (ie, a form has 5 questions, your limit is 1,000,000 Form responses)
If you are anticipating a huge hit, this may not be the answer for you but for 99% of games this should be plenty especially if used for player feedback or bug reporting. Analytics is a different story as that can eat up those limits pretty darn quick so I'd limit it to gathering and sending only a couple analytics responses per play session.
Oh man, this is perfect. I'm making small game as my bachelor's thesis and I wanted to implement my form into the game in a interactive way. Thanks
This helped me a lot! thank you so much for the video!
Very nice and clear! 😎
Really useful. Thanks!
Great tip. Thanks for sharing!
If using Chrome, in the inspector, you can double-click the value of an HTML attribute to highlight it. Then, press CTRL+C to copy it to the clipboard or right click and choose Copy from the menu.
This video was .... excel-lent!
that was good 😂
Sooo cool!
You can double click values in inspector window to select them. Then you can copy, edit etc.
How is this done in unreal?
It would largely be the same way you’d just need to figure out the web request equivalent.
@@OneWheelStudio thanks!
Try the vaREST plugin.
Useful but doesn't work in webGL
That’s a bummer. Webgl seems to have some frustrating limits.
you stole this video from the indian guy and you even made some mistakes. Google Spreadsheets is excel your code posts to google forms this is not the same thing.
🤔