Google Sheets

GoogleSheets_GetSpreadsheetEditHistory

Report who edited a spreadsheet and when, from Google Drive revisions. Reports the "who" and "when" only — not which cells changed, and it can't revert. 'summary' (default) answers "who last edited this and when" (read from the file's head, so always accurate), plus per-window aggregates (revisions read, contributors, first edit) and a preview of recent edits — computed over a bounded window of history per call. These aggregates describe the whole history only when `is_incomplete` is false; it is true when the scan was resumed from a token and/or more history remains. To answer "when was this first edited?" or "who contributed?" reliably, call from the beginning (no `pagination_token`) and check `is_incomplete` is false. `pagination_token` is returned when more pages remain so you can resume. 'list' returns one page of individual revisions, oldest first. Drive can't sort newest-first, so the most recent individual revisions are on the final page.

Remote googlesheets

Remote (network-hosted)

Other tools also called GoogleSheets_GetSpreadsheetEditHistory? See providers with this name

Input Schema


            {
  "type": "object",
  "properties": {
    "mode": {
      "enum": [
        "summary",
        "list"
      ],
      "type": "string",
      "description": "'summary' (default): the latest edit, plus per-window aggregates (revisions read, contributors, first edit) that cover the whole history only when is_incomplete is false, and a preview of recent edits. 'list': one page of individual revisions."
    },
    "limit": {
      "type": "integer",
      "description": "Max revisions per page in 'list' mode. Between 1 and 50. Defaults to 20. Ignored in 'summary' mode."
    },
    "spreadsheet_id": {
      "type": "string",
      "description": "The id of the spreadsheet to get the edit history for."
    },
    "pagination_token": {
      "type": "string",
      "description": "Token from a previous response's pagination_token, to continue reading more history. Works in both modes."
    }
  }
}