Gathering detailed insights and metrics for google-sheet-cli
Gathering detailed insights and metrics for google-sheet-cli
Installations
npm install google-sheet-cliDeveloper
jroehl
Developer Guide
BETA
Module System
CommonJS
Min. Node Version
>=8.0.0
Typescript Support
Yes
Node Version
18.16.0
NPM Version
9.6.7
Statistics
60 Stars
258 Commits
4 Forks
3 Watching
11 Branches
1 Contributors
Updated on 03 Oct 2024
Languages
TypeScript (97.3%)
Shell (1.41%)
JavaScript (1.16%)
Batchfile (0.12%)
Total Downloads
Cumulative downloads
Total Downloads
52,631
Last day
6.4%
317
Compared to previous day
Last week
9.3%
1,791
Compared to previous week
Last month
36.1%
7,888
Compared to previous month
Last year
303.5%
36,843
Compared to previous year
Daily Downloads
Weekly Downloads
Monthly Downloads
Yearly Downloads
Versions
google-sheet-cli
A simple helper cli to interact with google sheets.
Usage as CLI
1$ npm install -g google-sheet-cli 2$ google-sheet COMMAND 3running command... 4$ google-sheet (--version) 5google-sheet-cli/0.0.0 darwin-arm64 node-v18.16.0 6$ google-sheet --help [COMMAND] 7USAGE 8 $ google-sheet COMMAND 9...
Usage as library
You can import the GoogleSheet class as a module and use it without the cli functionality. See code: src/lib/google-sheet.ts
Command Topics
google-sheet data- Manage data in worksheetgoogle-sheet help- Display help for google-sheet.google-sheet spreadsheet- Manage spreadsheetsgoogle-sheet worksheet- Manage worksheets
Info
How to configure
Step 1: Setting Up Google Service Account
- Login to Google API Console: Visit the Google Cloud Console website (https://console.cloud.google.com/) and log in using your Google account credentials.
- Enable Google Sheets API: In the Google Cloud Console, navigate to the "Library" section. Here, search for "Google Sheets API" and enable it.
- Create a Service Account: Next, go to the "Credentials" section. Here, click on the "Create Credentials" dropdown button and select "Service Account". There's no need to assign any special role to this service account. Simply follow the prompts to create the account.
- Download Credentials: Once the service account is created, a JSON file containing the credentials of the service account will be automatically generated. Download this file and keep it safe. You will need the
client_emailandprivate_keyfrom this file to setup the Google Sheets Action.
Step 2: Sharing the Spreadsheet
- Share Spreadsheet: Go to the Google Spreadsheet that you want to use with this action. Click on the "Share" button (usually at the top right corner) and in the sharing settings, add the
client_email(that you got from the downloaded JSON file) with read permissions. - Get Document ID: The document ID is the string of random characters in the URL of your Google Spreadsheet, found between '/d/' and '/edit'. Keep this document ID handy.
Build with
- googleapis - The node module used for manipulating the google sheet
- oclif - The node module used to create the cli
- semantic-release - for releasing new versions
- typescript
Contributing
Please read CONTRIBUTING.md for details on our code of conduct, and the process for submitting pull requests to us.
Versioning
We use SemVer for versioning. For the versions available, see the tags on this repository.
License
This project is licensed under the MIT License - see the LICENSE file for details
TODO
- documentation
- more tests
- add prettier
No vulnerabilities found.
Reason
no dangerous workflow patterns detected
Reason
no binaries found in the repo
Reason
license file detected
Details
- Info: project has a license file: LICENSE:0
- Info: FSF or OSI recognized license: MIT License: LICENSE:0
Reason
SAST tool detected but not run on all commits
Details
- Info: SAST configuration detected: CodeQL
- Warn: 0 commits out of 18 are checked with a SAST tool
Reason
dependency not pinned by hash detected -- score normalized to 2
Details
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/cleanup.yml:22: update your workflow using https://app.stepsecurity.io/secureworkflow/jroehl/google-sheet-cli/cleanup.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/cleanup.yml:24: update your workflow using https://app.stepsecurity.io/secureworkflow/jroehl/google-sheet-cli/cleanup.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/cleanup.yml:33: update your workflow using https://app.stepsecurity.io/secureworkflow/jroehl/google-sheet-cli/cleanup.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/cleanup.yml:38: update your workflow using https://app.stepsecurity.io/secureworkflow/jroehl/google-sheet-cli/cleanup.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/codeql-analysis.yml:42: update your workflow using https://app.stepsecurity.io/secureworkflow/jroehl/google-sheet-cli/codeql-analysis.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/codeql-analysis.yml:46: update your workflow using https://app.stepsecurity.io/secureworkflow/jroehl/google-sheet-cli/codeql-analysis.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/codeql-analysis.yml:57: update your workflow using https://app.stepsecurity.io/secureworkflow/jroehl/google-sheet-cli/codeql-analysis.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/codeql-analysis.yml:71: update your workflow using https://app.stepsecurity.io/secureworkflow/jroehl/google-sheet-cli/codeql-analysis.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/test-and-release.yml:67: update your workflow using https://app.stepsecurity.io/secureworkflow/jroehl/google-sheet-cli/test-and-release.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/test-and-release.yml:73: update your workflow using https://app.stepsecurity.io/secureworkflow/jroehl/google-sheet-cli/test-and-release.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/test-and-release.yml:78: update your workflow using https://app.stepsecurity.io/secureworkflow/jroehl/google-sheet-cli/test-and-release.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/test-and-release.yml:97: update your workflow using https://app.stepsecurity.io/secureworkflow/jroehl/google-sheet-cli/test-and-release.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/test-and-release.yml:22: update your workflow using https://app.stepsecurity.io/secureworkflow/jroehl/google-sheet-cli/test-and-release.yml/master?enable=pin
- Warn: GitHub-owned GitHubAction not pinned by hash: .github/workflows/test-and-release.yml:24: update your workflow using https://app.stepsecurity.io/secureworkflow/jroehl/google-sheet-cli/test-and-release.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/test-and-release.yml:33: update your workflow using https://app.stepsecurity.io/secureworkflow/jroehl/google-sheet-cli/test-and-release.yml/master?enable=pin
- Warn: third-party GitHubAction not pinned by hash: .github/workflows/test-and-release.yml:38: update your workflow using https://app.stepsecurity.io/secureworkflow/jroehl/google-sheet-cli/test-and-release.yml/master?enable=pin
- Info: 0 out of 9 GitHub-owned GitHubAction dependencies pinned
- Info: 0 out of 7 third-party GitHubAction dependencies pinned
- Info: 3 out of 3 npmCommand dependencies pinned
Reason
Found 0/14 approved changesets -- score normalized to 0
Reason
0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0
Reason
detected GitHub workflow tokens with excessive permissions
Details
- Info: jobLevel 'actions' permission set to 'read': .github/workflows/codeql-analysis.yml:28
- Info: jobLevel 'contents' permission set to 'read': .github/workflows/codeql-analysis.yml:29
- Warn: no topLevel permission defined: .github/workflows/cleanup.yml:1
- Warn: no topLevel permission defined: .github/workflows/codeql-analysis.yml:1
- Warn: topLevel 'contents' permission set to 'write': .github/workflows/test-and-release.yml:11
- Info: no jobLevel write permissions found
Reason
no effort to earn an OpenSSF best practices badge detected
Reason
security policy file not detected
Details
- Warn: no security policy file detected
- Warn: no security file to analyze
- Warn: no security file to analyze
- Warn: no security file to analyze
Reason
project is not fuzzed
Details
- Warn: no fuzzer integrations found
Reason
10 existing vulnerabilities detected
Details
- Warn: Project is vulnerable to: GHSA-67hx-6x53-jw92
- Warn: Project is vulnerable to: GHSA-grv7-fg5c-xmjg
- Warn: Project is vulnerable to: GHSA-3xgq-45jj-v275
- Warn: Project is vulnerable to: GHSA-ghr5-ch3p-vcr6
- Warn: Project is vulnerable to: GHSA-4q6p-r6v2-jvc5
- Warn: Project is vulnerable to: GHSA-78xj-cgh5-2h22
- Warn: Project is vulnerable to: GHSA-2p57-rm9w-gvfp
- Warn: Project is vulnerable to: GHSA-952p-6rrq-rcjv
- Warn: Project is vulnerable to: GHSA-c2qf-rxjj-qqgw
- Warn: Project is vulnerable to: GHSA-f5x3-32g6-xq36
Score
3.4
/10
Last Scanned on 2024-11-25
The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software (OSS). The Scorecard provides security health metrics for open source projects.
Learn More