Access Google Spreadsheet as JSON

Share:

Google Sheets is a a free, web-based software office suite offered by Google within its Google Drive service.
One useful feature of Google Spreadsheets is the ability to access the data as JSON by using a particular URL.

To access a spread as JSON First, you must create and publish/share your spreadsheet to the web.

Look at the Youtube tutorial for better understanding.

id (required): The ID of your document. This is the big long aplha-numeric code in the middle of your document URL.

Macro URL: 
https://script.google.com/macros/s/AKfycbxWeYWmgBCS_ce2ovEgciVFtYy-GRQp9W9IrrwbYsvM8iCs4ymo/exec?id=SHEETID&sheet=SHEETNAME

NOTE: Replace the SHEETID & SHEETNAME  to your sheet details

Tutorial: https://www.youtube.com/watch?v=tV_2i8xW-G0

Hi! I am Sartaj Husain. I am a Professional Software Developer, live in Delhi. I write blogs in my free time. I love to learn and share the knowledge with others because it is no good to try to stop knowledge from going forward. So free posts and tutorials. more..

No comments