Google Sheets API Javascript

Connect JavaScript to Sheets API by Sheetsu

Use Google Sheets API in JavaScript

Do you know JavaScript and want to create web app? You don't need to waste time on coding backend app and designing database. Just store the data in Google Sheets. You can read, write, update and delete data from your Spreadsheet by Sheetsu. Keep a focus on your JS skills, Sheetsu will take care of the server app.

Sheetsu is JS framework independent. You can use Sheetsu to connect to Sheets API with Vanilla JS or with any JS framework, e.g., JQuery, Vue, React, Angular, Ember.

Use Sheetsu JavaScript API and:

Don't think about database
Don't care about building API
Focus on solving real problems
Create App prototype fast and validate an MVP
Store data in Google Sheets

Easy to setup

Add Sheetsu Web Client to your app.

<script src="//script.sheetsu.com/"></script>

Run first JavaScript Sheets API request.

function successFunc(data) {
  console.log(data);
}

Sheetsu.read(
  "https://sheetsu.com/apis/v1.0lw/020b2c0f/",
  {},
  successFunc
);

Create and use your own Sheetsu API.

We open source

Sheetsu JavaScript Web Client is open source! Together with our users, we are building and improving our various libraries. Feel free to start contributing with Sheetsu JavaScript Web Client lib and became part of our community.

Do you want to start contributing, but don't know how? We are open to your questions.

Sheetsu JavaScript Web Client package on Github →

Ready to use JavaScript code samples

We have ready to use JavaScript snippets with solutions for most popular Sheets API use cases. Just copy them to your project.

Read spreadsheet

Load all data from sheet.

<head>
  <script src="//script.sheetsu.com/"></script>
</head>
<body>
  <script>
    function successFunc(data) {
      console.log(data);
    }
    // Read whole spreadsheet
    Sheetsu.read("https://sheetsu.com/apis/v1.0lw/020b2c0f/", {}, successFunc);
  </script>
</body>

Search spreadsheet

Perform a search query on any number of columns with wildcards.

<head>
  <script src="//script.sheetsu.com/"></script>
</head>
<body>
  <script>
    function successFunc(data) {
      console.log(data);
    }
    // Get all rows where column 'score' is '42'
    var searchQuery = {
      score: 42,
    };
    Sheetsu.read("https://sheetsu.com/apis/v1.0lw/020b2c0f/", {
      search: searchQuery
    }, successFunc);
  </script>
</body>

Add data to spreadsheet

From a single row to any number of rows with a single query.

<head>
  <script src="//script.sheetsu.com/"></script>
</head>
<body>
  <script>
    function successFunc(data) {
      console.log(data);
    }

    // Adds single row to spreadsheet
    var data = {
      id: 5,
      name: "John",
      score: 200
    };
    Sheetsu.write("https://sheetsu.com/apis/v1.0lw/020b2c0f/", data, {}, successFunc);
  </script>
</body>

We've got your back

We want you to succeed

Simple Docs

Sheetsu API follows RESTful rules, if you know REST then you know Sheetsu API. If you are starting your adventure with JavaScript - don't worry, we will help you to start. You can be up and run in a matter of seconds. You can find a lot of short JS code examples in the Sheetsu docs.

Check docs →

Help from a developer

If you need help with JavaScript Sheets API integration, we can handle it for you! With any paid plan, you get 1 hour with our developer. You can schedule a call with us. We will help you build an end-2-end solution and do Sheetsu work with your service/project.

Book a developer →