Can I do this by using a Google API? Assume note
is the variable of richtext
'repeatCell': {
'range': {
'sheetId': 0,
'startRowIndex': start_row,
'endRowIndex': end_row + 1,
'startColumnIndex': start_col,
'endColumnIndex': end_col + 1,
},
'cell': {
'note': note,
'userEnteredFormat': {
'backgroundColor': backgroundColor,
'numberFormat': numberFormat,
},
},
'fields': 'note,userEnteredFormat',
},
}
As @Tanaike said, Notes (and Comments) only accept plain-text. However, you can fill a Feature Request in Issue Tracker.