skills.rest
hongmaple0820
hongmaple0820COMMUNITY
Explore all skills by this author →
WebsiteGitHub

google-sheets

Read Google Sheets data via API with OAuth authentication.

9|2|Updated Mar 12, 2026
Search Tags:#api#oauth#metadata#csv#read#google-sheets#ranges
One-click install
npx skills add https://github.com/hongmaple0820/agent-academy --skill google-sheets-hongmaple0820
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: google-sheets
Source: https://github.com/hongmaple0820/agent-academy/tree/main/skills/integrations/google-sheets
Command: npx skills add https://github.com/hongmaple0820/agent-academy --skill google-sheets-hongmaple0820

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires keyring, and includes scripts (resource) components.

What problem does it solve?

Google Sheets data is often scattered and hard to access programmatically without a server-side component. This Skill provides a lightweight, OAuth-authenticated way to read sheet contents, fetch ranges, search spreadsheets, and retrieve metadata without needing a full MCP server.

Core Features & Use Cases

  • Read full sheet contents in text, CSV, or JSON.
  • Fetch specific ranges using A1 notation.
  • Find spreadsheets by name or query and retrieve metadata like sheet titles and dimensions.
  • Use Case: integrate sheet data into analytics pipelines or assistant workflows without exposing credentials.

Quick Start

Authenticate with Google using the included flow and run a sample command to fetch data from a given spreadsheet.

Frequently Asked Questions about google-sheets

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

FAQPage Schema
How do I read Google Sheets data via API with OAuth authentication?▼

You can read Google Sheets data via API by running a standalone OAuth authentication flow to obtain tokens, then making API requests to extract spreadsheet contents in text, CSV, or JSON formats.

Can I fetch specific ranges from a Google Sheet using A1 notation?▼

Yes, you can fetch specific ranges using A1 notation. The Skill supports retrieving targeted cell ranges from Google Sheets spreadsheets, alongside reading full sheet contents and extracting sheet metadata.

Do I need a full MCP server to extract Google Sheets data into CSV or JSON?▼

No, you do not need a full MCP server. This script-based approach provides a lightweight, OAuth-authenticated way to read sheet contents and return outputs in CSV or JSON without requiring server-side components.

How do I search for a Google Sheets spreadsheet by name and retrieve its metadata?▼

You can search for spreadsheets by name or query using the Google Sheets API. The Skill retrieves metadata like sheet titles and dimensions across multiple sheets within the matched spreadsheet file.

What are the limitations of using keyring for OAuth token management in Google Sheets API calls?▼

The Skill relies on keyring for credential storage and handles OAuth token refreshing automatically. A known limitation is that token refresh failures may occur if environment permissions for keyring access are restricted.

Related Skills

Explore More Data & Analytics Skills→
73ai73ai
4

gws-sheets

Read and write Google Sheets data via the Sheets API.

Official
Advanced
temple-slopetemple-slope

recipe-backup-sheet-as-csv

Convert Google Sheets spreadsheets to CSV for backup or downstream processing.

Community
Intermediate
temple-slopetemple-slope

gws-sheets-read

Read values from a specified Google Sheets range for data workflows.

Community
Basic
zapierzapier
114

google-sheets

Automate read, write, and manage operations in Google Sheets via API v4.

Official
Intermediate