skills.rest
gemini-cli-extensions
gemini-cli-extensionsOFFICIAL
Explore all skills by this author →
GitHub

google-sheets

Search Google Sheets spreadsheets and read data as text, CSV, or JSON.

625|105|Updated Aug 28, 2025
Search Tags:#data extraction#data analysis#spreadsheets#google sheets#drive search#sheets api
One-click install
npx skills add https://github.com/gemini-cli-extensions/workspace --skill google-sheets-gemini-cli-extensions
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: google-sheets
Source: https://github.com/gemini-cli-extensions/workspace/tree/main/skills/google-sheets
Command: npx skills add https://github.com/gemini-cli-extensions/workspace --skill google-sheets-gemini-cli-extensions

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill helps users find, read, and analyze data within their Google Sheets spreadsheets, streamlining data management and access.

Core Features & Use Cases

  • Find Spreadsheets: Locate spreadsheets using search queries, including full-text search.
  • Read Data: Extract content from entire spreadsheets or specific ranges in various formats (text, CSV, JSON).
  • Get Metadata: Retrieve spreadsheet structure (sheet names, dimensions) without loading data.
  • Use Case: Quickly find a specific budget spreadsheet, extract its data into a CSV for analysis, or get a list of all sheet names to understand its structure.

Quick Start

Find all Google Sheets spreadsheets containing the word 'Budget' and list their names.

Frequently Asked Questions about google-sheets

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

FAQPage Schema
How do I extract data from Google Sheets into CSV or JSON?▼

You can extract Google Sheets data into CSV or JSON by reading content from entire spreadsheets or specific ranges. This facilitates formatting spreadsheet data directly into text, CSV, or JSON outputs for analysis.

Can I search for Google Sheets spreadsheets by content or name?▼

Yes, you can search for Google Sheets spreadsheets by name or content using full-text search queries. This integrates with Google Drive file handling to help you locate specific spreadsheets quickly.

How do I get the sheet names and dimensions of a spreadsheet without loading the data?▼

You can retrieve spreadsheet metadata to get sheet names and dimensions without loading the actual data. This helps you understand the spreadsheet structure before extracting specific ranges for analysis.

Does this approach work with Google Drive URLs for spreadsheets?▼

Yes, this approach accepts Google Drive URLs directly to facilitate file handling. You can input a Drive URL to retrieve data, extract ranges, or fetch metadata for the specified Google Sheets spreadsheet.

What is the best way to find a specific budget spreadsheet in Google Drive?▼

The best way to find a specific budget spreadsheet is to use full-text search queries to locate Google Sheets by name or content. This streamlines data management by returning matching spreadsheets directly from your drive.

Related Skills

Explore More Data & Analytics Skills→
pmcdowallpmcdowall

google-drive

Access and update Google Drive files and spreadsheet records via authenticated APIs.

Community
Intermediate
HwFeeHwFee

data-analyst

Analyze CSV, Excel, JSON, and SQL datasets to generate visual insights and reports.

Community
Intermediate
NagyViktNagyVikt
2

google-sheets-chart-builder

Create and revise Google Sheets charts via structured API requests.

Community
Intermediate
googleworkspacegoogleworkspace
30.3k

recipe-backup-sheet-as-csv

Export Google Sheets spreadsheets or specific ranges as CSV files.

Official
Basic