How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Google Sheets developerMetadata API

Operations on developer metadata

Google Sheets developerMetadata API is one of 5 APIs that Google Sheets publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

This API exposes 1 JSON Schema definition.

Tagged areas include Developer Metadata. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, authentication docs, a getting-started guide, an API reference, a changelog, and 1 JSON Schema.

This API exposes 2 operations across 2 paths, and defines 8 schemas. It is described by OpenAPI 3.2.0, at version v4.

Requests are made against a single base URL, https://sheets.googleapis.com/v4.

2 operations 2 paths 8 schemas 1 GET1 POST

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
v4
Base URL
https://sheets.googleapis.com/v4
Authentication
OAuth 2.0, API Key
Terms of Service
Resource Areas
1

Authentication & Security 2

Google Sheets developerMetadata API declares 2 security schemes for authenticating requests. It supports OAuth 2.0 (oauth2) using the authorizationCode flow, exposing 5 scopes. An API key is passed in the query as key (apiKey). By default, every request must be authenticated.

  • oauth2 — OAuth 2.0 authentication for accessing user spreadsheets.
  • apiKey — API key for accessing public spreadsheets without user authentication.

Paths & Operations 2

Across 2 paths, the API surfaces 2 operations — 1 GET, 1 POST. Each is listed below with its method, path, parameters, and response codes.

developerMetadata 2

Operations on developer metadata

GET
/spreadsheets/{spreadsheetId}/developerMetadata/{metadataId}
Google Sheets Get Developer Metadata
getDeveloperMetadata 2 params → 200401403404429
POST
/spreadsheets/{spreadsheetId}/developerMetadata:search
Google Sheets Search Developer Metadata
searchDeveloperMetadata 1 param body → 200401403404429

Schemas 8

The contract defines 8 schemas that model the data the API accepts and returns. The most detailed are DeveloperMetadataLookup (7 properties), DeveloperMetadata (5 properties), GridRange (5 properties), DimensionRange (4 properties). Each schema is shown below with its type and property counts.

DeveloperMetadataLocation
object
A location where metadata may be associated in a spreadsheet.
4 properties
Dimension
string
Indicates which dimension an operation should apply to.
ErrorResponse
object
An error response from the API.
1 property
DeveloperMetadata
object
Developer metadata associated with a location or object in a spreadsheet.
5 properties
DataFilter
object
Filter that describes what data should be selected or returned from a request.
3 properties
DeveloperMetadataLookup
object
Selects DeveloperMetadata that matches all of the specified fields.
7 properties
DimensionRange
object
A range along a single dimension on a sheet.
4 properties
GridRange
object
A range on a sheet. All indexes are zero-based.
5 properties

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

google-sheets-developermetadata-api-openapi.yml Raw ↑

Other APIs Google Sheets publishes across the network.

Google Apps Script Spreadsheet Service
Google Sheets Sheets API
Google Sheets Spreadsheets API
Google Sheets Values API
Where this information came from

This is an independent, third-party profile of Google Sheets developerMetadata API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.