Does this skill support cell styling and formatting?

Absolutely. You can modify background colors, apply various border styles, and change text properties like bolding, italics, font size, and color.

Can I export my spreadsheet data to other formats?

Yes, the skill supports exporting specific cell ranges directly to JSON and CSV formats using the --format flag, which is useful for data processing.

How do I authenticate this skill with Google Sheets?

The skill uses Google Cloud Application Default Credentials (ADC). You must have the gcloud CLI installed and run 'gcloud auth application-default login' to authorize access to your spreadsheets.

Can I generate pivot tables automatically?

Yes, the skill includes a dedicated pivot command that allows you to define source ranges, target cells, and grouping functions such as SUM, COUNT, and AVERAGE.

Google Sheets Automation

Name: Google Sheets Automation
Author: treenod-IDQ

bytreenod-IDQ

•

生産性とワークフロー

Automates Google Sheets operations including data reading, cell formatting, and pivot table creation via the Google Sheets API.

This skill provides a comprehensive interface for Claude to interact with Google Sheets spreadsheets directly, bridging the gap between LLM reasoning and structured data management. It enables seamless data workflows by allowing users to read, update, and append cell values using A1 notation, while also offering advanced formatting capabilities like background colors, borders, and text styling. Beyond basic CRUD operations, it supports complex tasks such as generating pivot tables and exporting spreadsheet data into JSON or CSV formats, making it an essential tool for automated reporting, data entry, and workflow integration within the Claude environment.

主な機能

01Automated pivot table creation with customizable rows, columns, and aggregate functions

02Robust authentication support using Google Cloud Application Default Credentials (ADC)

03Multi-format data export to JSON and CSV for external tool integration

04Full CRUD support (Read, Update, Append, Clear) for spreadsheet data

05Rich cell formatting including background colors, borders, and typography

061 GitHub stars

ユースケース

01Bulk updating inventory or price lists from local JSON/CSV data sources within a dev environment

02Extracting spreadsheet data to feed into data science pipelines or AI-driven analysis

03Automating weekly performance reports by pulling raw data and applying professional formatting

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add treenod-idq/treenod-market sheet

For use in Claude.ai and ChatGPT

Download Skill