UnityGoogleSheetsDatabase

Unity Editor tool, which helps design game-logic database (such as characters, weapons, items stats etc.) using Google Spreadsheets.

Disclaimer

This package has been included as a module into NorskaLib repository; this repository will not receive updates!

How to

Install the Package

via Package Manager

To install this package using Unity Package Manager simply insert this address:

https://github.com/NorskaGames/UnityGoogleSheetsDatabase.git

Setup the Spreadsheet

Create your Spreadsheet and make sure you enable access via link:

Hint: Design your database as any relational database (at least stick to 1st normal form: avoid lists inside a cell).

Setup the Container

Define your custom DataContainer and any amount of Data classes as shown below:

using NorskaLib.GoogleSheetsDatabase;

[CreateAssetMenu(fileName = "DataContainer", menuName = "Custom/DataContainer")]
public class DataContainer : DataContainerBase
{
    [PageName("SomeSpreadsheetPage")]
    public List<ExampleData> ExampleData;
}

[System.Serializable]
public class ExampleData
{
    public string Id;

    public float SomeFloat;
    public int SomeInt;
    public string SomeString;
}

Important! Make sure you spell variables names exactly as columns headers in the spreadsheet.

Now you can create DataContainer asset which looks like this: