Show HN: Transform Google Sheets into Instant, Free JSON APIs
SheetsDB - Google Sheets to JSON API Converter
Turn your spreadsheets into powerful APIs in seconds. SheetsDB offers a simple, free solution for developers to access Google Sheets data programmatically.const myHeaders = new Headers();
myHeaders.append("Authorization", "Bearer {API_TOKEN}");
myHeaders.append("Content-Type", "application/json");

const raw = JSON.stringify({
  "url": {URL_TO_GOOGLE_SHEET},
});

const requestOptions = {
  method: "POST",
  headers: myHeaders,
  body: raw,
  redirect: "follow"
};

fetch("https://www.sheetsdb.io/api/v1/getsheet", requestOptions)
  .then((response) => response.text())Everything you need to supercharge your Google Sheets.Transform your spreadsheets into powerful APIs with just a few clicks. Perfect for developers who need quick, flexible data solutions.Turn any Google Sheet into a JSON API instantly. No complex setup required, simply login, generate your API key and start running API requests.Changes in your Google Sheets reflect immediately in the API. Always work with the most up-to-date data in your applications.Monitor you API usage and performance with the built-in dashboard. Get insights into your API usage and optimize your applications.Manage your API keys with ease. Create, revoke and regenerate API keys from the home page.Turn any Google Sheet into a JSON API instantly. No complex setup required, simply login, generate your API key and start running API requests.Trusted by Developers EverywhereHere's what some of our early users have to say about SheetsDB.Just what I've been waiting for! Great job!! 🔥Madalina BGrowth Marketer | AI enthusiast 👩‍🚀🚀Congrats on launching SheetsDB, Zainul! The simplicity and straightforward setup of SheetsDB really stand out. As a developer, the ability to quickly access Google Sheets data without complex setups is a game-changer. The free and secure aspect is a huge plus. I'm particularly impressed by the non-technical-friendly approach, allowing team members to update data easily.Brian ParkCofounder of CodeFusionWas just looking for something similar. All the best!Joseph D'SouzaCo-Founder, Vigilo Labs. 2x Founder.Great job, Zainul! SheetsDB looks like a game-changer for developers working with Google Sheets. The simplicity of setup and the ability to get JSON data so quickly is fantastic. The focus on security with Google authentication and API tokens is reassuring. I can see this being incredibly useful for my team, where non-developers frequently update data.Andrew DouglassCofounder of InnoVisionHey Zainul! SheetsDB looks like a fantastic tool for developers who rely on Google Sheets. The simplicity of creating API tokens and receiving JSON data is impressive and exactly what many small teams need. I particularly appreciate the focus on non-technical team members being able to update the data without hassle.Piriyatheepan NadarajahCofounder of EchoWaveLooks good.🔥 It seems like I could try transforming my Google Sheets into JSON effortlessly.Shreya KasliwalCapitalxAI | IIT-B | Startups | AIFrequently asked questionsCan't find the answer you're looking for? Feel free to reach out to our support team.How does SheetsDB work?SheetsDB gives you an API endpoint that you can useto retrieve your google sheet data in JSON format.Is SheetsDB free to use?Yes, SheetsDB is currently free for all users. If you want to support the project, you may buy us a coffee.How secure is my data with SheetsDB?We take security seriously. SheetsDB uses Google's OAuth for authentication and doesn't store your sheet data. You have full control over access through API tokens.Can I use SheetsDB with private Google Sheets?Nope, SheetsDB only works with public Google Sheets. We are looking into supporting private sheets in the future.Can I write data to my Google Sheet using the SheetsDB API?Not yet. SheetsDB is read-only for now. We are looking into adding write support in the future.How often is the API data updated?SheetsDB provides real-time access to your sheet data. Any changes made in your Google Sheet are immediately reflected in the API response.Are there any rate limits for API calls?We currently don't impose strict rate limits, but we recommend implementing caching in your application for optimal performance and to avoid unnecessary calls.Can I use SheetsDB in my commercial projects?Yes, you can use SheetsDB in both personal and commercial projects. We're here to support developers and businesses of all sizes. However, do consider supporting the project if you find it useful in order to help us keep it running.How can I contact the SheetsDB team?You can reach out to me via Telegram @pythondev or email me at zainul1996@gmail.com