Spreadsheet's API

API

How to convert Google sheets into JSON data

  1. Create Google sheet.

  2. Update data into sheet.

  3. Publish Google sheet to the web.

  4. Copy Google sheet ID.

  5. Replace Google sheet ID with the below JSON url:

https://spreadsheets.google.com/feeds/list/GoogleSheetID/od6/public/values?alt=json