Using Google Spreadsheet as a Web Service

Published On: 26 June 2015.By .
  • Digital Engineering

Today I am just looking for a solution on how to create simple and light weight web service for a small and clean plain data.

Lots of things were in mind before creating a web service:
1. Platform
2. Framework
3. Security
4. Web service format (obviously no one can beat json)

After all we have decided we need to create an Admin to manage our data. There is lots of stress in creating a simple web service that has simple consolidate data .

Finally I got the solution with Google APIs. It became so easy when we feed our data in excel and access it in json format. Its damn cool, with the approach you can even share your data with anyone and with edit permission.

Lets talk about how can we use Google excel as a web service, there is very simple way to create json on other end.

Go to > File menu > Publish to web

Auriga IT Detailed Action Plan - Google Sheets 2015-06-26 11-38-16

Open the pop up showing a drop down to give permission and choose what you require
A. Entire Documents :- Provides All tabs Json
B. Other option :- Your sheet names

Note :- Check the check box for “Automatically changes in real time changes”.

When you click on publish it will show you a share url.

Here we have two option for share this data
i) Hit the url it will show you a data in tabular form
ii) the other one is for json copy the spreadsheet id from the url its just like a big random string in the url

https://spreadsheets.google.com/feeds/list/PASTE-YOUR-SPREADSHEET-ID-HERE/od6/public/values?alt=json

Paste your SSI in above url and here we are ready to go with the json response

Related content

That’s all for this blog

Go to Top