Every API here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for apis
7 MCP tools reach this
find_apisBrowse and filter every API in the catalog.
get_api_artifactsOne API's artifacts, grouped by type.
get_openapiThe primary OpenAPI for this API.
find_similar_apisAPIs that look like this one.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.
All 92 tools →
Call it yourself
curl for this page
This API
curl "https://apis.io/api/v1/apis/mcpweave-com:mcpweave-com-google-sheets-rest-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"
Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we
store it to create your key and to recognise you if you sign in with another
provider. By signing up you are subscribing to the APIs.io and API Evangelist
newsletters — you can unsubscribe from any issue. See our
Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.
openapi: 3.2.0
info:
title: mcpweave Google Sheets Rest API
description: Asia-native MCP Gateway — Native pass-through, FastMCP, Paddle+Toss billing
version: '2026-04-27'
tags:
- name: google_sheets-rest
paths:
/api/v1/google_sheets/v4/spreadsheets:
post:
tags:
- google_sheets-rest
summary: 새 spreadsheet 생성 (write)
description: '새 Google spreadsheet 생성. 응답에 ``spreadsheetId`` 포함 — 이후 다른
op 의 path parameter 로 사용.
body 핵심 필드 (모두 선택 — 빈 body 도 OK):
properties.title : "내 보고서 2026-Q1"
sheets[] : 초기 시트 list (미입력 시 "Sheet1" 1개)
Note: ``drive.file`` scope 필요 (새 파일 = Drive 등록).
**Destructive write — 새 Drive 파일 생성**.'
operationId: google_sheets_create_spreadsheet
parameters:
- name: connection_id
in: query
required: true
schema:
type: string
description: mcpweave connection_id
title: Connection Id
description: mcpweave connection_id
- name: X-API-Key
in: header
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: X-Api-Key
- name: mcpweave_session
in: cookie
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Mcpweave Session
requestBody:
content:
application/json:
schema:
anyOf:
- type: object
additionalProperties: true
- type: 'null'
title: Body
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
default:
description: Native cafe24 response (200) or gateway error envelope (4xx/5xx)
/api/v1/google_sheets/v4/spreadsheets/{spreadsheetId}:
get:
tags:
- google_sheets-rest
summary: spreadsheet 메타데이터 조회
description: 'spreadsheet 의 메타 + 모든 sheet 목록 + 기본 properties.
BYOC 검증용으로도 호출 (가벼운 read).
``includeGridData=true`` 면 모든 cell 데이터까지 반환 (기본 false).
Phase 1 = 메타데이터만 (cell 데이터는 ``get_values``).
Native pass-through.'
operationId: google_sheets_get_spreadsheet
parameters:
- name: spreadsheetId
in: path
required: true
schema:
type: string
title: Spreadsheetid
- name: connection_id
in: query
required: true
schema:
type: string
description: mcpweave connection_id
title: Connection Id
description: mcpweave connection_id
- name: includeGridData
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Includegriddata
- name: ranges
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Ranges
- name: X-API-Key
in: header
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: X-Api-Key
- name: mcpweave_session
in: cookie
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Mcpweave Session
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
default:
description: Native cafe24 response (200) or gateway error envelope (4xx/5xx)
/api/v1/google_sheets/v4/spreadsheets/{spreadsheetId}/values/{range}:
get:
tags:
- google_sheets-rest
summary: range 의 cell 값 읽기
description: 'A1 notation range (예: ``Sheet1!A1:C10``) 의 cell 값 반환. 응답:
{"range": "''Sheet1''!A1:C10", "majorDimension": "ROWS", "values": [["..."], ...]}
Sheet name quoting (GS-SHEETNAME-QUOTING, dogfood 발견):
- input: ``Sheet1!A1:C10`` 또는 ``''Sheet1''!A1:C10`` 둘 다 허용
- **응답에서는 항상 single-quote wrapped** (``''Sheet1''!A1:C10``)
- 한국어 / 공백 / 특수문자 포함 sheet name 은 항상 quote 권장 (e.g. ``''주문 데이터''!A1``)
valueRenderOption (default ``FORMATTED_VALUE``):
FORMATTED_VALUE : formula 결과 + 숫자 형식 적용 (locale-aware — Google account 의 locale/timezone 따름)
UNFORMATTED_VALUE: formula 결과만 (raw)
FORMULA : formula 자체 (e.g. ``=A1+B1``, ``=NOW()``)
Dynamic formula recalc (GS-FORMULA-RECALC, dogfood 발견):
- ``=NOW()`` / ``=TODAY()`` 등은 **read 마다 재계산**.
- immutable audit timestamp 가 필요한 경우 (cafe24 주문 created_at 등)
ISO8601 string 직접 입력 권장 (e.g. ``2026-05-04T11:30:00+09:00``).
Native pass-through.'
operationId: google_sheets_get_values
parameters:
- name: spreadsheetId
in: path
required: true
schema:
type: string
title: Spreadsheetid
- name: range
in: path
required: true
schema:
type: string
title: Range
- name: connection_id
in: query
required: true
schema:
type: string
description: mcpweave connection_id
title: Connection Id
description: mcpweave connection_id
- name: valueRenderOption
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Valuerenderoption
- name: dateTimeRenderOption
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Datetimerenderoption
- name: majorDimension
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Majordimension
- name: X-API-Key
in: header
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: X-Api-Key
- name: mcpweave_session
in: cookie
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Mcpweave Session
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
default:
description: Native cafe24 response (200) or gateway error envelope (4xx/5xx)
put:
tags:
- google_sheets-rest
summary: range 의 cell 값 덮어쓰기 (write)
description: 'body 의 values 로 range cell 덮어쓰기. range 가 values 보다 크면
남은 cell 은 그대로 유지.
body 핵심 필드:
range (선택, path 와 일치 권장)
majorDimension (선택, 기본 ROWS)
values (필수) — [[..., ...], [..., ...]] 형식
valueInputOption (query, 필수):
USER_ENTERED : formula evaluate, 자동 type 추론 (mcpweave default 권장)
RAW : 입력된 그대로 string 처리
**Destructive write — 기존 cell 덮어씀**.'
operationId: google_sheets_update_values
parameters:
- name: spreadsheetId
in: path
required: true
schema:
type: string
title: Spreadsheetid
- name: range
in: path
required: true
schema:
type: string
title: Range
- name: connection_id
in: query
required: true
schema:
type: string
description: mcpweave connection_id
title: Connection Id
description: mcpweave connection_id
- name: valueInputOption
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Valueinputoption
- name: X-API-Key
in: header
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: X-Api-Key
- name: mcpweave_session
in: cookie
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Mcpweave Session
requestBody:
content:
application/json:
schema:
anyOf:
- type: object
additionalProperties: true
- type: 'null'
title: Body
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
default:
description: Native cafe24 response (200) or gateway error envelope (4xx/5xx)
/api/v1/google_sheets/v4/spreadsheets/{spreadsheetId}/values/{range}:append:
post:
tags:
- google_sheets-rest
summary: range 끝에 행 추가 (write — 핵심 자동화 op)
description: '지정 range 의 마지막 행 다음에 새 행 append. 가장 빈번한 자동화 use
case (cafe24 주문 → Sheets 자동 정리).
insertDataOption (query, 기본 ``OVERWRITE``):
INSERT_ROWS : 기존 행 사이에 새 행 삽입 (mcpweave default 권장 — 안전)
OVERWRITE : 빈 cell 만 채움, 기존 데이터 덮어쓸 수 있음
valueInputOption: USER_ENTERED (기본) / RAW.
Grid auto-expand (GS-GRID-AUTOEXPAND, dogfood 발견):
- sheet 의 default rowCount=100 — append 가 100 초과 시 grid 자동 확장 (101 이상).
- 큰 batch append (수백~수천 행) 도 가능하지만 quota 영향 (60 write/min/user 제한).
응답 shape (dogfood 검증):
{
"tableRange": "''Sheet1''!A1:F3", ← 검색 시점의 끝 (append 직전)
"updates": {
"spreadsheetId": "...",
"updatedRange": "''Sheet1''!A4:F4", ← 새로 추가된 정확한 위치
"updatedRows": 1,
"updatedColumns": 6,
"updatedCells": 6
}
}
``updates.updatedRange`` 로 다음 row 위치 추적 가능 (workflow 자동화 시).
**Destructive write — 행 추가**.'
operationId: google_sheets_append_row
parameters:
- name: spreadsheetId
in: path
required: true
schema:
type: string
title: Spreadsheetid
- name: range
in: path
required: true
schema:
type: string
title: Range
- name: connection_id
in: query
required: true
schema:
type: string
description: mcpweave connection_id
title: Connection Id
description: mcpweave connection_id
- name: valueInputOption
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Valueinputoption
- name: insertDataOption
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Insertdataoption
- name: X-API-Key
in: header
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: X-Api-Key
- name: mcpweave_session
in: cookie
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Mcpweave Session
requestBody:
content:
application/json:
schema:
anyOf:
- type: object
additionalProperties: true
- type: 'null'
title: Body
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
default:
description: Native cafe24 response (200) or gateway error envelope (4xx/5xx)
/api/v1/google_sheets/v4/spreadsheets/{spreadsheetId}:batchUpdate:
post:
tags:
- google_sheets-rest
summary: spreadsheet 일괄 업데이트 (write — 50+ request type, 가장 powerful)
description: 'Sheets 의 가장 강력한 op. body 의 ``requests[]`` 배열에 50+ request
type 의 union 을 담아 sheet add/delete, row/col insert/delete,
formula/formatting 적용, chart/pivotTable/banding 추가, mergeCells
등 거의 모든 고급 기능 처리.
대표 request type:
- ``addSheet`` / ``deleteSheet`` / ``updateSheetProperties``
- ``insertRange`` / ``deleteRange`` / ``insertDimension`` / ``deleteDimension``
- ``updateCells`` / ``mergeCells`` / ``unmergeCells``
- ``addChart`` / ``addPivotTable`` / ``addBanding``
- ``setBasicFilter`` / ``setDataValidation`` / ``addProtectedRange``
body 예시 (sheet 1개 추가 + 행 5개 삽입):
{
"requests": [
{"addSheet": {"properties": {"title": "Q1 Report"}}},
{"insertDimension": {"range": {"sheetId": 0, "dimension": "ROWS",
"startIndex": 1, "endIndex": 6}}}
],
"responseIncludeGridData": false
}
delete row 가 필요하면 ``deleteDimension`` request 사용 (clear_values 는 값만 비움 — row 자체는 보존).
**Destructive write — 매우 broad, validate before apply** (atomic — 1 request 실패 시 전체 rollback).'
operationId: google_sheets_batch_update
parameters:
- name: spreadsheetId
in: path
required: true
schema:
type: string
title: Spreadsheetid
- name: connection_id
in: query
required: true
schema:
type: string
description: mcpweave connection_id
title: Connection Id
description: mcpweave connection_id
- name: X-API-Key
in: header
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: X-Api-Key
- name: mcpweave_session
in: cookie
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Mcpweave Session
requestBody:
content:
application/json:
schema:
anyOf:
- type: object
additionalProperties: true
- type: 'null'
title: Body
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
default:
description: Native cafe24 response (200) or gateway error envelope (4xx/5xx)
/api/v1/google_sheets/v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo:
post:
tags:
- google_sheets-rest
summary: sheet 를 다른 spreadsheet 로 복사 (write)
description: '한 spreadsheet 의 sheet 1개를 다른 spreadsheet 로 복사. 응답에 새
spreadsheet 의 ``properties`` (sheetId / title / index 등) 반환.
body:
{"destinationSpreadsheetId": ""}
같은 spreadsheet 내 복사는 ``batch_update`` 의 ``duplicateSheet``
request 사용.
**Destructive write — 새 sheet 생성 (target spreadsheet 에)**.'
operationId: google_sheets_copy_sheet
parameters:
- name: spreadsheetId
in: path
required: true
schema:
type: string
title: Spreadsheetid
- name: sheetId
in: path
required: true
schema:
type: string
title: Sheetid
- name: connection_id
in: query
required: true
schema:
type: string
description: mcpweave connection_id
title: Connection Id
description: mcpweave connection_id
- name: X-API-Key
in: header
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: X-Api-Key
- name: mcpweave_session
in: cookie
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Mcpweave Session
requestBody:
content:
application/json:
schema:
anyOf:
- type: object
additionalProperties: true
- type: 'null'
title: Body
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
default:
description: Native cafe24 response (200) or gateway error envelope (4xx/5xx)
/api/v1/google_sheets/v4/spreadsheets/{spreadsheetId}/values:batchGet:
get:
tags:
- google_sheets-rest
summary: 다중 range 동시 read
description: '여러 range 를 1번 호출로 read (단일 range read 보다 quota / latency 효율).
``ranges`` query parameter 는 multi-value (e.g. ``?ranges=Sheet1!A1:B2&ranges=Sheet1!D1:D5``).
응답 = ``{spreadsheetId, valueRanges: [{range, majorDimension, values}, ...]}``.
valueRenderOption / dateTimeRenderOption / majorDimension 모두
get_values 와 동일 enum.
Native pass-through.'
operationId: google_sheets_batch_get_values
parameters:
- name: spreadsheetId
in: path
required: true
schema:
type: string
title: Spreadsheetid
- name: connection_id
in: query
required: true
schema:
type: string
description: mcpweave connection_id
title: Connection Id
description: mcpweave connection_id
- name: ranges
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Ranges
- name: valueRenderOption
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Valuerenderoption
- name: dateTimeRenderOption
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Datetimerenderoption
- name: majorDimension
in: query
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Majordimension
- name: X-API-Key
in: header
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: X-Api-Key
- name: mcpweave_session
in: cookie
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Mcpweave Session
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
default:
description: Native cafe24 response (200) or gateway error envelope (4xx/5xx)
/api/v1/google_sheets/v4/spreadsheets/{spreadsheetId}/values:batchUpdate:
post:
tags:
- google_sheets-rest
summary: 다중 range 동시 write
description: '여러 range 를 1번 호출로 update. 단일 update_values 와 같은 valueInputOption
+ valueInputOption 검증.
body:
{
"valueInputOption": "USER_ENTERED",
"data": [
{"range": "Sheet1!A1:B2", "values": [["a","b"],["c","d"]]},
{"range": "Sheet1!D1:D2", "values": [["x"],["y"]]}
],
"includeValuesInResponse": false
}
atomic — 1 range 실패 시 전체 rollback. update_values 보다 quota / latency 효율.
**Destructive write — 다중 range 덮어씀**.'
operationId: google_sheets_batch_update_values
parameters:
- name: spreadsheetId
in: path
required: true
schema:
type: string
title: Spreadsheetid
- name: connection_id
in: query
required: true
schema:
type: string
description: mcpweave connection_id
title: Connection Id
description: mcpweave connection_id
- name: X-API-Key
in: header
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: X-Api-Key
- name: mcpweave_session
in: cookie
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Mcpweave Session
requestBody:
content:
application/json:
schema:
anyOf:
- type: object
additionalProperties: true
- type: 'null'
title: Body
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
default:
description: Native cafe24 response (200) or gateway error envelope (4xx/5xx)
/api/v1/google_sheets/v4/spreadsheets/{spreadsheetId}/values:batchClear:
post:
tags:
- google_sheets-rest
summary: 다중 range 동시 clear
description: '여러 range 를 1번 호출로 clear. 값만 비움 (formatting / formula 보존,
clear_values 와 동일 동작).
body:
{"ranges": ["Sheet1!A1:B100", "Sheet2!C5:D10"]}
**Destructive write — 데이터 삭제**.'
operationId: google_sheets_batch_clear_values
parameters:
- name: spreadsheetId
in: path
required: true
schema:
type: string
title: Spreadsheetid
- name: connection_id
in: query
required: true
schema:
type: string
description: mcpweave connection_id
title: Connection Id
description: mcpweave connection_id
- name: X-API-Key
in: header
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: X-Api-Key
- name: mcpweave_session
in: cookie
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Mcpweave Session
requestBody:
content:
application/json:
schema:
anyOf:
- type: object
additionalProperties: true
- type: 'null'
title: Body
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
default:
description: Native cafe24 response (200) or gateway error envelope (4xx/5xx)
/api/v1/google_sheets/v4/spreadsheets/{spreadsheetId}/values/{range}:clear:
post:
tags:
- google_sheets-rest
summary: range 비우기 (write)
description: 'range 의 cell 값을 모두 비움 (dogfood 검증):
- 셀 자체는 유지 (delete row 아님 — gridProperties.rowCount 그대로)
- formatting (color / font / wrap) 도 그대로 유지
- 값만 삭제 — formula 도 사라짐
delete row 가 필요하면 ``spreadsheets.batchUpdate`` 의 ``deleteDimension``
request 사용 (Phase 2+).
**Destructive write — 데이터 삭제**.'
operationId: google_sheets_clear_values
parameters:
- name: spreadsheetId
in: path
required: true
schema:
type: string
title: Spreadsheetid
- name: range
in: path
required: true
schema:
type: string
title: Range
- name: connection_id
in: query
required: true
schema:
type: string
description: mcpweave connection_id
title: Connection Id
description: mcpweave connection_id
- name: X-API-Key
in: header
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: X-Api-Key
- name: mcpweave_session
in: cookie
required: false
schema:
anyOf:
- type: string
- type: 'null'
title: Mcpweave Session
requestBody:
content:
application/json:
schema:
anyOf:
- type: object
additionalProperties: true
- type: 'null'
title: Body
responses:
'200':
description: Successful Response
content:
application/json:
schema: {}
default:
description: Native cafe24 response (200) or gateway error envelope (4xx/5xx)