sheets-reader

Read Google Sheets data and return parsed tabular output with summaries.

Updated Apr 23, 2026
One-click install
npx skills add https://github.com/ngochuy13/intern-dev --skill sheets-reader
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: sheets-reader
Source: https://github.com/ngochuy13/intern-dev/tree/main/skills/sheets-reader
Command: npx skills add https://github.com/ngochuy13/intern-dev --skill sheets-reader

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It eliminates the time-consuming effort of manually opening spreadsheets to find specific values or compile reports, especially when the sheet grows large or the user needs repeatable lookups.

Core Features & Use Cases

  • Read and query spreadsheet data: Fetch single cells, named ranges, full sheets, or multiple ranges for the exact information the user needs.
  • Summarize and filter results: Turn raw rows/columns into a usable table plus a short key insight or filtered output based on the user’s request.
  • Lookup and locate records: Find a row by a key value (for example, a person name in a specific column) and present the matching record clearly.

Quick Start

Read the sales data from my Google Sheets spreadsheet URL and return the relevant range as a formatted table with a brief summary.

Frequently Asked Questions about sheets-reader

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I read and summarize Google Sheets data without opening the spreadsheet?

To read and summarize Google Sheets data, you need a spreadsheets.readonly OAuth access token to fetch specific cells, ranges, or worksheets. The Skill retrieves values via Google Sheets API endpoints and presents parsed tabular output with a brief summary.

Can I look up a specific row in Google Sheets by a key value like a person's name?

Yes, you can look up a specific row in Google Sheets by searching for a key value, such as a person's name in a specific column. The Skill locates the matching record and presents the corresponding row data clearly.

Do I need an OAuth access token to retrieve tabular data from Google Sheets?

Yes, retrieving tabular data from Google Sheets requires a spreadsheets.readonly OAuth access token. This token authorizes the Skill to use Google Sheets API endpoints to fetch spreadsheet metadata and values securely.

What is the best way to extract a predefined range from a Google Sheets worksheet?

The best way to extract a predefined range from a Google Sheets worksheet is to specify the range when querying the API. The Skill fetches the exact values requested and formats them into a header-aware table for analysis.

Can I list all sheet tabs in a Google Sheets spreadsheet using an API integration?

Yes, you can list all sheet tabs in a Google Sheets spreadsheet. The Skill fetches spreadsheet metadata via the Google Sheets API to identify available worksheets and extract values from the specified tabs.

How do I filter raw Google Sheets rows and columns into a summarized table?

To filter raw Google Sheets rows and columns, the Skill retrieves the requested data and applies header-aware formatting. It turns raw tabular data into a usable table and provides a short key insight based on your request.