Skip to content

Google Sheets Access

Lets the agent read and write Google Sheets spreadsheets through the gws command-line tool.

Stars
32,059
Licence
Apache-2.0
Files
1 file

What it does

Once installed, the agent knows how to use the gws command-line tool to work with Google Sheets: it can append rows, read values, create spreadsheets, and apply batch updates to existing ones. The skill mainly provides a map of available commands and a tip to inspect each method's parameters with gws schema before calling it. It relies on the separate gws tool and its shared authentication setup to actually reach your Google account.

Great for

  • People who already use Google Sheets and want the agent to log, pull, or update rows for them
  • Developers automating spreadsheet tasks in scripts or workflows that already use the gws CLI
  • Data or operations staff who need quick reads or appends from a spreadsheet

Skip it if

  • Anyone without a Google account or without the gws tool installed, since the skill cannot work on its own (reason: it only documents commands)
  • Sensitive spreadsheets where the agent should not have write access (reason: the skill can modify and create spreadsheets through your authenticated account)

Try asking

  • “Append a new row with today's sales figures to my tracking spreadsheet”
  • “Read the values in the Expenses sheet of my budget spreadsheet and summarise them”
  • “Create a new spreadsheet called Q3 Roadmap”
  • “Apply a batch update to rename a sheet and format the header row in this spreadsheet”
Step-by-step guide: how to use Google Sheets AccessInstall, first run, examples, tips and FAQs

Install in 3 steps

  1. 1

    Download the skill

    The ZIP contains the 1 original files, the Apache-2.0 licence and an attribution note.

    gws-sheets.zip
  2. 2

    Add it to your agent

    Claude Code (all projects)

    mkdir -p ~/.claude/skills && unzip gws-sheets.zip -d ~/.claude/skills/

    Claude Code / Agent SDK (this project only)

    mkdir -p .claude/skills && unzip gws-sheets.zip -d .claude/skills/

    Claude apps (web/desktop): Settings → Capabilities → Skills → Upload skill, and choose the ZIP.

  3. 3

    Ask for the task

    No special command needed — the agent reads the skill's description and loads it when your request matches. Try one of the prompts above.

Get better results

  • Run gws sheets --help and gws schema sheets.<resource>.<method> before writing commands so parameters are correct.
  • Start with read-only helpers like +read on a test spreadsheet before allowing writes or batchUpdate on real data.
  • Run gws generate-skills first if the shared prerequisite file is missing.

What's inside

  • SKILL.md

Redistributed unmodified from googleworkspace/cli under the Apache-2.0 licence. The assessment was drafted with AI from the skill's files on 2026-10-29. Skills can instruct your agent to run code — read SKILL.md and any scripts before installing.