Google Sheets API

Google Sheets API Docs

Read, write, and format Google Sheets data

Delete an existing row

Send a DELETE request to the following URL to Delete an existing row

Parameters

NameTypeRequired?Description
docIdstringYesDocument ID
sheetTitlestringYesSheet Title
rowIdnumberYesRow ID

Responses

Status CodeDescription
200Row deleted
400Bad Request
500Internal Server Error

Convert a sheet to JSON

Send a GET request to the following URL to Convert a sheet to JSON

Parameters

NameTypeRequired?Description
docIdstringYesDocument ID
sheetTitlestringYesSheet Title

Responses

Status CodeDescription
200Sheet details and rows
400Bad Request
500Internal Server Error

Create a new row

Send a POST request to the following URL to Create a new row

Parameters

NameTypeRequired?Description
docIdstringYesDocument ID
sheetTitlestringYesSheet Title
rowobjectYesThe row object to create

Responses

Status CodeDescription
201Row created
400Bad Request
500Internal Server Error

Document details

Send a GET request to the following URL to Document details

Parameters

NameTypeRequired?Description
docIdstringYesDocument ID

Responses

Status CodeDescription
200Document details
400Bad Request
500Internal Server Error