使用KEY API (而不是OAuth2)通过C#连接Google Sheets

using Google.Apis.Auth.OAuth2;
using Google.Apis.Sheets.v4;
using Google.Apis.Sheets.v4.Data;
using Google.Apis.Services;
using System;
using System.Collections.Generic;

public class GoogleSheetsConnector
{
    private readonly string apiKey;
    private readonly string spreadsheetId;

    public GoogleSheetsConnector(string apiKey, string spreadsheetId)
    {
        this.apiKey = apiKey;
        this.spreadsheetId = spreadsheetId;
    }

    public IList<IList<object>> ReadData(string range)
    {
        var service = new SheetsService(new BaseClientService.Initializer
        {
            ApiKey = apiKey
        });

        var request = service.Spreadsheets.Values.Get(spreadsheetId, range);
        var response = request.Execute();
        return response.Values;
    }

    public void WriteData(string range, IList<IList<object>> data)
    {
        var service = new SheetsService(new BaseClientService.Initializer
        {
            ApiKey = apiKey
        });

        var valueRange = new ValueRange
        {
            Values = data
        };

        var request = service.Spreadsheets.Values.Update(valueRange, spreadsheetId, range);
        request.ValueInputOption = SpreadsheetsResource.ValuesResource.UpdateRequest.ValueInputOptionEnum.USERENTERED;
        var response = request.Execute();
    }
}

public class Program
{
    public static void Main()
    {
        string apiKey = "YOUR_API_KEY";
        string spreadsheetId = "YOUR_SPREADSHEET_ID";
        string range = "Sheet1!A1:B2";

        var connector = new GoogleSheetsConnector(apiKey, spreadsheetId);

        // Read data from Google Sheets
        var data = connector.ReadData(range);
        foreach (var row in data)
        {
            foreach (var cell in row)
            {
                Console.Write(cell + "\t");
            }
            Console.WriteLine();
        }

        // Write data to Google Sheets
        var newData = new List<IList<object>>
        {
            new List<object> { "New Value 1", "New Value 2" },
            new List<object> { "New Value 3", "New Value 4" }
        };
        connector.WriteData(range, newData);
    }
}