[Released] Google Spreadsheets Data Source

How do you store your game config files? Serialized objects, XML? JSON? YAML? Is it comfortable for you and your game designers to work with? Is it comfortable to send files to someone and ask to look on it, improve or advice?

Let me offer you another way to collaborate on your config files. Use Google Spreadsheets, you can use any formatting and visual effect, use all power of sharing the google doc and be able to access it anywhere

The workflow is simple:

• Create a Spreadsheet, fill it with your data, and use any visual formatting you like, that suits your data. It may be info about vehicles characteristic, or mob’s spawn info, levels configuration, anything. You can also use different sheets in the same doc.
• Make a script using the plugin API to read this data.
• Download document cache to your project with one button click inside the plugin menu, so it's always accessible for your game.

Localization:
The localization is just one case how you can use stored data inside google sheets. But it’s a very common case so we made the extension which is already included in a plugin that allows you easily store and use location with Google Spreadsheets. Learn more.

 

Interested!

Does it support reading data from and also writing data to a spreadsheet?

 

Hey, nope it does not write data to a spreadsheet.
The flow is:
* Use Editor UI to set up doc accesses
* Use Editor UI to download/update doc cache
* Use API to access cached data in runtime

The plugin will give you an ability to only use data you cached using Editor UI before building tour app. There is no ability to access live data, since if you will have a large database of users and will reach google doc requests limit, most likely your document will be blocked.

 

Any documentation on how to access data from a multiple page worksheet?

Edit: Ok i get it now after seeing this:

Code (CSharp):

1. public static T GetValue<T> (string docName, GD_Cell cell, int workSheetNumber = 0) {
2.             return GetValue<T>(docName, cell.row, cell.col, workSheetNumber);
3.         }

But isnt there any way of accesing another page using the name instead of the worksheet id?