SheetsDB
    Loading...
    Changelogv0.1.3

    SheetsDB: Google Sheets to JSON API

    Turn your spreadsheets into powerful APIs in seconds. SheetsDB offers a simple, free solution for developers to access Google Sheets data programmatically.

    View Docs
    Go to console
    example.js
    example.py
    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.

    Trusted by Developers Everywhere

    Here's what some of our early users have to say about SheetsDB.

      • 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

    Can'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