Google Sheets - jinba

Overview

Enables spreadsheet data operations and automation using the Google Sheets API.

Key Features

GOOGLE_SHEETS_EDIT_SHEET
- Edit a Google Sheet by providing the spreadsheet ID, range, and values.
GET_SHEET
- Retrieve data from a Google Sheet by specifying the spreadsheet ID and range.

Authentication

For further details, click here. To use the Google Sheets API, you need navigate to the Jinba secrets dashboard and authenticate with your Google account. This will create a new OAuth token for you. Note: Treat API keys as sensitive information and never commit them to public repositories.

Example: Edit and Get Sheet Data

- id: edit_sheet
  tool: GOOGLE_SHEETS_EDIT_SHEET
  config:
    - name: token
      value: "{{secrets.GOOGLE_SHEETS_OAUTH_TOKEN}}"
  input:
    - name: spreadsheet_id
      value: "0123456789"
    - name: range
      value: Sheet1!A1:D5
    - name: values
      value: '[["A1", "B1"], ["A2", "B2"]]'
- id: get_sheet
  tool: GET_SHEET
  config:
    - name: token
      value: "{{secrets.GOOGLE_SHEETS_OAUTH_TOKEN}}"
  input:
    - name: spreadsheet_id
      value: "0123456789"
    - name: range
      value: Sheet1!A1:D5