Google Sheets Skill for AI Agents: 6 Actions, Free to Start 2026
Orthogonal's Google Sheets skill gives AI agents 6 actions: create spreadsheets, read ranges, update cells, add rows, and search data. Pay-per-call, $10 free.
Orthogonal's Google Sheets skill gives AI agents 6 actions to read, write, and search spreadsheet data through a single OAuth connection. It runs on the Orthogonal pay-per-call platform via the orth CLI, with no monthly subscription and $10 in free starting credits. Compatible with Claude Code and Cursor. Best for agents that output structured data into spreadsheets for non-technical users.
Orthogonal's Google Sheets skill gives AI agents 6 spreadsheet actions: create spreadsheets, list sheet names, add rows, lookup rows by keyword, get cell values from ranges, and update cells with 2D data arrays. It uses OAuth to link your Google account through the Orthogonal platform and requires the orth CLI running Node 18+. Compatible with Claude Code, Cursor, and any MCP client. Pricing is pay-per-call with $10 in free credits for new accounts.
Maker: Orthogonal · Protocol: MCP · Auth: oauth
Compatible agents: Claude Code, Cursor, Any orth CLI-compatible agent, Any MCP-compatible client
Required runtime: Node >= 18 (for orth CLI), Orthogonal account with credits, Google account connected via OAuth
About Google Sheets
The Google Sheets skill from Orthogonal is a SKILL.md package that gives AI agents 6 spreadsheet management actions: create spreadsheets, retrieve sheet names, add rows, look up rows by keyword, get cell values from ranges, and update cell values. It is part of the orthogonal-sh/skills open-source repository, which contains 90+ skills for AI agents. Orthogonal, a YC W26-backed company, acts as a unified API gateway so agents can access Google Sheets alongside 90+ other integrations using a single API key and no per-service OAuth setup. The skill works via the orth CLI: agents call `orth run google-sheets /action-name --body '{"params"}'`, which routes the request through Orthogonal's REST API to the Google Sheets API v4. A one-time OAuth 2.0 connection at orthogonal.com/dashboard/integrations links the user's Google account; the skill returns HTTP 428 if that connection is inactive. The skill requires Node 18+ for the orth CLI and is also accessible through the Orthogonal MCP server in Claude Desktop and Cursor. Common use cases include writing agent-generated research results into a spreadsheet, reading CRM data from Sheets for lead enrichment, updating inventory or project tracking sheets automatically, and searching large datasets by keyword. The /lookup-row action accepts a text query and an A1-notation range, returning all rows where the query appears. The /get-values action fetches multiple ranges in a single call, reducing round trips when reading headers and data separately. The /update-values action writes 2D arrays of data starting from any cell location, with USER_ENTERED mode for formulas or RAW mode for literal values. Pricing is pay-per-call through Orthogonal's platform with no monthly subscription. New accounts receive $10 in free credits to start. Per-call rates are listed at orthogonal.com/pricing. The SKILL.md file is open source in the orthogonal-sh/skills GitHub repository, so the instructions are freely readable regardless of billing status. Orthogonal was accepted into Y Combinator's W26 batch, founded by Christian Pickett (ex-Coinbase payments, ex-Vercel billing) and Bera Sogut (ex-Google reCAPTCHA/Maps, ex-Amazon Robotics). The skills repository received its most recent commit in June 2026 and covers integrations spanning developer tools, communication, productivity, and data APIs.
Key Features
- Create Spreadsheets: Create new Google Sheets spreadsheets with a custom title using a single /create-spreadsheet call that returns the new spreadsheet ID for use in subsequent operations.
- Get and Update Cell Values: The /get-values action fetches data from multiple A1-notation ranges in a single request; /update-values writes 2D arrays starting from any cell, with USER_ENTERED mode for formula interpretation or RAW mode for literal values.
- Lookup Row by Keyword: The /lookup-row action searches a specified range for a text query, with optional case-sensitive matching, returning all matching rows without requiring the agent to fetch and scan all data manually.
- Add Rows: Insert empty rows at a specific index in a sheet using numeric sheet IDs (not names), with optional formatting inheritance from the row above using inherit_from_before.
- List Sheet Names: Retrieve all sheet names and their numeric IDs from a spreadsheet with a single /get-sheet-names call, which is needed before most other operations since update-values uses sheet names while add-row uses numeric IDs.
- A1 Notation Support: All range parameters accept standard A1 notation including open ranges (A:A for full columns, 1:1 for full rows), cross-sheet references (Sheet1!A1:B2), and quoted sheet names for names containing spaces.
How to Invoke
Agent runs `orth run google-sheets /action-name --body '{"params"}'` via the orth CLI or Orthogonal MCP server
Pricing
Pay-per-call via Orthogonal platform. New accounts get $10 in free credits. No monthly subscription. Per-call rates at orthogonal.com/pricing.
Strengths
- 6 well-defined actions cover the full spreadsheet workflow: create, read (get-values), write (update-values), insert rows, keyword search (lookup-row), and enumerate sheets.
- The /get-values action accepts multiple ranges in one call, reducing round trips when reading headers plus data rows in a single agent turn.
- Single Orthogonal API key covers Google Sheets plus 90+ other integrations; no Google Cloud project or separate OAuth app needed.
Weaknesses
- No action for deleting rows, columns, or entire sheets; complex sheet restructuring requires falling back to the Google Sheets API directly.
- The /add-row action inserts an empty row (no data); populating it requires a separate /update-values call, which adds latency and extra credits per insert operation.
- Spreadsheet IDs and numeric sheet gids must be retrieved separately before most write operations, which new users find confusing since Google Sheets URLs contain both.
Frequently Asked Questions
What is Google Sheets (via Orthogonal) and what does it do?
Orthogonal's Google Sheets skill is a SKILL.md package that gives AI agents 6 callable spreadsheet actions: /create-spreadsheet, /get-sheet-names, /add-row, /lookup-row, /get-values, and /update-values. It is published by Orthogonal, a YC W26-backed unified API platform with 90+ skills in its open-source GitHub repository at github.com/orthogonal-sh/skills. Agents invoke these actions using the orth CLI command `orth run google-sheets /action-name --body '{"params"}'`, which routes to the Google Sheets API v4 through Orthogonal's REST gateway. Authentication is a one-time OAuth 2.0 connection at orthogonal.com/dashboard/integrations; the skill returns HTTP 428 if the connection is not active. Common use cases include writing agent research output into a spreadsheet, reading CRM data for processing, and updating project tracking sheets automatically. The /lookup-row action makes it possible to search large sheets by keyword without fetching all data, and /get-values supports multiple ranges in a single call to minimize API round trips. This skill is designed for agents, not for human users who want a visual spreadsheet interface.
How much does Google Sheets (via Orthogonal) cost in 2026?
Orthogonal's pricing model is pay-per-call with no monthly subscription or minimum spend. New accounts receive $10 in free starting credits, providing an initial set of Google Sheets API calls at no cost. Each action (create, get-values, update-values, add-row, lookup-row, get-sheet-names) consumes a small credit amount per call; exact per-call prices are listed at orthogonal.com/pricing. Once the $10 credit balance is depleted, additional credits must be purchased through the Orthogonal dashboard to continue. Google Sheets itself is free with a Google account, so the cost is entirely Orthogonal's platform fee for routing the calls. The SKILL.md file is open source under the orthogonal-sh/skills GitHub repository and is free to read or self-host. There are no hidden fees beyond per-call credit consumption.
What are the main features of Google Sheets (via Orthogonal)?
The Google Sheets skill provides 6 actions covering creation, reading, writing, inserting, and searching. The /create-spreadsheet action creates a new spreadsheet with a custom title and returns the spreadsheet ID needed for subsequent calls. The /get-sheet-names action retrieves all sheet names and their numeric gid values, which are required for the /add-row action (takes numeric gid) versus /update-values (takes sheet name). The /get-values action fetches data from multiple A1-notation ranges in a single request, useful for reading headers and data rows together. The /update-values action writes 2D value arrays starting from any cell, with USER_ENTERED mode for formula support or RAW for literal values. The /lookup-row action searches a specified range for a text query with optional case-sensitive matching. The /add-row action inserts an empty row at a specified index with optional formatting inheritance from the row above.
Is Google Sheets (via Orthogonal) free to use?
The skill is not permanently free; Orthogonal's pay-per-call billing means credits are consumed for each spreadsheet operation. New Orthogonal accounts receive $10 in free starting credits, covering an initial set of Google Sheets operations with no upfront cost. After the $10 credit balance is depleted, additional credits must be purchased through the Orthogonal dashboard. There is no unlimited free tier for ongoing use. Google Sheets itself is free for all Google account holders, so the only cost is Orthogonal's per-call platform fee. The SKILL.md file from the orthogonal-sh/skills repository is free and open source, so you can study the action structure without an Orthogonal account. Developers who need high-volume Sheets access should compare Orthogonal's per-call cost against using the Google Sheets API directly through a Google Cloud project, which is free within Google's standard quota of 100 requests per 100 seconds per user.
What are the best alternatives to Google Sheets (via Orthogonal)?
The most direct alternative is the official Google Sheets API v4, which is free within Google's quota limits (100 requests/100 seconds/user) but requires a Google Cloud project with OAuth credentials configured, adding setup overhead. Composio offers a Google Sheets integration compatible with Claude, GPT-4, and Cursor that handles OAuth management and is billed per operation, similar to Orthogonal. Zapier's Google Sheets integration supports reading and writing rows via trigger/action pairs but is designed for no-code workflow automation rather than agent programmatic access. Make (formerly Integromat) offers similar no-code Sheets automation at lower monthly cost than Zapier. Notion is a common alternative for teams that prefer a database-style interface over spreadsheets, though it is a different product category. Airtable's MCP server is an emerging option for agents that need spreadsheet-like data with stronger querying than Google Sheets supports natively. Choose Orthogonal if you already use other Orthogonal skills; choose the direct Google Sheets API if Sheets is your only integration and you want zero per-call cost.
Who is Google Sheets (via Orthogonal) best for?
This skill is ideal for developers building agents in Claude Code or Cursor that need to write structured output (research results, lead lists, reports) into Google Sheets for non-technical stakeholders. Teams using multiple Orthogonal skills benefit most, since adding Google Sheets does not require a separate OAuth app or Google Cloud project. Founders building lightweight CRM or data collection pipelines backed by Google Sheets are a strong fit, especially when the volume of API calls stays under a few hundred per day. It is not the right tool for teams requiring real-time collaborative spreadsheet editing, complex formula evaluation, or chart generation, which still require a human in Google Sheets. High-volume ETL pipelines processing thousands of rows daily will find Orthogonal's per-call billing more expensive than using the Google Sheets API directly through a GCP project at no charge. Enterprise teams needing SOC 2 audit trails or fine-grained IAM controls should verify Orthogonal's current compliance posture before adopting.
How do you get started with Google Sheets (via Orthogonal)?
Sign up at orthogonal.com to receive your $10 in free starting credits. Install the orth CLI by running `npm install -g @orth/cli` in a terminal with Node 18 or later installed. Log in with `orth login` using your Orthogonal credentials. Navigate to orthogonal.com/dashboard/integrations, find Google Sheets, and complete the OAuth flow to connect your Google account; an active connection badge confirms success. Install the skill with `orth skills add google-sheets`, which places the SKILL.md file in your agent's skills directory (e.g., ~/.claude/skills/ for Claude Code or ~/.cursor/skills/ for Cursor). Test the integration by running `orth run google-sheets /create-spreadsheet --body '{"title":"Test Sheet"}'` from your terminal and confirming a spreadsheet ID is returned. From there, use the returned spreadsheet ID in /get-sheet-names to get numeric sheet IDs before writing rows.
How does Google Sheets (via Orthogonal) compare to using the Google Sheets API directly in 2026?
The Google Sheets API v4 accessed directly through a Google Cloud project is free within Google's standard quota (100 read or write requests per 100 seconds per user), while Orthogonal charges a per-call fee that accumulates with volume. Direct API access requires creating a Google Cloud project, enabling the Sheets API, setting up OAuth 2.0 credentials, and managing token refresh, which adds 30-60 minutes of setup versus Orthogonal's 2-minute orth CLI flow. Orthogonal's skill wraps 6 common actions with clear parameters and readable errors (HTTP 428 for disconnected OAuth), while the raw API exposes all 30+ Sheets methods with more complexity. For an agent that only uses Google Sheets, the direct API is cheaper at scale; for an agent using Google Sheets plus Gmail, Calendar, Notion, and other services, Orthogonal's single API key is faster to set up and maintain. Orthogonal does not expose advanced Sheets operations like conditional formatting, chart creation, or pivot tables; for those, the direct API is required. The open-source orthogonal-sh/skills SKILL.md is a useful reference even if you use the direct API, since it documents the most common parameter combinations.