Back to Skills

gws-sheets-read

Google Sheets: Read values from a spreadsheet.

24,602stars1,249forksUpdated 4/14/2026

Security Assessment

Safe(100/100)
Security Score100/100

About gws-sheets-read

The 'gws-sheets-read' skill provides a simple and efficient way to read data from Google Sheets, solving the problem of retrieving specific ranges of values from a spreadsheet without modifying the content. It allows users to extract data based on a given spreadsheet ID and range, offering a streamlined solution for read-only access to Google Sheets. This skill is ideal for users who need to fetch data for analysis, reporting, or integration with other systems, all while ensuring that the spreadsheet itself remains untouched.

Key features of the 'gws-sheets-read' skill include the ability to specify a precise range of cells within a spreadsheet using the '--range' flag, allowing for fine-grained control over what data is retrieved. Users only need to provide the spreadsheet ID and range, with minimal setup required. The skill is read-only, ensuring that no data within the spreadsheet is altered during the process. For advanced users, the underlying raw API (values.get) can be leveraged for more complex operations or scenarios. The skill is part of the broader Google Workspace Skills (GWS) suite, making it suitable for a variety of productivity and automation tasks.

This skill is designed for users working with Google Sheets in professional settings, including data analysts, project managers, and developers integrating Google Sheets data into their workflows. It is particularly useful for applications where data needs to be read and used without altering the original spreadsheet, such as reporting tools, dashboards, or any system that interacts with spreadsheets for data retrieval.

FAQ

How do I use the gws-sheets-read skill?

To use the gws-sheets-read skill, you need to run the command 'gws sheets +read' followed by the '--spreadsheet' flag with the ID of the spreadsheet and the '--range' flag specifying the range you want to read (e.g., 'Sheet1!A1:B2').

What is the prerequisite for using this skill?

Before using this skill, you must read the '../gws-shared/SKILL.md' document for authentication, global flags, and security rules. If it's missing, you can run 'gws generate-skills' to generate the necessary files.

Can I modify the spreadsheet using this skill?

No, the 'gws-sheets-read' skill is read-only. It only allows you to retrieve values from the spreadsheet without making any changes to the data.

What version of the gws-sheets-read skill am I using?

The current version of the gws-sheets-read skill is 0.22.5.

Is there any alternative for advanced usage?

For more advanced use cases, you can use the raw 'values.get' API for more detailed control over the data retrieval process.

Install gws-sheets-read

Download and extract the skill files to your .claude/skills/ directory.

Quick Setup:

  1. Copy the skill folder to .claude/skills/
  2. Claude will automatically detect and use the skill