Does this skill support Google Sheets formulas?

Yes, by using the 'USER_ENTERED' input option, you can write formulas such as =SUM(A1:A10) directly into cells, and Google Sheets will parse them automatically.

Can I update multiple cell ranges at once?

Yes, the batch_update functionality allows you to perform multiple range updates in a single efficient API call, which is faster and ensures atomic operations.

Is cell formatting supported via Claude Code?

Yes, you can programmatically apply formatting such as bold text, italics, specific font sizes, and RGB background colors to defined cell ranges.

How do I search for a specific spreadsheet with this skill?

You can use the integrated google-drive skill to search for spreadsheet files by name or MIME type to retrieve the necessary spreadsheet ID required for this skill's operations.

How is authentication handled for Google Sheets?

This skill uses a shared OAuth token located in your local Claude configuration directory, which also powers Gmail, Drive, Docs, and Calendar integrations.

Google Sheets Management

Name: Google Sheets Management
Author: arlenagreer

byarlenagreer

0•

生産性とワークフロー

Automates Google Sheets operations including reading, writing, formatting, and batch updates directly within the Claude Code environment.

This skill provides a comprehensive interface for managing Google Sheets, enabling users to programmatically interact with spreadsheets through the Claude Code framework. It supports a wide range of operations from simple cell reading and writing to complex batch updates, cell formatting, and sheet structure management. By sharing OAuth credentials with other Google Workspace skills, it facilitates seamless cross-app workflows such as extracting data from emails and logging it into sheets or generating detailed reports based on Google Drive contents. It is an essential tool for developers and data analysts who need to automate data entry, reporting, and spreadsheet maintenance without leaving their command-line interface.

主な機能

01Granular cell formatting including bolding, font sizes, and background colors

02Full read/write access to cell values and complex A1 notation formulas

03Unified OAuth authentication shared with Drive, Gmail, and Docs skills

04Efficient batch operations for updating multiple ranges in a single API call

050 GitHub stars

06Comprehensive sheet management including creation, metadata retrieval, and row appending

ユースケース

01Building data logging systems that append rows for tracking and monitoring tasks

02Automating financial reports by aggregating data and applying complex formulas

03Programmatically migrating or synchronizing data between spreadsheets and external databases

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add arlenagreer/claude_configuration_docs google-sheets

For use in Claude.ai and ChatGPT

Download Skill