​
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

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