Using v3 Sheets API we can get cell data when a Spreadsheet is "Published to Web".
Example v3 api URL: https://spreadsheets.google.com/feeds/cells/1Kt6OrUCZJC0rw8K5QgqiuqrIqDW_VEJm1MxdxXY7twQ/1/public/full Using v4 Sheets API to get data from the same Spreadsheet that is "Published to Web" returns { "error": { "code": 403, "message": "The caller does not have permission", "status": "PERMISSION_DENIED" } } Example v4 api URL (less API Key) https://sheets.googleapis.com/v4/spreadsheets/1Kt6OrUCZJC0rw8K5QgqiuqrIqDW_VEJm1MxdxXY7twQ/values/Sheet1?key=<YOUR-KEY-HERE> -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
