OrgSDK — Lockup (Light)OrgSDK
Plugin directory

Data & AI

Google Sheets + AI Agents

Read and write Google Sheets from agent workflows.

Auth: OAuthPart of a suitev1.0.1
spreadsheetsgoogledata
Install

Auth & credentials

Auth method

OAuth

Google (Connect Google)

Storage

Encrypted at rest, limited to the agents and tools you authorize, and not logged in plaintext.

Scope

Enable Google Sheets only for the agents that need it.

Connect: Connect once in Google Sheets to use Google Sheets and Google Tasks. Bring your own Google OAuth client if needed.

What it touches: Access Google Sheets and Tasks data via OAuth.

What your agents can do with Google Sheets

Concrete jobs an agent team handles with Google Sheets, each running on a schedule or on demand.

Capability

Sync CRM or form data into a structured sheet table

Capability

Generate weekly reports by appending agent run results

Capability

Update specific rows in a table from workflow output

Capability

Read a sheet as a config or lookup source for an agent

Built for agent teams

Every OrgSDK integration ships with the same guarantees — this is what makes Google Sheets useful, not just connected.

Runs on a schedule

Agents don't just answer chats. They run on a schedule — 24/7 — so Google Sheets work happens even when you're asleep.

Approval gates

Agents can hold any irreversible Google Sheets step behind a human sign-off using the built-in approval action. Add it to a workflow where it matters — approvals are an explicit capability, not enforced on every call.

Per-agent enable

Grant Google Sheets only to the agents that need it. Credentials are encrypted at rest and surfaced only through an agent's enabled plugin functions when a workflow needs them.

Encrypted at rest

Your Google Sheets credentials are encrypted and stored per-org. OrgSDK never reads or logs them in plaintext.

Capability safety — 7 actions

Grouped from each function's source metadata. Read-only actions are non-mutating; write actions create, update, or delete data.

Read-only · non-mutating

3
getSheetData

Read values from a Google Sheet range

getTableData

Read all data rows from a structured Google Sheet table. Returns rows as objects with column names as keys. Each row includes _rowIndex for updates. Use listSheetTables to find tableId.

listSheetTables

List all structured tables in a Google Sheet. Returns array with tableId (string), name, sheetId, sheetTitle, range (GridRange), a1Range (A1 notation for debugging).

Write & mutating

4
appendToSheet

Append rows to a Google Sheet range. Always pass a 2D array: [[val1, val2], ...]. Spreadsheet ID + range are passed at runtime.

appendToTable

Append rows to a structured Google Sheet table. Pass rows as objects keyed by column name: [{ Provider: 'X', Amount: 100 }, ...]. Column names must match table headers exactly. Use listSheetTables to find tableId. Formula detection: strings starting with '='.

clearSheet

Clear values in a Google Sheet range. Tip: use a range that excludes headers (e.g. Sheet1!A2:Z)

updateTableRow

Update specific columns in a row of a Google Sheet table. Use _rowIndex from getTableData. Pass updates as { columnName: newValue }.

How install works

Plans start at $58/mo. Every org runs in its own isolated cloud environment.
  1. 01

    Choose a plan

    Starter or Pro. Your managed workspace is ready in seconds.

  2. 02

    Install

    Add Google Sheets from the plugin directory — one click, no config files.

  3. 03

    Connect & enable

    Authorize Google Sheets, then enable it for the agents that need it.

Put Google Sheets in the hands of a persistent agent team.

Choose Starter or Pro, create your org, and install Google Sheets in minutes.

Get started