fetch-google-sheets-materials

Extract values, ranges, and metadata from Google Sheets via read-only connectors.

Updated May 18, 2026
One-click install
npx skills add https://github.com/dodonki1223/vault --skill fetch-google-sheets-materials-dodonki1223
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: fetch-google-sheets-materials
Source: https://github.com/dodonki1223/vault/tree/main/.agents/skills/fetch-google-sheets-materials
Command: npx skills add https://github.com/dodonki1223/vault --skill fetch-google-sheets-materials-dodonki1223

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Gathering specific data from Google Sheets often means opening spreadsheets manually, copying values, and losing track of source ranges and update times. This Skill retrieves only the requested spreadsheet, sheet, range, or filtered data through structured read-only connectors, returning compact, source-attributed results. ## Core Features & Use Cases - Targeted Range Retrieval: Reads specific spreadsheets, sheets, ranges, named ranges, and filtered rows using Google Sheets / Drive connectors, MCP, or APIs instead of browser screenshots. - Authentication and Permission Diagnostics: Distinguishes between missing tools, expired OAuth, insufficient sharing permissions, and export restrictions, then tells the user exactly what to fix. - Structured Output: Returns results in a compact table with update timestamps, sheet/range references, and links, ready for downstream classification workflows. - Use Case: Ask for the latest status and deadline columns from a project tracking spreadsheet, and receive only the relevant rows with source links and retrieval constraints noted. ## Quick Start Use the fetch-google-sheets-materials skill to retrieve the status and deadline columns from the specified Google Sheets spreadsheet URL.

Frequently Asked Questions about fetch-google-sheets-materials

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

FAQPage Schema
How do I extract data from a specific Google Sheets range?▼

Provide the spreadsheet URL or file ID along with the sheet name and range, and the skill reads only that range through Google Sheets connectors or APIs. It first reads spreadsheet metadata to resolve sheet titles and grid sizes rather than guessing tab names.

What tools are needed to read Google Sheets programmatically?▼

A Google Sheets connector, plugin, MCP server, or API connection capable of spreadsheet metadata, sheet listing, and range or cell reads is required. A Drive-only tool can see file metadata but cannot reliably read cell values, especially when export is forbidden.

Why does Google Sheets export return 403 Forbidden?▼

A 403 on export usually means export permission is restricted by the file owner or Drive policy, not an OAuth failure. Ask the owner or admin to confirm export rights, or use a Google Sheets live read / values API connection with the same viewing permissions.

Can this skill write or edit Google Sheets cells?▼

No, the skill is strictly read-only. It does not edit cells, add rows or comments, change sharing settings, or modify filters and sorting, and it never handles OAuth tokens, API keys, or cookies.

What happens when Google Sheets data cannot be retrieved?▼

The skill returns a short structured failure report identifying the cause, such as missing tools, expired authentication, insufficient permissions, or unknown targets. It also states what the user must do next, like reconnecting the connector or sharing the spreadsheet.