Skip to content

Insert Comment Activity

The Insert Comment activity enables the addition of descriptive notes or comments to specific cells within a Google Sheet. This is useful for providing context, audit trails, or instructions for manual reviewers within the spreadsheet.

Field Description Requirement
Google sheet name Specifies the reference name of the Google Sheets instance or connection. Required
Sheet name Defines the name of the worksheet tab. If left blank, the active sheet is used. Optional
Row index The numerical index of the row where the comment will be placed (starting from 1). Required
Col index The numerical index of the column where the comment will be placed (starting from 1). Required
Comment The text content of the note to be inserted into the specified cell. Required

Action Types & Examples

Adding Cell Annotations

  • Format: string
  • Example Result: A small orange indicator appears in the cell corner, showing the comment text upon hover.

Implementation Examples

Field Setup

  • Google sheet name: AuditSpreadsheet
  • Sheet name: Logs
  • Row index: 10
  • Col index: 2
  • Comment: This value was verified by the Robusta RPA bot.

Execution Parameters

  • Target Instance: AuditSpreadsheet
  • Action: A comment is inserted into cell B10 in the Logs sheet.

Technical Notes

Row and column indices are 1-based. For example, to target cell A1, use Row index: 1 and Col index: 1. Ensure the Google account has the necessary permissions to edit the document and manage comments.