Powershell -为Google sheets append api创建数组

# 引入Google Sheets API的依赖库
Add-Type -Path "Google.Apis.Sheets.v4.dll"
Add-Type -Path "Google.Apis.Auth.dll"

# 设置Google Sheets API的凭据
$credential = Get-Credential
$serviceAccountEmail = "your-service-account-email@your-project-id.iam.gserviceaccount.com"
$scopes = "https://www.googleapis.com/auth/spreadsheets"
$credential = New-Object Google.Apis.Auth.ServiceAccountCredential($serviceAccountEmail, $credential.Password, $scopes)

# 创建Google Sheets服务
$service = New-Object Google.Apis.Sheets.v4.SheetsService(new-object Google.Apis.Services.BaseClientService.Initializer())
$service.HttpClientInitializer = $credential

# 定义要追加的数据数组
$dataArray = @(
    @("John", "Doe", "john.doe@example.com"),
    @("Jane", "Smith", "jane.smith@example.com")
)

# 定义要追加数据的电子表格ID和范围
$spreadsheetId = "your-spreadsheet-id"
$range = "Sheet1!A1:C"

# 创建追加请求
$requestBody = @{
    "values" = $dataArray
}
$request = New-Object Google.Apis.Sheets.v4.Data.ValueRange($requestBody)

# 发送追加请求
$result = $service.Spreadsheets.Values.Append($request, $spreadsheetId, $range)