Android (Java/Kotlin) Google Sheets API: Add Note to Cell

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.

❤️ Is this article helpful?

Buy me a coffee ☕ or support my work via PayPal to keep this space 🖖 and ad-free.

Do send some 💖 to @d_luaz or share this article.

✨ By Desmond Lua

A dream boy who enjoys making apps, travelling and making youtube videos. Follow me on @d_luaz

👶 Apps I built

Travelopy - discover travel places in Malaysia, Singapore, Taiwan, Japan.