如何访问google sheet、读接口详见
Golang访问Google Sheet
import (
"bytes"
"context"
"fmt"
"golang.org/x/oauth2/google"
"google.golang.org/api/option"
"google.golang.org/api/sheets/v4"
"runtime/debug"
)
type UpdateGoogleSheetByRangeReq struct {
Credentials []byte
SpreadsheetId string
SheetName string
ExcelItemList interface{
}
}
func UpdateGoogleSheetByRangeSrv(ctx context.Context, req *UpdateGoogleSheetByRangeReq) (wfmErr *wfmerror.WFMError) {
defer func() {
if p := recover(); p != nil {
logger.LogErrorf("UpdateGoogleSheetByRangeReq panic=%v, stack=%v", p, string(debug.Stack()))
wfmErr = constant.ErrCommonSystemUnknownErr.NewMessage(fmt.Sprintf("panic=%v", p))
}
}()
// 解析密钥文件
config, err := google.JWTConfigFromJSON(req.Credentials, sheets.SpreadsheetsScope)
if err != nil {
return constant.ErrCommonSystemUnknownErr.NewMessage(err.Error())
}
// 创建 Google Sheets 服务客户端
client := config.Client(ctx)
// 创建 Sheets 服务对象
sheetsService, err := sheets.NewService(ctx, option.WithHTTPClient