jpillora / jpillora/node-edit-google-spreadsheet

Accessing a document with OAuth

Open
#60 3 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

add to docs
Dominant language
JavaScript
Stars
301
Forks
98
PR merge metrics
No merged PRs in 30d

Description

I have used oauth with keyFile and was unable to access a document in my developer user's Drive.
Then I realized that the file should be shared with the Google generated email address.

The option for authentication:

    oauth: {
      email: 'googlegenerated@developer.gserviceaccount.com',
      keyFile: 'key.pem'
    }

When I shared the document with googlegenerated@developer.gserviceaccount.com the issue is resolved, I was able to interact with the spreadsheet.

Just wanted to point out that this may go into the documentation for the ease of use.

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

No documentation file is named in the issue. Start by locating the authentication or OAuth documentation for the oauth option, then document that the spreadsheet must be shared with the generated service-account email. Done when users can find this prerequisite before accessing a document.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript
Domain
documentation
Issue type
Documentation
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.