Unity Google Sheet 연동

using UnityEditor;

[CustomEditor(typeof(Utility.SheetDownloader))]
public class DownloaderEditor : Editor
{
    public override void OnInspectorGUI()
    {
        base.OnInspectorGUI();
        if (GUILayout.Button("Download Scenario"))
        {
            (target as Utility.SheetDownloader).DownloadScenario();
        }
    }
}

public void DownloadScenario()
{
    StartCoroutine(Download(_SHEET_ID, "csv"));
}

private IEnumerator Download(string sheetID, string format)
{
    var url = $"https://docs.google.com/spreadsheets/d/{sheetID}/export?format={format}&sheet={_SHEET_NAME}";
    using (var www = UnityWebRequest.Get(url))
    {
        Debug.Log("Start Downloading...");

        yield return www.SendWebRequest();
        if (www.result != UnityWebRequest.Result.Success) yield break;

        var fileUrl = $"{_SHEET_PATH}/{_SHEET_NAME}.{format}";
        File.WriteAllText(fileUrl, www.downloadHandler.text + "\n");

        Debug.Log("Download Complete.");
    }
}

private static string[] Scopes = { SheetsService.Scope.SpreadsheetsReadonly };

private void Download()
{
    Debug.Log("Start Downloading...");

    GoogleCredential credential;

    // '구글 클라우드/API/사용자 인증 정보/서비스 계정/키/생성'을 통해 다운받은 credetial.json을 로드함
    using (var stream = new FileStream(_CREDENTAIL_URL, FileMode.Open, FileAccess.Read))
    {
        // 인증 생성
        credential = GoogleCredential.FromStream(stream).CreateScoped(Scopes);
    }

    // 인증 정보와 시트 이름을 통해 서비스 생성
    var service = new SheetsService(new BaseClientService.Initializer
    {
        HttpClientInitializer = credential,
        ApplicationName = _APPLICATION_NAME
    });

    var sheetsRequest = service.Spreadsheets.Get(_SCENARIO_SHEET_ID);
    var sheetsResponse = sheetsRequest.Execute();
    var sheets = sheetsResponse.Sheets;
    if (sheets == null || sheets.Count == 0)
    {
        Debug.Log("No data found.");
        return;
    }
    Debug.Log("Request Complete.");

    // 모든 시트에 대해 각각 값을 요청함
    foreach (var sheet in sheets)
    {
        var sheetName = sheet.Properties.Title;
        var request = service.Spreadsheets.Values.Get(_SCENARIO_SHEET_ID, $"{sheetName}!A:H");
        var response = request.Execute();
        var rows = response.Values;

        var fileUrl = $"{_SCENARIO_PATH}/{languageCode}/{sheetName}.csv";
        File.WriteAllText(fileUrl, ToCSV(rows));
        Debug.Log($"File saved : {sheetName}");
    }
}

private string ToCSV(IList<IList<object>> rows)
{
    var mainSb = new StringBuilder();
    foreach (var row in rows)
    {
        var sb = new StringBuilder();
        for (int i = 0; i < row.Count; i++)
        {
            if (row[i].ToString().Contains(","))
            {
                sb.Append($"\"{row[i]}\"");
            }
            else
            {
                sb.Append(row[i]);
            }
            if (i < row.Count - 1)
            {
                sb.Append(",");
            }
        }
        mainSb.Append(sb.ToString());
        mainSb.Append('\n');
    }
    return mainSb.ToString();
}