google-sheets

Name: google-sheets
Availability: InStock
Author: arlenagreer

Automate Google Sheets operations including reading, writing, appending, and formatting cells.

Updated Aug 23, 2026

Search Tags:#formulas #spreadsheet #data-analysis #google-sheets #batch-operations #spreadsheet-automation

Ready to run

npx skills add https://github.com/arlenagreer/claude_configuration_docs --skill google-sheets

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: google-sheets
Source: https://github.com/arlenagreer/claude_configuration_docs/tree/main/skills/google-sheets
Command: npx skills add https://github.com/arlenagreer/claude_configuration_docs --skill google-sheets

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires google-apis-sheets_v4, google-apis-drive_v3, google-apis-docs_v1, google-apis-calendar_v3, google-apis-people_v1, googleauth, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill eliminates manual spreadsheet operations by providing programmatic control over Google Sheets, enabling efficient data management and analysis.

Core Features & Use Cases

Comprehensive Operations: Read/write cell values, append rows, apply formatting, create sheets, and perform batch updates.
Data Analysis Workflows: Read ranges, write formulas, clear data, and manage multiple sheets within spreadsheets.
Use Case: Imagine you need to update monthly sales data across multiple regions. Use this Skill to automatically read existing data, calculate new metrics, and update multiple ranges in a single operation.

Quick Start

Use the google-sheets skill to read the sales data from cells A1 to D10 in your budget spreadsheet.

Integration & Authentication

Shared OAuth: Uses same token as email, calendar, contacts, drive, and docs skills for seamless Google Workspace integration.

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 data in Google Sheets?▼

Automate spreadsheet operations by reading cell values and ranges using A1 notation, writing updates including formulas, and appending rows. This Skill handles 2D input arrays and batch updates across multiple sheets, eliminating manual data entry while maintaining consistent output with status, range, and updated_cells metadata.

Can I use formulas when updating cells programmatically?▼

Yes, formulas are supported through the input_option parameter: use USER_ENTERED to write formulas that calculate on submission, or RAW to write literal formula text. This enables automated metric calculations and dynamic updates across your spreadsheet without manual formula entry.

What formatting operations can I perform on Google Sheets?▼

Apply formatting, create sheets, and perform batch updates across multiple ranges in a single operation. The Skill supports cell-level formatting changes alongside data operations, letting you standardize appearance and structure as part of automated workflows.

Does this work with Google Drive and other Google Workspace apps?▼

Yes, the Skill uses shared OAuth authentication with Google Drive, Docs, Calendar, and Contacts, enabling seamless integration across your Google Workspace. This means one token handles authentication for coordinated workflows across multiple Google services.

Can I clear data and manage multiple sheets in one operation?▼

Clear ranges and manage multiple sheets through batch operations, letting you restructure spreadsheets programmatically. Combine clearing, writing, and formatting tasks across different sheets to automate complex data workflows in a single call.

What input format do I need for updating multiple cell ranges?▼

Use 2D input arrays with A1 notation ranges to specify target cells. This structured format enables batch updates across multiple ranges simultaneously, with consistent output that includes status, affected range, and updated cell count for tracking changes.