as mentioned in the title a get an error when using a private google spreadsheet as a cms. However this error only appears when using an http(s) endpoint (aws lambda). When I deploy the exact same code using the jovo debugger as the endpoint, everything works (so I don’t get an error of a not valid api key).
There error is the following:
Msg: The request is missing a valid API key.
Stack: Error: The request is missing a valid API key.
at GoogleSheetsCMS.retrieveSpreadsheetData (/var/task/node_modules/jovo-cms-googlesheets/dist/src/GoogleSheetsCMS.js:103:19)
at process._tickCallback (internal/process/next_tick.js:68:7)
I followed the docu and asuming everything works with the jovo debugger my setup/ config was right?
The problem is, that setting the spreadsheet to public gives me the same problem that already appread to me: See github
Message: HTTP Response code 302
Stack: Error: HTTP Response code 302
at IncomingMessage.res.on (/var/task/node_modules/jovo-cms-googlesheets/dist/src/GoogleSheetsCMS.js:154:43)
at IncomingMessage.emit (events.js:203:15)
at process._tickCallback (internal/process/next_tick.js:63:19)
Hint: This might occur when you try to access a private spreadsheet without the permission.