Sheetsu is an application that helps you save time and make working with Google Spreadsheets super fast. You don’t have to use complicated Google APIs or configure OAuth authorization. You just need to put spreadsheet URL to Sheetsu and boom! You get an API URL on which you can do operations on (GET, POST, UPDATE and DELETE). It’s beautiful in its simplicity. If you value your time, it is a perfect time saver.

Let’s get this party started

To work with spreadsheets, first, you need to create an API. It’s pretty straight forward, you need to follow three simple steps:

Create Google Spreadsheets file and fill it with example data. Create your brand new Sheetsu account. Create an API!

1. Google Spreadsheets

Open your browser and go to the Google spreadsheets site. Create a new spreadsheet by clicking the “+” button. We will read data from this spreadsheet.

Then, name your new spreadsheet.

I named it “Example”. Then add an example data. You can copy them from this doc. Remember about naming columns first.

2. Sheetsu account

When spreadsheet part is done, you need to Sign up to Sheetsu. Let’s go to Sheetsu main page and click “SIGN UP” button in top-right corner of the website.

Sheetsu is using Google Authorization system, so you will be redirected to Google accounts page to give some permissions.

If you accept them, click ALLOW button.

And puff! It is done! We are on the dashboard.

3. Sheetsu API

To create an API you need to go back to your previously created spreadsheet and copy its URL.

And the last thing to do is to paste this URL in your dashboard and click “CREATE API” button.

After that, your Sheetsu API will be created. You can click on a generatated link and see the results:

Reading from, and writing to spreadsheet

Sheetsu offers you two ways of reading from and writing data to your spreadsheet:

Paste a snippet into your website — simplest, quickest and easiest method. Make an HTTP request — solution for users with basic programming knowledge.

I will show you only the first way. For the second one check our docs.

First things first, to do this, you will need to have a Sheetsu API. If you do not have one, go back and create it. If you do — let’s look up column names from your Google Spreadsheet. Go to the Sheetsu dashboard and click on your “Sheet URL”.

If you didn’t named your columns, please do this. You can check this example doc here.

Now, we can do some magic:

READING

You just need to copy and paste some HTML code to your page and it is done. Look at the example below: