G2U Asset Store Page IMPORTANT UPDATE! If you are unable to log in to your Google Account, you MUST update to the latest version of G2U. Google changed the way authentication works, and the older version of G2U (And GoogleFu 1.x) are NOT compatible. IF YOU HAVE INSTALLED PRIOR TO 2.1.0 The default install folder has been changed. This means you MUST remove the previous /Assets/Google2u folder (You may leave your Google2uGen folder in-tact) before you install the newest version. Otherwise you will get a screen full of warnings/errors. G2U - A fusion of the Unity development tools and Google Spreadsheets. Harness the power of Google Spreadsheets within Unity while developing your game. G2U allows you to import data from Google Spreadsheets with a click of the button, without having to leave the editor. The Editor Extension works as a pre-build step, so your application never has to contact Google itself. Localize Strings Manage Character Stats Manage Items Create Loot Tables Assists the import of Microsoft Excel, Open Office, XML, and other popular formats into Google Documents. Works with published Google Spreadsheets, as well as private spreadsheets tied directly to your Google account Supports generating NGUI Localization files Generates custom Playmaker actions tailored to your data Source Code included in the full version! Public Documentation G2U - Full Version G2U - Free Version FAQ: Q) What is the difference between the Full version and the Free version? A) The Free version of G2U is limited to exporting 10 Row x 10 Col spreadsheet. It is designed to allow you to use the plugin in it's full capacity, but restrict the amount of data it will process. If you only need a 10x10 spreadsheet, then go nuts, there are no other restrictions. The Free version of G2U is also compiled into a DLL, where the Full version contains all of the raw code files. Q) Do I have to use my Google account? A) No, you are not required to sign in with a Google account. You can make any of your personal spreadsheets publicly accessible, and G2U will be able to import the data. However if you do allow G2U to authenticate, it will be able to access private spreadsheets tied to your account. Q) What does G2U do exactly? A) G2U retrieves data from Google Spreadsheets, and formats it in a way that is easy to retrieve in your game. This makes a Data Driven design extremely efficient, and also allows you to very easily localize all of your strings, and retrieve them by using a string ID. Q) Does this mean my game must contact Google? A) No, G2U does all of the data retrieval outside of your game, and packs it up into files, or stuffs all of the data into a GameObject in your scene. This is all done prior to running the game, so there is no communication with Google at runtime. Q) Can I use G2U entirely offline? A) No, G2U utilizes the Google Spreadsheets API and requires access to the Google Docs cloud in order to retrieve data. However you absolutely can create your spreadsheets offline using Excel, OpenOffice, or other programs, and G2U will assist in uploading those files to Google Docs when it's time to import them into your game. Q) Can I use G2U at runtime? A) No, G2U is strictly an Editor Extension and is in no way included with the final build of your game. Google can sometimes be extremely slow, and accessing it at runtime would introduce security issues between your game and your google account. For runtime access of a database I recommend looking into a web hosted SQL server with PHP scripts to access it. It's much faster, secure, and designed for this purpose. Q) Can I use G2U to write to a Google Spreadsheet? A) No, G2U is a one-way street from Google to Unity. We have explored options for modifying and writing values back to a Google Spreadsheet, but the Google API does not give us any indication whether or not the value in the Google Spreadsheet is a formula or not, and writing back to the spreadsheet will destroy all formulas currently in the cells. Furthermore if a spreadsheet changes in the time between pulling the information from Google and writing it back, there is no way to reconcile which difference is correct, without recreating GIT or SVN like functionality, which is out of scope for this project. Currently, there are no plans to support this feature. Q) I have a problem! Who do I contact?? A) You can leave a comment on this thread, or use the following email. email@example.com Note: G2U is incompatible with the WebPlayer build target. Here's why: The Unity network libraries do not care where the network traffic originates, be it your application or the editor itself. The network libraries restrict Cross Domain Communication when the WebPlayer target is active. This is a conscious decision by the folks at Unity, because cross domain communication introduces a whole host of problems. Unfortunately this is exactly what G2U needs in order to authenticate. Workaround: Switch to the PC/Mac target when using G2U, and switch back when you're finished. I know this isn't ideal, as it can take a long time to switch platforms in some cases. Unfortunately this is our only alternative for the time being.