Your clients' access, one API away

pip install operate-as operate-as-sheets

import os

from operate_as import OperateAs
from operate_as_sheets import Sheets

# Create the client once, with the key from the environment
operate = OperateAs(os.environ["OPERATE_AS_API_KEY"])

# One of your clients, by the id the dashboard shows
miller = operate.client("6f1c2a7e-...")

# Read rows from their sheet
rows = Sheets(miller).read_rows(spreadsheet_id="1BxiM...", range="A1:D20")
print(rows.status, rows.data["values"])

npm install operate-as @operate-as/sheets

import { OperateAs } from "operate-as";
import { Sheets } from "@operate-as/sheets";

// Create the client once, with the key from the environment
const operate = new OperateAs(process.env.OPERATE_AS_API_KEY);

// One of your clients, by the id the dashboard shows
const miller = operate.client("6f1c2a7e-...");

// Read rows from their sheet
const rows = await new Sheets(miller).readRows({ spreadsheetId: "1BxiM...", range: "A1:D20" });
console.log(rows.status, rows.data);

go get github.com/arcarolabs/operate-as-go \
  github.com/arcarolabs/operate-as-go/services/sheets

package main

import (
	"context"
	"fmt"
	"os"

	operateas "github.com/arcarolabs/operate-as-go"
	"github.com/arcarolabs/operate-as-go/services/sheets"
)

func main() {
	ctx := context.Background()

	// Create the client once, with the key from the environment
	operate := operateas.New(os.Getenv("OPERATE_AS_API_KEY"))

	// One of your clients, by the id the dashboard shows
	miller := sheets.New(operate, "6f1c2a7e-...")

	// Read rows from their sheet
	rows, err := miller.ReadRows(ctx, sheets.ReadRowsInput{SpreadsheetID: "1BxiM...", Range: "A1:D20"})
	if err != nil {
		panic(err)
	}
	fmt.Println(rows.Status, string(rows.Data))
}

export OPERATE_AS_API_KEY="oa_..."

# The clients this key can reach, and what each has connected
curl https://api.operate.as/v1/me/clients \
  -H "Authorization: Bearer $OPERATE_AS_API_KEY"

# Read rows from one client's sheet
curl -X POST https://api.operate.as/v1/actions/sheets.read_rows \
  -H "Authorization: Bearer $OPERATE_AS_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "clientId": "6f1c2a7e-...",
    "input": { "spreadsheet_id": "1BxiM...", "range": "A1:D20" }
  }'

claude mcp add --transport http operate-as https://api.operate.as/v1/mcp \
  --header "Authorization: Bearer oa_..."

// "Read the first rows of Miller Dental's bookings sheet"

// The agent finds the client and what they've connected
{ "name": "list_clients", "arguments": {} }

// Then reads rows from their sheet
{
  "name": "sheets_read_rows",
  "arguments": {
    "client_id": "6f1c2a7e-...",
    "spreadsheet_id": "1BxiM...",
    "range": "A1:D20"
  }
}

# Settings > Community nodes > Install
npm package name: n8n-nodes-operate-as

# Credentials > New > Operate As API
API Key: oa_...

Credential: Operate As API
Client: Miller Dental
Operation: Run an Action
Action: "sheets: Read rows from a range of a spreadsheet"
Inputs:
  spreadsheet_id: 1BxiM...
  range: A1:D20