google-apiclient icon indicating copy to clipboard operation
google-apiclient copied to clipboard

How to fetch data with private google sheet ?

Open sunh-2087 opened this issue 5 years ago • 3 comments

Call google sheet and error

   Google_Service_Exception  : {
  "error": {
    "code": 403,
    "message": "The caller does not have permission",
    "errors": [
      {
        "message": "The caller does not have permission",
        "domain": "global",
        "reason": "forbidden"
      }
    ],
    "status": "PERMISSION_DENIED"
  }
}

sunh-2087 avatar Jan 30 '20 04:01 sunh-2087

you can use google sheet api to fetch the data from any google sheet , i am attaching a repo where it is an app which polls a google spreadsheet and generates JSON or JS files used as translation keys

link: https://github.com/ddresch/meteor-i18n-monitor

For the authentication setup check this one: link: https://github.com/reactioncommerce/meteor-google-spreadsheets

teenugrg avatar Sep 14 '20 19:09 teenugrg

@sunh-2087 Have you been able to fix this?

Peterragheb avatar Aug 18 '21 16:08 Peterragheb