gatsby-source-google-spreadsheet
gatsby-source-google-spreadsheet copied to clipboard
Credentials setup
Hey, I am having issues with setting up credentials.
The README states
// The
credentials
are only needed when you need to be authenticated to read the document.
so my hope was that it would be enough to make the spreadsheet publicly available via the "Share document"-UI of Google Spreadsheets itself:
But I get an Error: The request is missing a valid API key.
If an API key is needed indeed - can someone point me to some docs on how to create one and how to use it in options.credentials
in "gatsby-source-google-spreadsheet"
Thanks
You need to...
- Switch on the Sheets API in the Google Console
- Create a service account in the Google Console
- Invite the service account to the sheet