Skip to content

Instantly share code, notes, and snippets.

@cp-sumi-k
Last active November 8, 2022 09:53
Show Gist options
  • Save cp-sumi-k/9d29ccee34c35570a5f14865273f2537 to your computer and use it in GitHub Desktop.
Save cp-sumi-k/9d29ccee34c35570a5f14865273f2537 to your computer and use it in GitHub Desktop.
// https://docs.google.com/spreadsheets/d/<SPREADSHEETID>/edit#gid=<SHEETID>
sheetId := <SHEETID>
spreadsheetId := <SPREADSHEETID>
// Convert sheet ID to sheet name.
response1, err := srv.Spreadsheets.Get(spreadsheetId).Fields("sheets(properties(sheetId,title))").Do()
if err != nil || response1.HTTPStatusCode != 200 {
log.Error(err)
return
}
sheetName := ""
for _, v := range response1.Sheets {
prop := v.Properties
if prop.SheetId == int64(sheetId) {
sheetName = prop.Title
break
}
}
//Append value to the sheet.
row := &sheets.ValueRange{
Values: [][]interface{}{{"1", "ABC", "abc@gmail.com"}},
}
response2, err := srv.Spreadsheets.Values.Append(spreadsheetId, sheetName, row).ValueInputOption("USER_ENTERED").InsertDataOption("INSERT_ROWS").Context(ctx).Do()
if err != nil || response2.HTTPStatusCode != 200 {
log.Error(err)
return
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment