val service = ...val spreadsheetId = ...val sheetId = 0val requests = listOf<Request>( // Add Note to D1 Request().setRepeatCell( RepeatCellRequest().apply { range = GridRange().apply { this.sheetId = sheetId startRowIndex = 1 endRowIndex = startRowIndex + 1 startColumnIndex = colToIndex('D') endColumnIndex = startRowIndex + 1 } cell = CellData().apply { note = "1 - Published\n0 - Not published" } fields = "note" } ))val body = BatchUpdateSpreadsheetRequest() .setRequests(requests)service.spreadsheets().batchUpdate(spreadsheetId, body).execute()
fun colToIndex(char: Char): Int { return char.toInt() - 65}
NOTE: service
is Sheets. Refer to Get Google Sheets service instance.
NOTE: Refer to Get Sheet Id.