Insert anchored note
The Google Sheets Insert Anchored Note tool enables users to seamlessly add comments directly to specific cells within a spreadsheet, enhancing collaboration and data clarity.
Features
- Insert notes anchored to specific spreadsheet cells using A1 notation.
- Support for selecting specific worksheets via worksheet ID.
- Compatible with both My Drive and Shared Drives for flexible storage options.
- Easy integration with Google Sheets API for batch updates.
- User-friendly input parameters including sheet ID, cell reference, and note content.
Benefits
- Enhances team collaboration by providing context directly in spreadsheets.
- Improves data annotation without cluttering the sheet visually.
- Saves time by automating the note insertion process.
- Supports precise targeting of notes to individual cells or ranges.
- Increases productivity with streamlined spreadsheet management.
Description
Insert a note on a spreadsheet cell. See the documentation
Parameters
5 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | Defaults to You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-insert-anchored-note, propName: drive. |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-insert-anchored-note, propName: sheetId. |
| cellrequired | string | The A1 notation of the cell. E.g., |
| contentrequired | string | The comment to add to the spreadsheet. |
| worksheetId | integer | Select a worksheet or provide a worksheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-insert-anchored-note, propName: worksheetId. |