/v1/drive/files/{fileId}/overviewGlance at a Google Sheet's tabs
One Google Sheet from the caller's own connected account at a glance, without exporting it: for each of its first ten grid tabs, in workbook order, the tab's name, its grid size (rowCount and columnCount as Sheets states them, empty rows included), its first row as header and up to five rows under it as sample, every cell as the sheet shows it. Reach for it to show which tab holds what, or to check a sheet's columns before importing; get_drive_files_fileId_export reads the rows themselves. Answers 409 when the caller has connected no Google account, and Google's own 4xx when the file is not a Google Sheet.
Access class: workspace.
Send request
Use the documented inputs to call this endpoint directly.
Parameters
Values are applied to the request and the example on the right.
Responses
the action's answer
{
"data": {
"tabs": [
{
"columnCount": "string",
"header": "string",
"name": "string",
"rowCount": "string",
"sample": "string"
}
]
}
}a refusal: {"error": "<what a person needs to read>"}. 401 no credential, 402 the plan does not include this, 403 the seat does not, 404 the thing does not exist or is not yours to see.
{
"error": "string"
}