A simple helper cli to interact with google sheets.

• google-sheet-cli
  • Usage as CLI
  • Usage as library
• Command Topics
• Info
  • How to configure
    • Step 1: Setting Up Google Service Account
    • Step 2: Sharing the Spreadsheet
  • Build with
  • Contributing
  • Versioning
  • License
  • TODO

$ npm install -g google-sheet-cli
$ google-sheet COMMAND
running command...
$ google-sheet (--version)
google-sheet-cli/0.0.0 darwin-arm64 node-v18.16.0
$ google-sheet --help [COMMAND]
USAGE
  $ google-sheet COMMAND
...

You can import the GoogleSheet class as a module and use it without the cli functionality. See code: src/lib/google-sheet.ts

• google-sheet data - Manage data in worksheet
• google-sheet help - Display help for google-sheet.
• google-sheet spreadsheet - Manage spreadsheets
• google-sheet worksheet - Manage worksheets

1. Login to Google API Console: Visit the Google Cloud Console website (https://console.cloud.google.com/) and log in using your Google account credentials.
2. Enable Google Sheets API: In the Google Cloud Console, navigate to the "Library" section. Here, search for "Google Sheets API" and enable it.
3. 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.
4. 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_email and private_key from this file to setup the Google Sheets Action.

1. 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.
2. 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.

• 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

Please read CONTRIBUTING.md for details on our code of conduct, and the process for submitting pull requests to us.

We use SemVer for versioning. For the versions available, see the tags on this repository.

This project is licensed under the MIT License - see the LICENSE file for details

• documentation
• more tests
• add prettier