Do I need an MCP server to use this skill?

No, this skill is designed as a lightweight integration that uses standalone Python scripts and OAuth, specifically eliminating the need for an MCP server setup.

Does this skill support personal Gmail accounts?

No, this skill currently requires a Google Workspace account. Personal Gmail accounts are not supported for this specific integration.

What data formats can I export from my sheets?

You can retrieve data in three formats: human-readable plain text with pipe separators, standard CSV for data processing, or structured JSON for programmatic use.

How are authentication tokens handled?

Tokens are stored securely using your operating system's native keyring, such as macOS Keychain, Windows Credential Locker, or the Linux Secret Service API.

Can I use the skill to write formulas to cells?

Yes, by default the skill uses the USER_ENTERED mode which parses formulas. You can also use the --raw flag to treat input as literal text.

Google Sheets Automation

Name: Google Sheets Automation
Author: lingxling

bylingxling

•

Productivity & Workflow

Automates Google Sheets operations including reading, writing, and formatting data without the need for an MCP server.

This skill provides a lightweight, standalone integration for Claude Code to interact directly with Google Sheets. By utilizing standalone OAuth authentication and Python-based scripts, it enables full read and write access, allowing users to fetch data in text, CSV, or JSON formats, update cell ranges, and manage spreadsheet metadata. It is an ideal tool for developers and data analysts who need to automate spreadsheet workflows, sync data between code and sheets, or generate reports directly from the terminal without setting up complex server infrastructures. Secure token management via the system keyring ensures that credentials remain protected across macOS, Windows, and Linux environments.

Key Features

01Automatic spreadsheet ID extraction from Google Sheets URLs

02Supports multiple output formats including human-readable text, CSV, and JSON

03Full read/write access for cell ranges, rows, and spreadsheet metadata

04Standalone OAuth authentication with secure system keyring storage

05Advanced write capabilities including formula parsing and batch updates

0652 GitHub stars

Use Cases

01Automated data entry and report generation from terminal-based workflows

02Fetching live spreadsheet data for use in development or analysis scripts

03Batch updating spreadsheet formatting and cell values via CLI

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lingxling/awesome-skills-cn google-sheets-automation

For use in Claude.ai and ChatGPT

Key Features

01Automatic spreadsheet ID extraction from Google Sheets URLs

02Supports multiple output formats including human-readable text, CSV, and JSON

03Full read/write access for cell ranges, rows, and spreadsheet metadata

04Standalone OAuth authentication with secure system keyring storage

05Advanced write capabilities including formula parsing and batch updates

0652 GitHub stars

Use Cases

01Automated data entry and report generation from terminal-based workflows

02Fetching live spreadsheet data for use in development or analysis scripts

03Batch updating spreadsheet formatting and cell values via CLI

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lingxling/awesome-skills-cn google-sheets-automation

For use in Claude.ai and ChatGPT