Search code examples
google-sheetsgoogle-sheets-apirichtext

Can I add rich text to google sheets note?


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',
        },
    }

Solution

  • As @Tanaike said, Notes (and Comments) only accept plain-text. However, you can fill a Feature Request in Issue Tracker.