One Wheel Studio
One Wheel Studio
  • 173
  • 2 999 191
Unity to Google Spreadsheet - Sending Data the Easy Way
✅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/2510180/Deep_Space_Directive
Video Links
************
🚨Chat GPT Convo with Code: chatgpt.com/share/bc4dee72-2830-44d0-82f5-1e4f6bd1d687
🦄OdinInspector: prf.hn/click/camref:1100lHSw/destination:assetstore.unity.com/packages/tools/utilities/odin-inspector-and-serializer-89041
Support the Channel!
**********************
► Buy me a coffee: www.buymeacoffee.com/onewheelstudio
► Shop the Unity Asset Store (affiliate): assetstore.unity.com/top-assets/top-paid?aid=1100lHSw
► Become A Channel Member: ua-cam.com/channels/kr9CPPqT9VWUjkpo3HcACg.htmljoin
► Or a Patron: www.patreon.com/onewheelstudio
► My video and streaming kit: kit.co/onewheelstudio/tutorial-video-production
► Buy a Game Design Book: kit.co/onewheelstudio/game-design-reading-list-unity-c-blender-and-more
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: go.twitch.tv/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
Переглядів: 1 852

Відео

Resetting Scriptable Objects - Unity Playmode
Переглядів 2 тис.5 місяців тому
🕹️Steam Wishlist: store.steampowered.com/app/2510180/Deep_Space_Directive/ ✅🎮👉 Current Build on Itch: onewheelstudio.itch.io/hex-game Scriptable objects are a useful tool in the Unity game engine to hold static data. However, if you need to change data or values in a scriptable object at runtime things get a bit tricky. With lifecycle functions like OnEnable and OnDisable or using the NonSerial...
Completing the Game Loop - Devlog
Переглядів 1,7 тис.7 місяців тому
🕹️Steam Wishlist: store.steampowered.com/app/2510180/Deep_Space_Directive/ ✅🎮👉 Current Build on Itch: onewheelstudio.itch.io/hex-game Deep Space Directive is 4x-lite game with tower defense and RTS mechanics and a focus on resource management. It's low poly art is created in Blender and the game is built with the Unity game engine and C#. Could I put in more good search terms? Probably! Assets ...
Visual Debugging with Unity Gizmos
Переглядів 2,1 тис.9 місяців тому
Unity gizmos provide an easy way to add visual debugging to your game development project. Draw lines, spheres, rays, meshes, and plenty more. Video Links Unity Gizmos: docs.unity3d.com/ScriptReference/Gizmos.html Support the Channel! ► Buy me a coffee: www.buymeacoffee.com/onewheelstudio ► Shop the Unity Asset Store (affiliate): assetstore.unity.com/top-assets/top-paid?aid=1100lHSw ► Become A ...
Moving Forward - Unity Messed Up So Now What?
Переглядів 12 тис.9 місяців тому
Unity messed up and now the rest of us have to figure out what we're going to do about it. ✅🎮👉 Current Build on Itch: onewheelstudio.itch.io/hex-game 🕹️Steam Wishlist: store.steampowered.com/app/2510180/Deep_Space_Directive/ Support the Channel! ► Buy me a coffee: www.buymeacoffee.com/onewheelstudio ► Shop the Unity Asset Store (affiliate): assetstore.unity.com/top-assets/top-paid?aid=1100lHSw ...
Easy Mode: Unity's New Input System
Переглядів 9 тис.Рік тому
Sometimes Unity's new input system can feel too complex. With "easy mode" you can quickly implement player input much the same way the old input system does. Keyboard, mouse, or gamepad it's all easy to add. The same functionality as GetKey, GetKeyDown and GetKeyUp. ✅ Blog Post: onewheelstudio.com/blog/2023/7/4/easy-mode-unitys-new-input-system Unity Documentation ⌨ Keyboard Class: docs.unity3d...
Assigning Input Actions in the Inspector - Unity's New Input System
Переглядів 7 тис.Рік тому
Assign input actions in the unity inspector using input action reference as part of the new input system. Easily assign hotkeys in the unity inspector. Blog Post: onewheelstudio.com/blog/2023/4/11/dyk-input-action-selection-in-the-inspector-new-input-system Unnamed Hex Game: itch.io/game/summary/1462699 Support the Channel! ► Buy me a coffee: www.buymeacoffee.com/onewheelstudio ► Shop the Unity...
A Year of Work and it has Problems - Hex Game DevLog
Переглядів 3,2 тис.Рік тому
✅Nova UI: assetstore.unity.com/packages/tools/gui/nova-226304?aid=1100lHSw 🕹️Steam Wishlist: store.steampowered.com/app/2510180/Deep_Space_Directive/ I've been working on a low poly hex tile strategy game in Unity for the last year. I've built systems for procedural map generation, upgrades, tech trees, and enemy spawning and they all work. But the frame rate can plummet and the game is slow an...
Self Taught Full Time Unity Developer - How I did it
Переглядів 4,1 тис.Рік тому
Self Taught Full Time Unity Developer - How I did it
Upgrade System in Unity - Stats Part 2
Переглядів 10 тис.Рік тому
Upgrade System in Unity - Stats Part 2
Stats in Unity - How I do it!
Переглядів 37 тис.Рік тому
Stats in Unity - How I do it!
What about UI Toolkit? - UI in Unity
Переглядів 15 тис.Рік тому
What about UI Toolkit? - UI in Unity
Unity UI that WORKS and doesn't Suck - Nova UI
Переглядів 34 тис.Рік тому
Unity UI that WORKS and doesn't Suck - Nova UI
Unity Coroutines - Neat and tidy ways to know when they're done!
Переглядів 7 тис.Рік тому
Unity Coroutines - Neat and tidy ways to know when they're done!
15 Useful Shortcuts to Code Faster with Visual Studio
Переглядів 35 тис.2 роки тому
15 Useful Shortcuts to Code Faster with Visual Studio
Add Juice, Polish and Functionality with Unity Event Handlers
Переглядів 10 тис.2 роки тому
Add Juice, Polish and Functionality with Unity Event Handlers
(Better) Object Pooling - I Didn't Like My Old Solution
Переглядів 14 тис.2 роки тому
(Better) Object Pooling - I Didn't Like My Old Solution
Local Multiplayer and Split-Screen - New Input and Cinemachine
Переглядів 27 тис.2 роки тому
Local Multiplayer and Split-Screen - New Input and Cinemachine
Strategy Game Camera with Unity's New Input System
Переглядів 29 тис.2 роки тому
Strategy Game Camera with Unity's New Input System
Raycasting with the Unity’s New Input System
Переглядів 9 тис.2 роки тому
Raycasting with the Unity’s New Input System
Unity Raycasting - 4 Examples
Переглядів 4,3 тис.2 роки тому
Unity Raycasting - 4 Examples
Should YOU use visual scripting?
Переглядів 5 тис.2 роки тому
Should YOU use visual scripting?
A Cinemachine Overview - If you're not using it. You should be.
Переглядів 12 тис.2 роки тому
A Cinemachine Overview - If you're not using it. You should be.
Grub Gauntlet - Official Trailer & Free Demo on Steam
Переглядів 3,4 тис.2 роки тому
Grub Gauntlet - Official Trailer & Free Demo on Steam
Key Rebinding with Unity's New Input System and Generated C# Code
Переглядів 21 тис.2 роки тому
Key Rebinding with Unity's New Input System and Generated C# Code
Shorter Cleaner Code with Extension Functions - C# and Unity
Переглядів 5 тис.2 роки тому
Shorter Cleaner Code with Extension Functions - C# and Unity
3rd Person Controller - Unity's New Input System
Переглядів 82 тис.2 роки тому
3rd Person Controller - Unity's New Input System
Easy High Resolution Unity Screenshots
Переглядів 9 тис.2 роки тому
Easy High Resolution Unity Screenshots
Changing Action Maps with Unity's "New" Input System
Переглядів 16 тис.2 роки тому
Changing Action Maps with Unity's "New" Input System
Unity's "NEW" Input System with C# Events
Переглядів 88 тис.3 роки тому
Unity's "NEW" Input System with C# Events

