skills.rest
sanjay3290
sanjay3290COMMUNITY
Explore all skills by this author →
GitHub

google-sheets

Read, write, and manage Google Sheets data via OAuth-authenticated scripts.

392|41|Updated Dec 22, 2025
Search Tags:#automation#data management#api integration#spreadsheet#data manipulation#google sheets
One-click install
npx skills add https://github.com/sanjay3290/ai-skills --skill google-sheets-sanjay3290
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: google-sheets
Source: https://github.com/sanjay3290/ai-skills/tree/main/skills/google-sheets
Command: npx skills add https://github.com/sanjay3290/ai-skills --skill google-sheets-sanjay3290

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the process of interacting with Google Sheets, allowing you to read, write, and manage spreadsheet data programmatically without manual intervention.

Core Features & Use Cases

  • Read Data: Fetch spreadsheet content as text, CSV, or JSON.
  • Update & Append: Modify existing cells or add new rows to spreadsheets.
  • Search & Metadata: Find spreadsheets by name and retrieve sheet information.
  • Use Case: Automatically update a sales report spreadsheet with new data fetched from another source, or extract specific financial data for analysis.

Quick Start

Authenticate with Google by running python scripts/auth.py login in your terminal.

Frequently Asked Questions about google-sheets

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

FAQPage Schema
How do I automate reading and writing Google Sheets data programmatically?▼

Automating Google Sheets data management involves using API integration to programmatically read, write, and manipulate spreadsheet content. This Skill fetches data as text, CSV, or JSON, updates cell ranges, and appends new rows without manual intervention.

What formats can I export Google Sheets data into using API integration?▼

Using API integration, you can fetch and export Google Sheets spreadsheet content into text, CSV, or JSON formats. This enables flexible data manipulation and seamless integration with downstream data management pipelines.

Do I need OAuth authentication to manage Google Sheets spreadsheets?▼

Yes, OAuth authentication is required to manage Google Sheets programmatically. You must authenticate with Google by running the provided login script in your terminal before performing any data manipulation or API integration operations.

Can I search for specific spreadsheets and retrieve sheet metadata?▼

Yes, you can search for spreadsheets by name and retrieve associated sheet metadata. This data management capability helps locate target files before executing operations like reading content or updating specific cell ranges.

What is the best way to append new rows to a spreadsheet from another data source?▼

The best way to append new rows to a spreadsheet from an external data source is using API integration capabilities. This programmatically automates data management by fetching external content and directly appending it as new rows to your Google Sheets.

Does this Google Sheets API integration require any specific dependencies?▼

Yes, this Google Sheets API integration requires the keyring dependency to manage credentials securely. It operates using standalone scripts for integration, requiring OAuth authentication to successfully connect and manipulate spreadsheet data.

Related Skills

Explore More Data & Analytics Skills→
PinpongTpPinpongTp

google-sheets

Read and write Google Sheets data with OAuth authentication.

Community
Intermediate
semantica-agisemantica-agi
3.0k

export

Export knowledge graph data and provenance to JSON, RDF, Parquet, CSV, and GraphML.

Official
Intermediate
leolionartleolionart
1

google-sheets

Read, write, and manage Google Sheets via the gws CLI.

Community
Intermediate
hashSTACS-GlobalhashSTACS-Global
33

feishu-sheet

Automate Feishu spreadsheet read, write, append, find, create, and export operations.

Official
Advanced