getComments
List the cells in the workbook that have a comment or note attached, with author, kind (threaded comment vs. legacy note), reply count, and a short text preview. Comments are how a reviewer flags TODOs, justifies a number, or asks a question on a specific cell — read them when auditing, debugging, or completing a partly-built workbook. Returns up to 25 entries; pass offset to page. Use getComment to read the full text or thread for a specific cell.
| Parameter | Type | Description | |
|---|---|---|---|
sheet | string | optional | Restrict to a single sheet by name. Omit to list across the whole workbook. |
offset | integer | optional | Pagination offset; results are returned in pages of 25. |