Dev {Tricks}

You are here: Home / Archives for Email Solutions / Google Spreadsheet

by Leave a Comment

Create Spreadsheet. How to get Google Sheet as json file?

  1. Create spreadsheet at https://docs.google.com/spreadsheets/u/0/
  2. Publish the created spreadsheet on the web.
  3. You will get spreadsheet url at google drive like https://docs.google.com/spreadsheets/d/15w2MY4pmzHmS8zC6X-EVxEGCtAVeUsFNJwrPu0/edit#gid=8699371
  4. Using the spreadsheet url you can get json endpoint file as follows
    https://spreadsheets.google.com/feeds/cells/YOURGOOGLESHEETCODE/SHEETPAGENUMBER/public/full?alt=json
  5. Replace
    YOURGOOGLESHEETCODE with 15w2MY4pmzHmS8zC6X-EVxEGCtAVeUsFNJwrPu0
    SHEETPAGENUMBER to 1
  6. Now the url will look like https://spreadsheets.google.com/feeds/cells/15w2MY4pmzHmS8zC6X-EVxEGCtAVeUsFNJwrPu0/1/public/full?alt=json
  7. Browse the final url and you will get json.

Thanks

by Leave a Comment

How to get Google Spreadsheet ID and sheet ID?

Google Spreadsheet ID and Google Sheet ID can be find easily in doc url.

https://docs.google.com/spreadsheets/d/spreadsheetId/edit#gid=sheetId

https://docs.google.com/spreadsheets/d/this-is-spreadsheet-id/edit#gid=this-is-sheet-id

Read more at https://developers.google.com/sheets/api/guides/concepts#sheet_id