好了，经过一些试用后，有一个答案。一切都是相同https://developers.google.com/sheets/quickstart/go只是改变了主要功能
func write() { ctx := context.Background() b, err := ioutil.ReadFile("./Google_Sheets_API_Quickstart/client_secret.json") if err != nil { log.Fatalf("Unable to read client secret file: %v", err) }// If modifying these scopes, delete your previously saved credentials// at ~/.credentials/sheets.googleapis.com-go-quickstart.json config, err := google.ConfigFromJSON(b, "https://www.googleapis.com/auth/spreadsheets") if err != nil { log.Fatalf("Unable to parse client secret file to config: %v", err) } client := getClient(ctx, config) srv, err := sheets.New(client) if err != nil { log.Fatalf("Unable to retrieve Sheets Client %v", err) } spreadsheetId := "YOUR SPREADSHEET ID" writeRange := "A1" var vr sheets.ValueRange myval := []interface{}{"One", "Two", "Three"} vr.Values = append(vr.Values, myval) _, err = srv.Spreadsheets.Values.Update(spreadsheetId, writeRange, &vr).ValueInputOption("RAW").Do() if err != nil { log.Fatalf("Unable to retrieve data from sheet. %v", err) }}
