gatsby-source-google-spreadsheet icon indicating copy to clipboard operation
gatsby-source-google-spreadsheet copied to clipboard

Credentials setup

Open drupov opened this issue 2 years ago • 1 comments

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:

image

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

drupov avatar Dec 20 '21 09:12 drupov

You need to...

  1. Switch on the Sheets API in the Google Console
  2. Create a service account in the Google Console
  3. Invite the service account to the sheet

doublejosh avatar Oct 24 '22 21:10 doublejosh