UnityGoogleSheetsDatabase

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

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: