Skip to content
Get packs

Google Sheets Reader

Lets the agent read cell values from a Google Sheet via the gws CLI

Source Download skill
Repository
googleworkspace/cli
Stars
32,059
Licence
Apache-2.0
Files
1 file

What it does

This skill teaches an AI agent to pull values out of a Google Sheets spreadsheet using the gws command-line tool. Once installed, when you ask the agent for data from a specific sheet or cell range, it runs a read-only command and works with the returned values. It does not change the spreadsheet.

Great for

  • People who want an agent to summarise or analyse numbers stored in a Google Sheet
  • Developers building scripts or reports that pull spreadsheet values
  • Teams that keep operational data in Sheets and want quick lookups without opening the browser

Skip it if

  • Writing, editing or formatting a spreadsheet, since this skill is read-only and the write commands live in a different skill (gws-sheets)
  • Setups where the gws CLI is not installed or not authenticated to your Google account, because the skill cannot work without it
  • Sensitive spreadsheets you do not want an agent to access, since reading them requires your Google credentials to be used through the CLI

Try asking

  • “Read the values in Sheet1!A1:D10 from my sales spreadsheet and summarise the totals”
  • “Show me everything on the Inventory tab of this spreadsheet ID”
  • “Pull the first two columns of the budget sheet so we can compare them with last month”
Step-by-step guide: how to use Google Sheets ReaderInstall, 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-read.zip
  2. 2

    Add it to your agent

    Claude Code (all projects)

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

    Claude Code / Agent SDK (this project only)

    mkdir -p .claude/skills && unzip gws-sheets-read.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

  • Give the full range such as Sheet1!A1:D10 to avoid reading more data than you need
  • Run gws generate-skills first if the shared gws-shared skill file is missing
  • Check the gws auth setup before first use so the agent can reach your spreadsheet

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.