如何使用程序(c# nodejs)通过谷歌报表接口获取“应用使用活动”报表

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

// 创建一个用户凭据对象
UserCredential credential;
using (var stream = new FileStream("path_to_your_credentials_file.json", FileMode.Open, FileAccess.Read))
{
    credential = GoogleCredential.FromStream(stream)
        .CreateScoped(SheetsService.Scope.SpreadsheetsReadonly)
        .UnderlyingCredential as UserCredential;
}

// 创建一个谷歌表服务对象
var service = new SheetsService(new BaseClientService.Initializer()
{
    HttpClientInitializer = credential,
    ApplicationName = "Your Application Name",
});

// 指定报表的ID和范围
string spreadsheetId = "your_spreadsheet_id";
string range = "Sheet1!A1:B10";

// 发起请求获取报表数据
var request = service.Spreadsheets.Values.Get(spreadsheetId, range);
var response = request.Execute();

// 处理报表数据
var values = response.Values;
if (values != null && values.Count > 0)
{
    foreach (var row in values)
    {
        // 处理每一行数据
        string column1 = row[0].ToString();
        string column2 = row[1].ToString();
        // ...
    }
}