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
API Parameters
| Name | Type | Required? | Default | Description |
|---|---|---|---|---|
| docId | string | Yes | null | Document ID |
| sheetTitle | string | Yes | null | Sheet Title |
| rowId | number | Yes | null | Row ID |
API Responses
| Status Code | Description |
|---|---|
| 200 | Row deleted |
| 400 | Bad Request |
| 500 | Internal Server Error |
Convert a sheet to JSON
Send a GET request to the following URL to Convert a sheet to JSON
API Parameters
| Name | Type | Required? | Default | Description |
|---|---|---|---|---|
| docId | string | Yes | null | Document ID |
| sheetTitle | string | Yes | null | Sheet Title |
API Responses
| Status Code | Description |
|---|---|
| 200 | Sheet details and rows |
| 400 | Bad Request |
| 500 | Internal Server Error |
Create a new row
Send a POST request to the following URL to Create a new row
API Parameters
| Name | Type | Required? | Default | Description |
|---|---|---|---|---|
| docId | string | Yes | null | Document ID |
| sheetTitle | string | Yes | null | Sheet Title |
| row | object | Yes | null | The row object to create |
API Responses
| Status Code | Description |
|---|---|
| 201 | Row created |
| 400 | Bad Request |
| 500 | Internal Server Error |
Document details
Send a GET request to the following URL to Document details
API Parameters
| Name | Type | Required? | Default | Description |
|---|---|---|---|---|
| docId | string | Yes | null | Document ID |
API Responses
| Status Code | Description |
|---|---|
| 200 | Document details |
| 400 | Bad Request |
| 500 | Internal Server Error |