How to get Google Spreadsheet data to Unity. Put Google Api + Auth + Sheets .dll into your project. Then put .p12 service account file somewhere in Assets.

GoogleSpreadsheetUnity.cs

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;

using Google.Apis.Auth.OAuth2;
using Google.Apis.Sheets.v4;
using Google.Apis.Sheets.v4.Data;
using Google.Apis.Services;

using System.Security.Cryptography.X509Certificates;

using UnityEngine;
using UnityEditor;

class LevelSynchronizer
{
    const string spreadsheetId = "1sakdfj0392029482_sajfalsdfhlsadkfsak";
    const string sheetNameAndRange = "MySheet"; //You can also put a cell range here
    const string p12PathFromAsset = "Plugins/example-23948239f.p12";

    public static void SyncLevel()
    {
        String serviceAccountEmail = "[email protected]";

        var certificate = new X509Certificate2(Application.dataPath + Path.DirectorySeparatorChar + p12PathFromAsset, "notasecret", X509KeyStorageFlags.Exportable);

        ServiceAccountCredential credential = new ServiceAccountCredential(
           new ServiceAccountCredential.Initializer(serviceAccountEmail)
           {
               Scopes = new[] { SheetsService.Scope.SpreadsheetsReadonly } 
               /*
                Without this scope, it will :

                GoogleApiException: Google.Apis.Requests.RequestError
                Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential.

                lol..
                */
           }.FromCertificate(certificate));


        var service = new SheetsService(new BaseClientService.Initializer()
        {
            HttpClientInitializer = credential,
        });

        SpreadsheetsResource.ValuesResource.GetRequest request = service.Spreadsheets.Values.Get(spreadsheetId, sheetNameAndRange);

        StringBuilder sb = new StringBuilder();

        ValueRange response = request.Execute();
        IList<IList<object>> values = response.Values;
        if (values != null && values.Count > 0)
        {
            foreach (IList<object> row in values)
            {
                foreach(object cell in row)
                {
                    sb.Append(cell.ToString() + " ");
                }
                //Concat the whole row
                Debug.Log(sb.ToString());
                sb.Clear();
            }
        }
        else
        {
            Debug.Log("No data found.");
        }
    }
}

This works for Editor.

If you are making a build which reads from Google Sheets and the X509Certificate2 is having trouble accessing the Resouce Folder, replace the P12 file extension as .bytes

Then use the code

TextAsset p12 = Resources.Load(P12FileNameWithoutExtension);
var certificate = new X509Certificate2(p12.bytes, Password, X509KeyStorageFlags.Exportable);

I recently improved an automated Google Sheets importer plugin fo unity here: https://github.com/ssmasrour/Google-Sheets-to-Unity

It may help you to make it easy to coordinate with your data sheets [cheers]

I recently improved an automated Google Sheets importer plugin fo unity here: https://github.com/ssmasrour/Google-Sheets-to-Unity

It may help you to make it easy to coordinate with your data sheets [cheers]

Awesome! Looks great!