Google Sheets

Service Overview

Google Sheets is the official spreadsheet and productivity api from Google for sheets, spreadsheets, productivity, and data. This Hub entry keeps the service explanation, setup links, and Harbor-safe import path together so operators can review the integration before local credentials and policies are applied.

What This Port Does

• Fetch spreadsheet metadata including all sheet names, properties, and named ranges for a given spreadsheet ID.
• Read cell values from a named range in a spreadsheet with typed render controls.
• Append one or more rows after the last row with data in the specified range using a bounded JSON payload.
• Includes 6 Harbor-safe action templates that can be reviewed and enabled selectively.
• Keeps service credentials local to Harbor Node so approval, execution, and audit stay inside the Harbor ecosystem.

Operator Setup

• Create or confirm a Google account, workspace, or tenant with the API access needed for the actions you plan to enable.
• Import this Hub entry into Harbor, then verify the service base URL and connection settings before testing actions.
• Store the required Bearer token locally in Harbor Node using the Authorization header, then review automatic versus approval-required actions before publish.
• Use the vendor setup guide linked below to create service credentials, scopes, or app registration settings that match your Harbor policy.

Install

https://hub.breakwaterharbor.net/p/google/google-sheets

Actions

{
  "slug": "get-spreadsheet",
  "label": "Get Spreadsheet",
  "description": "Fetch spreadsheet metadata including all sheet names, properties, and named ranges for a given spreadsheet ID.",
  "method": "GET",
  "path": "/v4/spreadsheets/{spreadsheetId}",
  "inputs": {
    "parameters": [
      {
        "name": "spreadsheetId",
        "in": "path",
        "required": true,
        "schema": {
          "type": "string",
          "minLength": 1
        },
        "description": "Spreadsheet ID."
      },
      {
        "name": "includeGridData",
        "in": "query",
        "schema": {
          "type": "boolean"
        },
        "description": "Whether to include full grid data."
      }
    ]
  },
  "approvalMode": "automatic",
  "requestBodyMode": "none",
  "resultMode": "json_summary"
}

Workflows