Introduction
Sheety API Collection provides endpoints for managing data in Google Sheets through RESTful APIs. This documentation covers all available endpoints and their usage.
Authentication
Authentication is handled through API keys in the request headers.
Authorization: Bearer YOUR_API_KEYEndpoints
GET
/sheet1
Retrieve all rows from Sheet1
Response Example:
{
"sheet1S": [
{
"id": 1,
"name": "Test User",
"email": "test@example.com",
"status": "active"
}
]
}
POST
/sheet1
Add a new row to Sheet1
Request Body:
{
"sheet1": {
"name": "Test User",
"email": "test@example.com",
"status": "active"
}
}
PUT
/sheet1/:id
Update an existing row in Sheet1
DELETE
/sheet1/:id
Delete a row from Sheet1
Test Scripts
Example test script for verifying API responses:
pm.test("Status code is 200", function () {
pm.response.to.have.status(200);
});
pm.test("Response is JSON", function () {
pm.response.to.be.json;
});
pm.test("Response has sheet1S array", function () {
const responseData = pm.response.json();
pm.expect(responseData).to.have.property('sheet1S');
pm.expect(responseData.sheet1S).to.be.an('array');
});