CMS - Google Sheets - The request is missing a valid API key

cms
#1

Hello,
I am using a CMS integration with Google Sheets.

With Public and Private Google Sheets I have the same Error:

Error -----------------------------------------------------------------

Code:
ERR_PLUGIN

Message:
The request is missing a valid API key.

Stack:
Error: The request is missing a valid API key.
at GoogleSheetsCMS.retrieveSpreadsheetData (D:\Programacion\aSEXa\jovo\aSEXaCoach\node_modules\jovo-cms-googlesheets\src\GoogleSheetsCMS.ts:98:19)
at process._tickCallback (internal/process/next_tick.js:68:7)

Module:
jovo-cms-googlesheets

Learn more:
https://www.jovo.tech/docs/cms/google-sheets

Can you help me?

Thanks,

#2

Hey @Alexa_Skills_Develop
Do you have a credentials.json? What’s in your GoogleSheetsCMS plugin config?

#3

If you’re using private spreadsheets, there’s also this tutorial that helps with setting up the credentials:

#4

Also Make sure to modify your tsconfig.json in order to have this line in the include sections if your project is in typescript

"src/credentials/credentials.json"

the tsc command will not automatically import that in the dist folder. This is valid only if you are using typescript.

#5

That’s the problem. Thanks to all.

#6

No problems. Enjoy coding