{"activeVersionTag":"latest","latestAvailableVersionTag":"latest","collection":{"info":{"_postman_id":"876c50d4-6062-4122-a67e-c60ca1d42cbd","name":"Sheet2DB API","description":"Welcome to Sheet2DB, your go-to tool for transforming your Google Spreadsheet into a powerful JSON API! This documentation is your one-stop guide to mastering the Sheet2DB API. Got questions? No worries, just reach out to us anytime on [support@sheet2db.com](https://mailto:support@sheet2db.com). We're here to help!\n\n# Creating Account\n\nSign Up on [Registration Page](https://sheet2db.io/auth/register)\n\n# Preparing Sheet\n\nSheet2DB utilizes the first row of your spreadsheet as a reference to structure the data below it. The format defined in the initial row serves as the blueprint for the data in subsequent rows, so it's important to ensure that it accurately represents your data structure.\n\nThere are no strict limitations on the types of data you can include in the rows following the first one. Whether you have numerical values, text, dates, or even empty cells, Sheet2DB will handle them seamlessly.\n\n#### Example Spreadsheet\n\n<img src=\"https://sheet2db.io/spreadsheet.png\" width=\"616\" height=\"233\">\n\n# Permissions\n\nTo safeguard your APIs, it's advisable to grant the minimum necessary permissions required for your application to function effectively. For instance, if your intention is to use the API for data collection through a form, consider assigning only the Update permission. By doing so, even if someone discovers your endpoint, they won't have the capability to view your data.\n\nFollowing are different permissions we support\n\n- **Read** : Grants the ability to view and retrieve data from a sheet. Users with this permission can access the data but cannot modify it in any way.\n    \n- **Apply Filters**: Allows users to apply filters on the data. Useful for narrowing down large datasets based on specific conditions without altering the actual data.\n    \n- **Insert**: Enables users to add new rows to the sheet. This includes submitting new data entries through forms, APIs, or the dashboard UI.\n    \n- **Update**: Allows users to modify existing rows in the sheet. They can change values in one or more columns for a given record.\n    \n- **Delete**: Grants permission to permanently delete rows from the sheet. This action removes the data and cannot be undone unless backups or versioning are enabled.\n    \n- **Clear**: Allows users to clear all data from a sheet without deleting the sheet itself. The structure (columns and headers) remains intact, but the content is wiped.\n    \n- **Add Sheet**: Enables users to create new sheets within the current spreadsheet.\n    \n- **Delete Sheet**: Grants permission to permanently delete an entire sheet within a spreadsheet and all of its data\n    \n\nAccessing an unauthorized endpoint will result in a 403 Forbidden error.\"\n\n# Authentication\n\nSheet2DB Supports 3 types for Authentication methods to safeguard access to your spreadsheet / database.\n\n- Basic Authentication\n    \n- Bearer Token\n    \n- JWT Authentication\n    \n\n## Basic Authentication\n\nWith [Basic Authentication](https://en.wikipedia.org/wiki/Basic_access_authentication), you use username and password to authenticate your HTTP requests. You can enter username and password of your choice.\n\n## Bearer Token Authentication\n\nWith Bearer Token, you can pass a custom token as `Authorization` Header to authenticate yourself\n\n## JWT Authentication\n\nUsing [JWT Authentication](https://jwt.io/introduction), we provide you the flexibility to sign a token with your preferred encryption key. You may securely share the verification key with us to confirm that the token was indeed signed by you, ensuring access to your database.\n\nSupported Algorithms\n\n- `HS256`\n    \n- `HS384`\n    \n- `HS512`\n    \n- `RS256`\n    \n- `RS384`\n    \n- `RS512`","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","isPublicCollection":true,"owner":"35551999","collectionId":"876c50d4-6062-4122-a67e-c60ca1d42cbd","publishedId":"2sB2qgfJrM","public":true,"publicUrl":"https://documenter-api.postman.tech/view/35551999/2sB2qgfJrM","privateUrl":"https://go.postman.co/documentation/35551999-876c50d4-6062-4122-a67e-c60ca1d42cbd","customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"FF6C37"},"documentationLayout":"classic-double-column","customisation":{"metaTags":[{"name":"description","value":"Sheet2DB lets you turn any Google Sheet into a secure JSON API in seconds. Easily read, write, and manage data with REST endpoints. Perfect for forms, dashboards, and no-code apps."},{"name":"title","value":"Sheet2DB - Instantly Turn Google Sheets into RESTful APIs"}],"appearance":{"default":"system_default","themes":[{"name":"dark","logo":null,"colors":{"top-bar":"212121","right-sidebar":"303030","highlight":"FF6C37"}},{"name":"light","logo":null,"colors":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"FF6C37"}}]}},"version":"8.10.1","publishDate":"2025-06-02T07:24:49.000Z","activeVersionTag":"latest","documentationTheme":"light","metaTags":{"title":"Sheet2DB - Instantly Turn Google Sheets into RESTful APIs","description":"Sheet2DB lets you turn any Google Sheet into a secure JSON API in seconds. Easily read, write, and manage data with REST endpoints. Perfect for forms, dashboards, and no-code apps."},"logos":{"logoLight":null,"logoDark":null}},"statusCode":200},"environments":[],"user":{"authenticated":false,"permissions":{"publish":false}},"run":{"button":{"js":"https://run.pstmn.io/button.js","css":"https://run.pstmn.io/button.css"}},"web":"https://www.getpostman.com/","team":{"logo":"https://res.cloudinary.com/postman/image/upload/t_team_logo_pubdoc/v1/team/768118b36f06c94b0306958b980558e6915839447e859fe16906e29d683976f0","favicon":""},"isEnvFetchError":false,"languages":"[{\"key\":\"csharp\",\"label\":\"C#\",\"variant\":\"HttpClient\"},{\"key\":\"csharp\",\"label\":\"C#\",\"variant\":\"RestSharp\"},{\"key\":\"curl\",\"label\":\"cURL\",\"variant\":\"cURL\"},{\"key\":\"dart\",\"label\":\"Dart\",\"variant\":\"http\"},{\"key\":\"go\",\"label\":\"Go\",\"variant\":\"Native\"},{\"key\":\"http\",\"label\":\"HTTP\",\"variant\":\"HTTP\"},{\"key\":\"java\",\"label\":\"Java\",\"variant\":\"OkHttp\"},{\"key\":\"java\",\"label\":\"Java\",\"variant\":\"Unirest\"},{\"key\":\"javascript\",\"label\":\"JavaScript\",\"variant\":\"Fetch\"},{\"key\":\"javascript\",\"label\":\"JavaScript\",\"variant\":\"jQuery\"},{\"key\":\"javascript\",\"label\":\"JavaScript\",\"variant\":\"XHR\"},{\"key\":\"c\",\"label\":\"C\",\"variant\":\"libcurl\"},{\"key\":\"nodejs\",\"label\":\"NodeJs\",\"variant\":\"Axios\"},{\"key\":\"nodejs\",\"label\":\"NodeJs\",\"variant\":\"Native\"},{\"key\":\"nodejs\",\"label\":\"NodeJs\",\"variant\":\"Request\"},{\"key\":\"nodejs\",\"label\":\"NodeJs\",\"variant\":\"Unirest\"},{\"key\":\"objective-c\",\"label\":\"Objective-C\",\"variant\":\"NSURLSession\"},{\"key\":\"ocaml\",\"label\":\"OCaml\",\"variant\":\"Cohttp\"},{\"key\":\"php\",\"label\":\"PHP\",\"variant\":\"cURL\"},{\"key\":\"php\",\"label\":\"PHP\",\"variant\":\"Guzzle\"},{\"key\":\"php\",\"label\":\"PHP\",\"variant\":\"HTTP_Request2\"},{\"key\":\"php\",\"label\":\"PHP\",\"variant\":\"pecl_http\"},{\"key\":\"powershell\",\"label\":\"PowerShell\",\"variant\":\"RestMethod\"},{\"key\":\"python\",\"label\":\"Python\",\"variant\":\"http.client\"},{\"key\":\"python\",\"label\":\"Python\",\"variant\":\"Requests\"},{\"key\":\"r\",\"label\":\"R\",\"variant\":\"httr\"},{\"key\":\"r\",\"label\":\"R\",\"variant\":\"RCurl\"},{\"key\":\"ruby\",\"label\":\"Ruby\",\"variant\":\"Net::HTTP\"},{\"key\":\"shell\",\"label\":\"Shell\",\"variant\":\"Httpie\"},{\"key\":\"shell\",\"label\":\"Shell\",\"variant\":\"wget\"},{\"key\":\"swift\",\"label\":\"Swift\",\"variant\":\"URLSession\"}]","languageSettings":[{"key":"csharp","label":"C#","variant":"HttpClient"},{"key":"csharp","label":"C#","variant":"RestSharp"},{"key":"curl","label":"cURL","variant":"cURL"},{"key":"dart","label":"Dart","variant":"http"},{"key":"go","label":"Go","variant":"Native"},{"key":"http","label":"HTTP","variant":"HTTP"},{"key":"java","label":"Java","variant":"OkHttp"},{"key":"java","label":"Java","variant":"Unirest"},{"key":"javascript","label":"JavaScript","variant":"Fetch"},{"key":"javascript","label":"JavaScript","variant":"jQuery"},{"key":"javascript","label":"JavaScript","variant":"XHR"},{"key":"c","label":"C","variant":"libcurl"},{"key":"nodejs","label":"NodeJs","variant":"Axios"},{"key":"nodejs","label":"NodeJs","variant":"Native"},{"key":"nodejs","label":"NodeJs","variant":"Request"},{"key":"nodejs","label":"NodeJs","variant":"Unirest"},{"key":"objective-c","label":"Objective-C","variant":"NSURLSession"},{"key":"ocaml","label":"OCaml","variant":"Cohttp"},{"key":"php","label":"PHP","variant":"cURL"},{"key":"php","label":"PHP","variant":"Guzzle"},{"key":"php","label":"PHP","variant":"HTTP_Request2"},{"key":"php","label":"PHP","variant":"pecl_http"},{"key":"powershell","label":"PowerShell","variant":"RestMethod"},{"key":"python","label":"Python","variant":"http.client"},{"key":"python","label":"Python","variant":"Requests"},{"key":"r","label":"R","variant":"httr"},{"key":"r","label":"R","variant":"RCurl"},{"key":"ruby","label":"Ruby","variant":"Net::HTTP"},{"key":"shell","label":"Shell","variant":"Httpie"},{"key":"shell","label":"Shell","variant":"wget"},{"key":"swift","label":"Swift","variant":"URLSession"}],"languageOptions":[{"label":"C# - HttpClient","value":"csharp - HttpClient - C#"},{"label":"C# - RestSharp","value":"csharp - RestSharp - C#"},{"label":"cURL - cURL","value":"curl - cURL - cURL"},{"label":"Dart - http","value":"dart - http - Dart"},{"label":"Go - Native","value":"go - Native - Go"},{"label":"HTTP - HTTP","value":"http - HTTP - HTTP"},{"label":"Java - OkHttp","value":"java - OkHttp - Java"},{"label":"Java - Unirest","value":"java - Unirest - Java"},{"label":"JavaScript - Fetch","value":"javascript - Fetch - JavaScript"},{"label":"JavaScript - jQuery","value":"javascript - jQuery - JavaScript"},{"label":"JavaScript - XHR","value":"javascript - XHR - JavaScript"},{"label":"C - libcurl","value":"c - libcurl - C"},{"label":"NodeJs - Axios","value":"nodejs - Axios - NodeJs"},{"label":"NodeJs - Native","value":"nodejs - Native - NodeJs"},{"label":"NodeJs - Request","value":"nodejs - Request - NodeJs"},{"label":"NodeJs - Unirest","value":"nodejs - Unirest - NodeJs"},{"label":"Objective-C - NSURLSession","value":"objective-c - NSURLSession - Objective-C"},{"label":"OCaml - Cohttp","value":"ocaml - Cohttp - OCaml"},{"label":"PHP - cURL","value":"php - cURL - PHP"},{"label":"PHP - Guzzle","value":"php - Guzzle - PHP"},{"label":"PHP - HTTP_Request2","value":"php - HTTP_Request2 - PHP"},{"label":"PHP - pecl_http","value":"php - pecl_http - PHP"},{"label":"PowerShell - RestMethod","value":"powershell - RestMethod - PowerShell"},{"label":"Python - http.client","value":"python - http.client - Python"},{"label":"Python - Requests","value":"python - Requests - Python"},{"label":"R - httr","value":"r - httr - R"},{"label":"R - RCurl","value":"r - RCurl - R"},{"label":"Ruby - Net::HTTP","value":"ruby - Net::HTTP - Ruby"},{"label":"Shell - Httpie","value":"shell - Httpie - Shell"},{"label":"Shell - wget","value":"shell - wget - Shell"},{"label":"Swift - URLSession","value":"swift - URLSession - Swift"}],"layoutOptions":[{"value":"classic-single-column","label":"Single Column"},{"value":"classic-double-column","label":"Double Column"}],"versionOptions":[],"environmentOptions":[{"value":"0","label":"No Environment"}],"canonicalUrl":"https://documenter.gw.postman.com/view/metadata/2sB2qgfJrM"}