Skip to content

Instantly share code, notes, and snippets.

@cp-sumi-k
Last active November 8, 2022 09:54
Show Gist options
  • Save cp-sumi-k/98977b72ba82213bfde007aa19db30d2 to your computer and use it in GitHub Desktop.
Save cp-sumi-k/98977b72ba82213bfde007aa19db30d2 to your computer and use it in GitHub Desktop.
// https://docs.google.com/spreadsheets/d/<SPREADSHEETID>/edit#gid=<SHEETID>
spreadsheetId := <SPREADSHEETID>
// The A1 notation of cells range to update.
range2 := "A1:C1"
// prepare data for update cells
row := &sheets.ValueRange{
Values: [][]interface{}{{"2", "XYZ", "xyz@gmail.com"}},
}
// update cells in given range
_, err = srv.Spreadsheets.Values.Update(spreadsheetId, range2, row).ValueInputOption("USER_ENTERED").Context(ctx).Do()
if err != nil {
log.Fatal(err)
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment