Google Sheets API:读取单元格范围值
CloseGoogle Sheets API:读取单元格范围值
Google 官方 spreadsheets.values.get 以GET读取指定表格ID与A1/R1C1范围,需所列OAuth权限之一,返回ValueRange。可选行列方向和显示值形式;日期渲染规则与默认格式相关。费用、配额和完整ValueRange schema未在本页,未访问表格。
Source statements below remain in their published language. Collection, contributor reports and a provider's identity are separate; this page does not certify quality, current availability or permission to execute.
- Stable ID
- cap-571ed5e71b17936cdc09730b
- Card version
- 2
- Updated
- 2026-10-24T18:50:50.3154221+00:00
- Ownership state
- unclaimed
- Processing
- unknown
- Evidence level
- unknown
- Business execution
- unknown
Keep this fixed version · Original public source · Complete machine record
Published description
该v4方法仅获取一个电子表格范围的值,HTTP body为空。本文明确路径和渲染参数,但ValueRange对象详细定义在另页;示例二维数组只是布局说明,不代表任何真实用户表格数据。
Inputs
- spreadsheetId和range两个路径参数必填;range支持A1或R1C1。
- majorDimension控制二维结果主维度,ROWS与COLUMNS会改变同一范围的排列。
- valueRenderOption默认FORMATTED_VALUE;dateTimeRenderOption默认SERIAL_NUMBER,但在FORMATTED_VALUE时被忽略。
Outputs
- 成功响应为ValueRange实例,完整对象字段schema在外部引用页,本附件未展开。
- 文中示例同一2×2范围按ROWS为[[1,2],[3,4]],按COLUMNS为[[1,3],[2,4]];这是示意值。
Invocation and authentication
{
"authentication": {
"kind": "oauth",
"notes": "\u672C\u9875\u660E\u786E\u9700\u8981\u6240\u5217OAuth scopes\u4E4B\u4E00\uFF0C\u5305\u62ECspreadsheets.readonly\u3001spreadsheets\u3001drive.readonly\u3001drive.file\u6216drive\uFF1B\u5177\u4F53\u6388\u6743\u83B7\u53D6\u6D41\u7A0B\u5728\u672A\u6355\u83B7\u6307\u5357\u3002\u672A\u6388\u6743\u6216\u53D6\u5F97\u51ED\u636E\u3002"
},
"command": null,
"entry_url": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}",
"kind": "http_api",
"method": "GET",
"request_example": {
"method": "GET",
"notes": "\u5B98\u65B9\u8303\u56F4/\u65B9\u5411\u8BF4\u660E\u7684\u7ED3\u6784\u5316\u793A\u4F8B\uFF0CID\u4E3A\u5360\u4F4D\u7B26\uFF0C\u672A\u6267\u884C\u3002",
"path_parameters": {
"range": "Sheet1!A1:B2",
"spreadsheetId": "\u003Cspreadsheet-id\u003E"
},
"query": {
"majorDimension": "ROWS"
},
"url_template": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}"
},
"requirements": [
"\u8C03\u7528\u8005\u5FC5\u987B\u63D0\u4F9B\u5B9E\u9645spreadsheetId\u548CA1\u6216R1C1\u8303\u56F4\uFF0C\u5E76\u5177\u5907\u76F8\u5E94OAuth\u6388\u6743\u3002",
"entry_url\u4E3A\u5B98\u65B9\u8DEF\u5F84\u6A21\u677F\uFF0C\u672A\u7ED1\u5B9A\u4EFB\u4F55\u771F\u5B9E\u8868\u683C\uFF1B\u8BF7\u6C42body\u5FC5\u987B\u4E3A\u7A7A\u3002",
"\u672C\u6B21\u4E0D\u767B\u5F55Google\u3001\u4E0D\u6388\u6743\u3001\u4E0D\u8BFB\u53D6\u8868\u683C/\u8D26\u672C\u6216\u8FD0\u884CTry it\u3002"
]
}Commands and request examples are documentation only; this page does not execute them. Confirm external installation, disclosure and fees separately.
Third-party pricing and data handling
{
"model": "unknown",
"notes": "\u8BE5\u65B9\u6CD5\u53C2\u8003\u6CA1\u6709API\u8D39\u7387\u3001\u514D\u8D39\u989D\u5EA6\u6216Google Workspace\u8D26\u53F7\u8BA1\u5212\u6761\u4EF6\u3002",
"source_url": "https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/get"
}{
"location": "provider_server",
"notes": "Google Sheets\u670D\u52A1\u5904\u7406\u8303\u56F4\u8BFB\u53D6\uFF0C\u6388\u6743\u5E94\u7528\u53EF\u63A5\u6536\u5355\u5143\u683C\u6570\u636E\uFF1B\u672C\u9875\u6CA1\u6709\u65E5\u5FD7/\u6570\u636E\u4FDD\u7559\u653F\u7B56\u3002\u672C\u6B21\u672A\u7ED1\u5B9AID\u3001\u8BBF\u95EE\u4EFB\u4F55\u5DE5\u4F5C\u7C3F\u6216\u4F20\u8F93\u771F\u5B9E\u6570\u636E\u3002"
}Unknown is not a claim that a service is free, anonymous, private or unavailable.
Limitations
- 必须有实际表格ID、范围与访问授权,官方路径模板不代表已能访问任意表格。
- 格式化值和日期渲染选项有依赖,不能无条件将返回日期当数值serial或原始内容。
- 本页只述values.get,不推断公式/格式/整份工作簿或写入能力。
- 完整ValueRange、权限授予流程、费用、请求速率、配额和SLA未包含。
Unknowns
- 真实表格访问权限、授权流程、完整ValueRange schema与格式边界未验证。
- 费用/账号计划、数值限流/配额、SLA、日志与数据保留未知。
Fixed profiles, conditions and evidence
Read state: not_checked; review state: unknown. Do not combine different profiles.
资料与来源声明不等于本站实测;未列出的条件仍未知。
结构化配方只按公开声明检查约束与接口,不执行任务或授予权限;缺失记录保持未知,接口兼容不证明实际成功。
Contributor-reported verification
{
"checked_at": "2026-10-24T18:50:01.9224853\u002B00:00",
"checks_performed": [
"\u6765\u6E90HTTPS\u54CD\u5E94\u53EF\u8BFB\u53D6"
],
"evidence_urls": [
"https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/get"
],
"level": "documentation_only",
"not_verified": [
"\u529F\u80FD\u3001\u9274\u6743\u3001\u5B89\u88C5\u3001\u8F93\u51FA\u8D28\u91CF\u3001\u957F\u671F\u53EF\u7528\u6027\u5747\u672A\u7531\u672C\u7AD9\u6D4B\u8BD5\u3002"
],
"outcome": "not_tested",
"reported_by": "contributor",
"software_version": null,
"test_summary": "\u4EC5\u8BFB\u53D6\u516C\u5F00\u6765\u6E90\uFF1B\u672A\u8C03\u7528\u6240\u8FF0\u5DE5\u5177\u3002"
}Connection, installation, execution, output checks and user acceptance are different stages. This is not a commercial call or income receipt.
Dynamic observations and corrections
null
null
Add a public correction or observation
Submit only facts you may disclose, without private tasks, customer data or credentials. Corrections are proposals; observations are conditional contributor reports, not automatically verified facts, commercial calls or income.
Propose a sourced summary correction
Report a conditional public observation
Complete fixed public record and original source fields
This is the existing public read projection, not a translated or rewritten snapshot. Dynamic observations, where present, remain labelled separately from evidence.
{
"author_name": "Google",
"availability": "unknown",
"callability": "documentation_only",
"category": "development",
"data_handling": {
"location": "provider_server",
"notes": "Google Sheets\u670D\u52A1\u5904\u7406\u8303\u56F4\u8BFB\u53D6\uFF0C\u6388\u6743\u5E94\u7528\u53EF\u63A5\u6536\u5355\u5143\u683C\u6570\u636E\uFF1B\u672C\u9875\u6CA1\u6709\u65E5\u5FD7/\u6570\u636E\u4FDD\u7559\u653F\u7B56\u3002\u672C\u6B21\u672A\u7ED1\u5B9AID\u3001\u8BBF\u95EE\u4EFB\u4F55\u5DE5\u4F5C\u7C3F\u6216\u4F20\u8F93\u771F\u5B9E\u6570\u636E\u3002"
},
"description": "\u8BE5v4\u65B9\u6CD5\u4EC5\u83B7\u53D6\u4E00\u4E2A\u7535\u5B50\u8868\u683C\u8303\u56F4\u7684\u503C\uFF0CHTTP body\u4E3A\u7A7A\u3002\u672C\u6587\u660E\u786E\u8DEF\u5F84\u548C\u6E32\u67D3\u53C2\u6570\uFF0C\u4F46ValueRange\u5BF9\u8C61\u8BE6\u7EC6\u5B9A\u4E49\u5728\u53E6\u9875\uFF1B\u793A\u4F8B\u4E8C\u7EF4\u6570\u7EC4\u53EA\u662F\u5E03\u5C40\u8BF4\u660E\uFF0C\u4E0D\u4EE3\u8868\u4EFB\u4F55\u771F\u5B9E\u7528\u6237\u8868\u683C\u6570\u636E\u3002",
"inputs": [
"spreadsheetId\u548Crange\u4E24\u4E2A\u8DEF\u5F84\u53C2\u6570\u5FC5\u586B\uFF1Brange\u652F\u6301A1\u6216R1C1\u3002",
"majorDimension\u63A7\u5236\u4E8C\u7EF4\u7ED3\u679C\u4E3B\u7EF4\u5EA6\uFF0CROWS\u4E0ECOLUMNS\u4F1A\u6539\u53D8\u540C\u4E00\u8303\u56F4\u7684\u6392\u5217\u3002",
"valueRenderOption\u9ED8\u8BA4FORMATTED_VALUE\uFF1BdateTimeRenderOption\u9ED8\u8BA4SERIAL_NUMBER\uFF0C\u4F46\u5728FORMATTED_VALUE\u65F6\u88AB\u5FFD\u7565\u3002"
],
"invocation": {
"authentication": {
"kind": "oauth",
"notes": "\u672C\u9875\u660E\u786E\u9700\u8981\u6240\u5217OAuth scopes\u4E4B\u4E00\uFF0C\u5305\u62ECspreadsheets.readonly\u3001spreadsheets\u3001drive.readonly\u3001drive.file\u6216drive\uFF1B\u5177\u4F53\u6388\u6743\u83B7\u53D6\u6D41\u7A0B\u5728\u672A\u6355\u83B7\u6307\u5357\u3002\u672A\u6388\u6743\u6216\u53D6\u5F97\u51ED\u636E\u3002"
},
"command": null,
"entry_url": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}",
"kind": "http_api",
"method": "GET",
"request_example": {
"method": "GET",
"notes": "\u5B98\u65B9\u8303\u56F4/\u65B9\u5411\u8BF4\u660E\u7684\u7ED3\u6784\u5316\u793A\u4F8B\uFF0CID\u4E3A\u5360\u4F4D\u7B26\uFF0C\u672A\u6267\u884C\u3002",
"path_parameters": {
"range": "Sheet1!A1:B2",
"spreadsheetId": "\u003Cspreadsheet-id\u003E"
},
"query": {
"majorDimension": "ROWS"
},
"url_template": "https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}"
},
"requirements": [
"\u8C03\u7528\u8005\u5FC5\u987B\u63D0\u4F9B\u5B9E\u9645spreadsheetId\u548CA1\u6216R1C1\u8303\u56F4\uFF0C\u5E76\u5177\u5907\u76F8\u5E94OAuth\u6388\u6743\u3002",
"entry_url\u4E3A\u5B98\u65B9\u8DEF\u5F84\u6A21\u677F\uFF0C\u672A\u7ED1\u5B9A\u4EFB\u4F55\u771F\u5B9E\u8868\u683C\uFF1B\u8BF7\u6C42body\u5FC5\u987B\u4E3A\u7A7A\u3002",
"\u672C\u6B21\u4E0D\u767B\u5F55Google\u3001\u4E0D\u6388\u6743\u3001\u4E0D\u8BFB\u53D6\u8868\u683C/\u8D26\u672C\u6216\u8FD0\u884CTry it\u3002"
]
},
"limitations": [
"\u5FC5\u987B\u6709\u5B9E\u9645\u8868\u683CID\u3001\u8303\u56F4\u4E0E\u8BBF\u95EE\u6388\u6743\uFF0C\u5B98\u65B9\u8DEF\u5F84\u6A21\u677F\u4E0D\u4EE3\u8868\u5DF2\u80FD\u8BBF\u95EE\u4EFB\u610F\u8868\u683C\u3002",
"\u683C\u5F0F\u5316\u503C\u548C\u65E5\u671F\u6E32\u67D3\u9009\u9879\u6709\u4F9D\u8D56\uFF0C\u4E0D\u80FD\u65E0\u6761\u4EF6\u5C06\u8FD4\u56DE\u65E5\u671F\u5F53\u6570\u503Cserial\u6216\u539F\u59CB\u5185\u5BB9\u3002",
"\u672C\u9875\u53EA\u8FF0values.get\uFF0C\u4E0D\u63A8\u65AD\u516C\u5F0F/\u683C\u5F0F/\u6574\u4EFD\u5DE5\u4F5C\u7C3F\u6216\u5199\u5165\u80FD\u529B\u3002",
"\u5B8C\u6574ValueRange\u3001\u6743\u9650\u6388\u4E88\u6D41\u7A0B\u3001\u8D39\u7528\u3001\u8BF7\u6C42\u901F\u7387\u3001\u914D\u989D\u548CSLA\u672A\u5305\u542B\u3002"
],
"outputs": [
"\u6210\u529F\u54CD\u5E94\u4E3AValueRange\u5B9E\u4F8B\uFF0C\u5B8C\u6574\u5BF9\u8C61\u5B57\u6BB5schema\u5728\u5916\u90E8\u5F15\u7528\u9875\uFF0C\u672C\u9644\u4EF6\u672A\u5C55\u5F00\u3002",
"\u6587\u4E2D\u793A\u4F8B\u540C\u4E002\u00D72\u8303\u56F4\u6309ROWS\u4E3A[[1,2],[3,4]]\uFF0C\u6309COLUMNS\u4E3A[[1,3],[2,4]]\uFF1B\u8FD9\u662F\u793A\u610F\u503C\u3002"
],
"pricing": {
"model": "unknown",
"notes": "\u8BE5\u65B9\u6CD5\u53C2\u8003\u6CA1\u6709API\u8D39\u7387\u3001\u514D\u8D39\u989D\u5EA6\u6216Google Workspace\u8D26\u53F7\u8BA1\u5212\u6761\u4EF6\u3002",
"source_url": "https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/get"
},
"provider_claimed": false,
"record_kind": "public_source",
"representative_queries": [],
"sources": [
{
"basis": "official_documentation",
"checked_at": "2026-10-25T02:50:01.9224853\u002B08:00",
"title": "Method: spreadsheets.values.get \u00A0|\u00A0 Google Sheets \u00A0|\u00A0 Google for Developers",
"url": "https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/get"
}
],
"summary": "Google \u5B98\u65B9 spreadsheets.values.get \u4EE5GET\u8BFB\u53D6\u6307\u5B9A\u8868\u683CID\u4E0EA1/R1C1\u8303\u56F4\uFF0C\u9700\u6240\u5217OAuth\u6743\u9650\u4E4B\u4E00\uFF0C\u8FD4\u56DEValueRange\u3002\u53EF\u9009\u884C\u5217\u65B9\u5411\u548C\u663E\u793A\u503C\u5F62\u5F0F\uFF1B\u65E5\u671F\u6E32\u67D3\u89C4\u5219\u4E0E\u9ED8\u8BA4\u683C\u5F0F\u76F8\u5173\u3002\u8D39\u7528\u3001\u914D\u989D\u548C\u5B8C\u6574ValueRange schema\u672A\u5728\u672C\u9875\uFF0C\u672A\u8BBF\u95EE\u8868\u683C\u3002",
"tags": [
"http_api",
"documentation_only",
"spreadsheet_reading"
],
"terms_url": null,
"title": "Google Sheets API\uFF1A\u8BFB\u53D6\u5355\u5143\u683C\u8303\u56F4\u503C",
"unknowns": [
"\u771F\u5B9E\u8868\u683C\u8BBF\u95EE\u6743\u9650\u3001\u6388\u6743\u6D41\u7A0B\u3001\u5B8C\u6574ValueRange schema\u4E0E\u683C\u5F0F\u8FB9\u754C\u672A\u9A8C\u8BC1\u3002",
"\u8D39\u7528/\u8D26\u53F7\u8BA1\u5212\u3001\u6570\u503C\u9650\u6D41/\u914D\u989D\u3001SLA\u3001\u65E5\u5FD7\u4E0E\u6570\u636E\u4FDD\u7559\u672A\u77E5\u3002"
],
"verification": {
"checked_at": "2026-10-24T18:50:01.9224853\u002B00:00",
"checks_performed": [
"\u6765\u6E90HTTPS\u54CD\u5E94\u53EF\u8BFB\u53D6"
],
"evidence_urls": [
"https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/get"
],
"level": "documentation_only",
"not_verified": [
"\u529F\u80FD\u3001\u9274\u6743\u3001\u5B89\u88C5\u3001\u8F93\u51FA\u8D28\u91CF\u3001\u957F\u671F\u53EF\u7528\u6027\u5747\u672A\u7531\u672C\u7AD9\u6D4B\u8BD5\u3002"
],
"outcome": "not_tested",
"reported_by": "contributor",
"software_version": null,
"test_summary": "\u4EC5\u8BFB\u53D6\u516C\u5F00\u6765\u6E90\uFF1B\u672A\u8C03\u7528\u6240\u8FF0\u5DE5\u5177\u3002"
},
"schema_version": "navonavo.capability.v1",
"service_id": "cap-571ed5e71b17936cdc09730b",
"version": 2,
"source_url": "https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/get",
"ownership_state": "unclaimed",
"submitted_by": {
"kind": "importer",
"name": "NAVONAVO public material importer"
},
"submitter_identity_verified": false,
"source_check": {
"url": "https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/get",
"final_url": "https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/get",
"status_code": 200,
"title": "Method: spreadsheets.values.get \u00A0|\u00A0 Google Sheets \u00A0|\u00A0 Google for Developers",
"description": null,
"checked_at": "2026-10-24T18:50:01.9224853\u002B00:00",
"warnings": [
"\u6765\u6E90\u53EF\u8BFB\u53D6\u53EA\u8BC1\u660E\u672C\u6B21\u8D44\u6599\u8BFB\u53D6\uFF0C\u4E0D\u662F\u529F\u80FD\u3001\u8EAB\u4EFD\u6216\u957F\u671F\u53EF\u7528\u6027\u8BA4\u8BC1\u3002"
]
},
"created_at": "2026-10-24T18:50:05.2103389\u002B00:00",
"updated_at": "2026-10-24T18:50:50.3154221\u002B00:00",
"read_url": "https://navonavo.com/api/v1/capabilities/cap-571ed5e71b17936cdc09730b?version=2",
"page_url": "https://navonavo.com/capabilities/cap-571ed5e71b17936cdc09730b?version=2",
"verification_scope": "verification\u4E3A\u6295\u7A3F\u8005\u4E0A\u62A5\uFF1Bsource_check\u4EC5\u4E3A\u672C\u7AD9\u6765\u6E90\u8BFB\u53D6\uFF0C\u4E0D\u5347\u7EA7\u4E3A\u529F\u80FD\u9A8C\u8BC1\u6216\u5B98\u65B9\u8BA4\u8BC1\u3002",
"library_material": {
"organization": "organized",
"semantic_state": "classified",
"semantic_category": "\u529E\u516C\u6570\u636E\uFF0FGoogle Sheets \u6307\u5B9A\u8303\u56F4\u53EA\u8BFB\u53D6\u503C",
"evidence_grade": "documentation_only",
"attachments": [
{
"material_id": "material-5bacce26f75f7ac40a46f20752829145",
"source_url": "https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/get",
"content_sha256": "0c4ff375ca46f269a160210700a11a641b5fce14e78f0034f206c23c4f110edc",
"decoded_bytes": 162444,
"content_type": "text/html",
"captured_at": "2026-10-24T18:50:01.9224853\u002B00:00",
"text_representation": "decoded_text_utf8",
"text_utf8_sha256": "0c4ff375ca46f269a160210700a11a641b5fce14e78f0034f206c23c4f110edc",
"text_utf8_bytes": 162444,
"capture_body_reconstructed": true,
"read_path": "/api/v1/capabilities/cap-571ed5e71b17936cdc09730b/materials/material-5bacce26f75f7ac40a46f20752829145?version=1"
}
]
},
"last_correction": {
"contribution_id": "contribution-f76b3387ebd343bbbe5868c6092df1e8",
"reason": "\u4F9D\u636E\u672C\u6279Google spreadsheets.values.get\u660E\u786EHTTPS\u6A21\u677F\u3001GET/\u7A7Abody\u3001ID/range\u3001\u6E32\u67D3\u9009\u9879\u548COAuth scopes\u6574\u7406\uFF0C\u79FB\u9664\u672A\u6574\u7406\u6807\u7B7E\u3002\u4EC5documentation_only\uFF0C\u672A\u7ED1\u5B9A\u6216\u8BBF\u95EE\u771F\u5B9E\u8868\u683C/\u8D26\u672C\uFF1B\u5B8C\u6574ValueRange\u3001\u8D39\u7528\u53CA\u989D\u5EA6\u4FDD\u672A\u77E5\u3002",
"source_urls": [
"https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/get"
],
"reported_by": "contributor"
},
"version_read_basis": "archived_revision",
"deep_read": {
"schema_version": "navonavo.capability-read.v1",
"card_id": "cap-571ed5e71b17936cdc09730b",
"card_version": 2,
"selected_profile_id": null,
"state": "not_checked",
"review_state": null,
"read_url": "https://navonavo.com/api/v1/capabilities/cap-571ed5e71b17936cdc09730b?version=2",
"page_url": "https://navonavo.com/capabilities/cap-571ed5e71b17936cdc09730b?version=2",
"profiles": [],
"warnings": [
"\u8D44\u6599\u4E0E\u6765\u6E90\u58F0\u660E\u4E0D\u7B49\u4E8E\u672C\u7AD9\u5B9E\u6D4B\uFF1B\u672A\u5217\u51FA\u7684\u6761\u4EF6\u4ECD\u672A\u77E5\u3002",
"\u7ED3\u6784\u5316\u914D\u65B9\u53EA\u6309\u516C\u5F00\u58F0\u660E\u68C0\u67E5\u7EA6\u675F\u4E0E\u63A5\u53E3\uFF0C\u4E0D\u6267\u884C\u4EFB\u52A1\u6216\u6388\u4E88\u6743\u9650\uFF1B\u7F3A\u5931\u8BB0\u5F55\u4FDD\u6301\u672A\u77E5\uFF0C\u63A5\u53E3\u517C\u5BB9\u4E0D\u8BC1\u660E\u5B9E\u9645\u6210\u529F\u3002"
]
}
}