КОМЕНТАРІ

  • @s.mohammedjunaith6152
    @s.mohammedjunaith6152 4 години тому

    This is the best input binding video that I understand it beautifully. Thank you so much for your great explanation.

  • @user-ko3rb4sl4z
    @user-ko3rb4sl4z 3 дні тому

    i trying to Prefab GameObject basically i make outlesh rush game i working on buy manager when player got o buying platform and player buy any item then this item gameObject save in json file and load when game restart reopen now i stuck on current script is saving single data newly buying item can you tell me how i fix this

  • @muppam
    @muppam 9 днів тому

    thanks man, really needed this👍👍👍👍

  • @dumpworth9473
    @dumpworth9473 12 днів тому

    Nice video. Thanks.

  • @jordandills1430
    @jordandills1430 12 днів тому

    This saved me hours of trial and error, thank you stranger

  • @antoninolocicero7193
    @antoninolocicero7193 14 днів тому

    goodmornign, great tutorial! I have a question, how do you visualize on the screen which keys are you pressing?

    • @OneWheelStudio
      @OneWheelStudio 14 днів тому

      There was an addon that did the key visualization. I’m not sure the current state the addon - I can’t point you to one that works with current blender versions, but I’d assume there is something out there to allow it.

    • @antoninolocicero7193
      @antoninolocicero7193 14 днів тому

      @@OneWheelStudiooh so it's an addon, thanks for answering so quickly. Good evening

  • @user-mi8jx2yd6d
    @user-mi8jx2yd6d 15 днів тому

    the nova ui sounds great to use.

  • @Justeego
    @Justeego 17 днів тому

    My brain exploded with Alt up shortcut

  • @Chunkeeeeeeees
    @Chunkeeeeeeees 17 днів тому

    For anybody who didn't find a build in the build section after running the "run_build.bat" file, its probably because you're using more recent SDK, in which case, you'll need to make changes in the "...\sdk\tools\ContentBuilder\scripts\simple_app_build.vdf" file. ps. great video, thanks so much for making this such an easy process.

  • @omernahum8336
    @omernahum8336 19 днів тому

    Thanks for that. But you said the problem started because you needed to update/set different values to the SO, and once you set the variables to private how did it solve your problem? becuase now you can't change these values from anywhere in your game

    • @OneWheelStudio
      @OneWheelStudio 19 днів тому

      In a lot of cases I'm using functions to change the values of local/private variables after doing some calculations. You can also use getters/setters that are public to change the values of private variables. Lots of ways to do it ;) But in all cases if you don't use the NonSerialize attribute changes made in play can persist out of playmode.

  • @summersssky
    @summersssky 22 дні тому

    thank you so much this really helped 🙏

  • @willostrand6555
    @willostrand6555 24 дні тому

    Question about something here. If you had a scriptable object for your weapons, and in the scriptable objects set up a list of auxiliary damage types that the weapon had, such as empty for just a regular sword or fire and poison for a special sword, couldn’t you just have DoDamage always check the list and apply any kind of extra damage types to the damage? I don’t understand how setting the damageType for each individual weapon is more streamlined than this I think. I feel like you’re doing it with several classes when the way I’m currently doing it is with just a damage class and a weapon scriptable object. I’m not saying you’re wrong, I’m like a year into learning C# Unity. I’m just trying to figure out what you’re saying if you see this

    • @OneWheelStudio
      @OneWheelStudio 23 дні тому

      There are always more ways to do things. I’ve done something similar to what you suggest with a stat and upgrade system. I think the size of the project and the nature of the project is important when deciding how to do things. If you just have a handful of damage types using a list on an SO totally makes sense. If you have 25 damage types it probably isn’t the best choice. Each approach has pros and cons. I don’t think you’ll find a system that’s always the best. It’ll only be the best for or more realistically “good enough” for the current project.

  • @zwenkwiel816
    @zwenkwiel816 24 дні тому

    38:40 I thought I was having an aneurysm

  • @RMDetho
    @RMDetho 27 днів тому

    I'm a seasoned dev, although I mostly focused on web solutions. I've had done a few test projects in Unity and made a few playable demos, but what I'm having the most difficulty is structure, from assets to code. I thing I noticed in your video, it looks like your scripts are very "atomic" What I'd do probably is have some kind of critter class that handles everything critter related, including it's disposal, but then I'd struggle connecting any kind of events there. I can see benefits and drawbacks on both sides, but which approach would be better in general?

  • @jaulloa21
    @jaulloa21 27 днів тому

    The problem is breaking your game down to single mechanics then implementing them all together

  • @coolcola5828
    @coolcola5828 29 днів тому

    Is there some Godot equivalent? That'd be awesome 😊

  • @wojciechbudzynski6658
    @wojciechbudzynski6658 29 днів тому

    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 <3

  • @jessyjdirado
    @jessyjdirado Місяць тому

    inputAsset = this.GetComponent<PlayerInput>().actions; Getting an error on this line. Assets\Scripts\PlayerController.cs(19,22): error CS0029: Cannot implicitly convert type 'UnityEngine.InputSystem.InputActionAsset' to 'InputActionAsset' Which makes no sense to me but I figured I'd ask to see if there was a solution to anyone who comes across this video. Perhaps I am using the wrong Unity version because no one else seems to have this issue.

    • @jessyjdirado
      @jessyjdirado Місяць тому

      nvm fixed it with some magic. private UnityEngine.InputSystem.InputActionAsset inputAsset;

  • @zxcaaq
    @zxcaaq Місяць тому

    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.

  • @ScaryCitron
    @ScaryCitron Місяць тому

    Yes :)

  • @angrypug9841
    @angrypug9841 Місяць тому

    The NEW way to set up the 2d Vector is as follows :( Click on Move Go to Binding Properties and select "Action Type: Value" then "Control Type: Vector 2" THEN you can right click Move and Add Up/Down/Left/Right Composite will show up. It will then add a 3d vector to your drop down for WASD. So stupid of them to switch that up

  • @Crystalius777
    @Crystalius777 Місяць тому

    There's a great asset that makes it even easier with added functionality called UVS DOTween Engine

  • @paulm8501
    @paulm8501 Місяць тому

    It is horrendous! Worst part of Unity. I wish they would have opted for something as smooth as SwiftUI...

  • @808brotherstv4
    @808brotherstv4 Місяць тому

    Best advice ever i know where to start now

  • @user-wu7bz2sg2k
    @user-wu7bz2sg2k Місяць тому

    Thank you man!

  • @andrewpullins8817
    @andrewpullins8817 Місяць тому

    Is there an easy way to detect what controller the player is using and then switch out graphics for that controller? So if the player is on an xbox controller the south button is A, on Playstation it is O, on switch it is B. The triggers look different etc.

    • @OneWheelStudio
      @OneWheelStudio Місяць тому

      There is! I haven’t looked into it, but Unity does have a sample project that does exactly that. Should be available in the package manager - you may have to experiment to figure out which sample exactly.

  • @PsigenVision
    @PsigenVision Місяць тому

    Just going to say, completely sincerely, listening to your explanations is a breath of fresh air between being drowned by a LOT of other people's confusing babble. Thank you for your content

  • @aliceintini8900
    @aliceintini8900 Місяць тому

    This tutorial is amazing! Can I ask how to add an animation to the jump?

  • @theodoreeleazar8192
    @theodoreeleazar8192 Місяць тому

    theres one thing I wanted to know regarding this axis, how we can adjust how big the space of the rotation/translate when we do it manually using mouse. If we use maya we can adjust the sensitivity by pressing (-) or (+)

  • @JawadHussain-od8ie
    @JawadHussain-od8ie Місяць тому

    Great!Can we access these methods like OnBeginDrag,OnDrag without direct clicking on object? Click on empty space then dragging mouse on moveable object where OnBeginDrag work

  • @fdai0097
    @fdai0097 Місяць тому

    that was the most useful video for the year, thanks a lot

  • @LavxaGames
    @LavxaGames Місяць тому

    Awesome! Working on a hex generator myself, I love your art style

  • @Nyclia_Mycandra
    @Nyclia_Mycandra Місяць тому

    Hello~<3. May i ask if you have an idea of how to implement Unity's new PlayerInputManager and PlayerInput-Component both set to C# Events in combination with Photon Fusion 1? I already spawn and move player. Unity's PlayerInputManager is on my Scene InputManager-Component. Now i have to find out the best place to implement the PlayerInput-Component and code, so Fusion 1 can distinguish each player. Or is 'Send Messages' on the PlayerInput-Component Behaviour the better solution here? Currently Fusion locks my 2nd/joining player within a square around it's pop position and i struggle on finding solutions to freely move it also. Hints would help me alot. Thanks. :)

  • @palanolho82
    @palanolho82 Місяць тому

    @OneWheelStudion how would you go about checking if multiple coroutines that are running in parallel has all finished? thanks in advance

    • @OneWheelStudio
      @OneWheelStudio Місяць тому

      To be honest I’d probably fall back on using Booleans. I’d love to know if there is a better way.

    • @palanolho82
      @palanolho82 Місяць тому

      @@OneWheelStudio Booleans are tricky when you calling coroutines across components. I did some more digging and found an easier way that worked well. Since I only wanted to proceed when all the coroutines were complete, I just `yield return` them one after the other Coroutine cA = StartCoroutine(whatever.DoThis()); Coroutine cB = StartCoroutine(banana.DoThat()); yield return cA; yield return cB; This works great because no matter which one will end first, it will always take as much time as the longest one to execute. What do you think?

    • @OneWheelStudio
      @OneWheelStudio Місяць тому

      ​@@palanolho82 Somehow in my head I was imagining something more complex, or I was just being dumb. 🤷‍♂ Your solution totally makes sense. Its clean and simple. Looks good to me.

  • @etistyle96
    @etistyle96 Місяць тому

    incredible video thx a lot ! So much things make so more sens now.

  • @Jalechah
    @Jalechah Місяць тому

    This helped me a lot! thank you so much for the video!

  • @alexleonardkrea
    @alexleonardkrea Місяць тому

    Sooo cool!

  • @iiropeltonen
    @iiropeltonen Місяць тому

    Really useful. Thanks!

  • @codycanipe4415
    @codycanipe4415 Місяць тому

    Hey there, is there a simple way to modify the action processors via script at runtime? For example a ScaleVector2 for a camera input. I can't find a solution that is working for me. Also, i am using the Cinemachine Input Provider with a CinemachineFreeLook camera if you know about any restrictions in this context. Great video as always and thanks!

  • @IgorCiganovic
    @IgorCiganovic 2 місяці тому

    You can double click values in inspector window to select them. Then you can copy, edit etc.

  • @gunterstunter
    @gunterstunter 2 місяці тому

    How is this done in unreal?

    • @OneWheelStudio
      @OneWheelStudio 2 місяці тому

      It would largely be the same way you’d just need to figure out the web request equivalent.

    • @gunterstunter
      @gunterstunter 2 місяці тому

      @@OneWheelStudio thanks!

    • @mccleod6235
      @mccleod6235 Місяць тому

      Try the vaREST plugin.

  • @SonOfSofaman
    @SonOfSofaman 2 місяці тому

    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.

  • @nikescar
    @nikescar 2 місяці тому

    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.

  • @andreascarlsson744
    @andreascarlsson744 2 місяці тому

    Very nice and clear! 😎

  • @myk3l9675
    @myk3l9675 2 місяці тому

    This video was .... excel-lent!

    • @ilbailba
      @ilbailba 2 місяці тому

      that was good 😂

  • @internetboyfr1end
    @internetboyfr1end 2 місяці тому

    and how do you seelect a single face????? why can't i find it anywhere

    • @OneWheelStudio
      @OneWheelStudio 2 місяці тому

      You need to be in "face select mode." You need to be in edit mode. Then next to the object/edit mode dropdown there are three buttons for vertex, edge or face select. You can also use the hotkeys 1,2,3

  • @uzgamedev
    @uzgamedev 2 місяці тому

    I like your teaching approach, thank you for sharing this useful experience.

  • @blindsidedgames
    @blindsidedgames 2 місяці тому

    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.