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
No comments