Retrieve values from a specific range in a Google Sheet. Requires worksheetId (numeric) from a prior google-sheets-list-worksheets call. Use A1 notation for the range without sheet name prefix (e.g., 'A1:D10', 'A:E'). Ideal for: reading configuration data, fetching lookup tables, getting historical data.

Update a single cell value in a Google Sheet. Use this to modify specific cells, update statuses, change balances, or correct data. Provide the cell reference in A1 notation (e.g., 'B2'). Requires worksheetId (numeric) from a prior google-sheets-list-worksheets call. Ideal for: status updates, balance tracking, dashboard values, single-field corrections.

Add a single row of data to a Google Sheet. Use this to log events, track transactions, or append data to spreadsheets. Provide cell values as an array. Ideal for: transaction logs, event tracking, data collection, audit trails.

List all worksheet tabs in a Google Sheets spreadsheet. Returns each sheet's numeric ID, title, and index. Use this to discover available sheets and resolve sheet names to numeric worksheetIds for downstream actions (get-values, add-row, update-cell, etc.).

Add multiple rows of data to a Google Sheet in a single operation. Use this for batch imports or when you need to write many rows at once. More efficient than adding rows one by one. Ideal for: batch imports, bulk data exports, report generation.