SheetsDB
    Changelogv0.2.0

    SheetsDB: Google Sheets to JSON API

    Send a public Google Sheet URL to one authenticated endpoint and get its rows back as JSON. No Google API setup or sync job required.

    Read the docs
    const myHeaders = new Headers();
myHeaders.append("Authorization", "Bearer {API_TOKEN}");
myHeaders.append("Content-Type", "application/json");

const raw = JSON.stringify({
  "sheetRef": "GOOGLE_SHEET_URL_OR_ID",
  "hasHeader": true,
});

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

fetch("https://www.sheetsdb.io/api/v1/getsheet", requestOptions)
  .then((response) => response.text())

    From public sheet to clean JSON.

    SheetsDB handles the read request, JSON conversion, API key checks, and usage tracking. Your Google Sheet stays the source of truth.

    Share a Google Sheet, create an API key, and send a POST request. There is no Google Cloud project or service account to configure.

    Quick setup in SheetsDB

    Early launch feedback

    Comments shared when SheetsDB first launched.

      • Just what I've been waiting for! Great job!! 🔥

        Madalina B
        Growth 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 Park
        Cofounder of CodeFusion

      • Was just looking for something similar. All the best!

        Joseph D'Souza
        Co-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 Douglass
        Cofounder of InnoVision

      • Hey 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 Nadarajah
        Cofounder of EchoWave

      • Looks good.🔥 It seems like I could try transforming my Google Sheets into JSON effortlessly.

        Shreya Kasliwal
        CapitalxAI | IIT-B | Startups | AI

    Frequently asked questions

    If your question is not covered here, contact Zainul directly.

      • How does SheetsDB work?

        SheetsDB gives you an authenticated API endpoint that retrieves a public Google Sheet and returns its rows as JSON.

      • Is SheetsDB free to use?

        Yes, SheetsDB is currently free for all users. If you want to support the project, you can buy me a coffee.

      • What data does SheetsDB store?

        SheetsDB uses Google OAuth for sign-in. Telemetry does not store Sheet contents, full request bodies, response bodies, or raw bearer tokens. Some support diagnostics are encrypted and expire automatically.

      • Can I use SheetsDB with private Google Sheets?

        No. SheetsDB works only with Sheets that are public or shared so anyone with the link can view them.

      • Can I write data to my Google Sheet using the SheetsDB API?

        No. SheetsDB is read-only. Use the Google Sheets API if you need to write cells.

      • Does SheetsDB cache Sheet data?

        SheetsDB fetches the Sheet on every request. Google publishing or caching can delay recent edits.

      • Are there any rate limits for API calls?

        The default is 120 requests per minute per API key. Your dashboard shows the current value and whether rate-limit enforcement is active.

      • Can I use SheetsDB in a production application?

        SheetsDB can serve public, read-only Sheet data. Review the documented limits and keep a fallback for SheetsDB or upstream Google failures.

      • How can I contact Zainul?

        Contact Zainul on Telegram at @pythondev or email zainul1996@gmail.com.