v1

latestOpenAPI 3.0.32026-08-061874701.5 MB

cells

List cell history

Gets the cell modification history.

Note: Fetching cell history is resource-intensive and is limited to 30 requests per minute per API token. For details, see Rate limiting.

Note: For pagination guidance, refer to Pagination.

get/sheets/{sheetId}/rows/{rowId}/columns/{columnId}/history

Query parameters

include'columnType' | 'objectValue'

A comma-separated list of elements to copy:

columnType - includes the columnType attribute for each Cell object
objectValue - when used in combination with a level query parameter, includes the email addresses for a multi-contact cell.

pageSizenumber

The maximum number of items to return per page. Unless otherwise stated for a specific endpoint, defaults to 100. If only page is specified, defaults to a page size of 100. For reports, the default is 100 rows. If you need larger sets of data from your report, returns a maximum of 10,000 rows per request.

pagenumber

Which page to return. Defaults to 1 if not specified. If you specify a value greater than the total number of pages, the last page of results is returned.

levelinteger

Specifies whether object data types, such as multi-contact data are returned in a backwards-compatible, text format in text/number columns.<br> - Set level=0 (default) to use text/number columns for multi-contact data and multi-picklist data.<br> - Set level=1 to use multiple-entry contact list columns for multi-contact data; multi-picklist data is returned in text/number columns.<br> - Set level=2 to use multiple-entry contact list columns for multi-contact data and use multiple-entry picklist columns for multi-picklist data.

Response

OK.

Note: For pagination guidance, refer to Pagination.

pageNumbernumber

The current page in the full result set that the data array represents. NOTE when a page number greater than totalPages is requested, the last page is instead returned.

pageSizenumber nullable

The number of items in a page. Omitted if there is no limit to page size (and hence, all results are included). Unless otherwise specified, this defaults to 100 for most endpoints.

totalPagesnumber

The total number of pages in the full result set.

totalCountnumber

The total number of items in the full result set.

Example response

{
  "pageNumber": 1,
  "pageSize": 50,
  "totalPages": 25,
  "totalCount": 136,
  "data": [
    {
      "objectValue": {
        "objectType": "ABSTRACT_DATETIME",
        "value": "2025-03-03T16:59:59"
      }
    }
  ]
}