https://blog.canopas.com/golang-interacting-with-google-spreadsheets-b381f819c2eb - batch-update

batch-update.go

// https://docs.google.com/spreadsheets/d/<SPREADSHEETID>/edit#gid=<SHEETID>
sheetId := <SHEETID>
spreadsheetId := <SPREADSHEETID>

records := []string{"1", "ABC", "[email protected]"}

// create the batch request
batchUpdateRequest := sheets.BatchUpdateSpreadsheetRequest{
	Requests: []*sheets.Request{
		{
			AppendCells: &sheets.AppendCellsRequest{
				Fields:  "*",  // for adding data in all cells
				Rows:    prepareCells(records),  // get formatted cells row
				SheetId: int64(sheetId),  // use sheetID here
			},
		},
	},
}

// execute the request using spreadsheetId
res, err := srv.Spreadsheets.BatchUpdate(spreadsheetId, &batchUpdateRequest).Context(ctx).Do()
if err != nil || res.HTTPStatusCode != 200 {
	log.Error(err)
	return
}