Example: Google Sheets NPM

Show and tell
,
112

As a note the default template does not see to work anymore.
Getting the client configuration provides this:

{“web”:{“client_id”:“a_long_hash.apps.googleusercontent.com”,“project_id”:“quickstart-a-number”,“auth_uri”:“https://accounts.google.com/o/oauth2/auth",“token_uri”:“https://oauth2.googleapis.com/token”,“auth_provider_x509_cert_url”:“https://www.googleapis.com/oauth2/v1/certs”,“client_secret”:“this-is-secret”,“javascript_origins”:["http://www.secret”]}}

TypeError: Cannot destructure property client_secret of ‘undefined’ or ‘null’.
and in the chrome console:
wixcode-worker.js:18 TypeError: Cannot destructure property client_secret of ‘undefined’ or ‘null’.
at createClient (backend/common-googleSheet.jsw:29:8)
at processTicksAndRejections (internal/process/task_queues.js:93:5)

At it there were some mis-labels in the common-googleSheet.jsw based on the google-provided credentials-file. I renamed them in the json- for ease:

web=> installed, javascript_origins=>redirect_uris,

Unpacking it more slowly in common-googleSheet.jsw :

const client_id = credentials.installed.client_id
const client_secret = credentials.installed.client_secret
const redirect_uris = credentials.installed.redirect_uris
console.log(client_id)
console.log(client_secret)
console.log(redirect_uris)

Still yielded odd output wit redirect_uris going to null. Needless to say, this did not work. What should I do?