sheet

Read, update, and format Google Sheets data via Python CLI.

Updated Aug 27, 2026
Ready to run
npx skills add https://github.com/treenod-IDQ/treenod-market --skill sheet
💬 Prompt for ChatGPT / Claude Chat▼
Please help me install this Agent Skill.
Skill: sheet
Source: https://github.com/treenod-IDQ/treenod-market/tree/main/plugins/util/skills/sheet
Command: npx skills add https://github.com/treenod-IDQ/treenod-market --skill sheet

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires google-auth, google-api-python-client, and includes scripts (resource) components.

What problem does it solve?

Google Sheets is often manipulated manually, leading to slow workflows and data inconsistencies. This skill provides programmatic access to read data, update values, and apply formatting and analysis across spreadsheets using a Python CLI and the sheet_api.py suite.

Core Features & Use Cases

  • Read spreadsheet metadata and range values across single or multiple sheets.
  • Update ranges, append rows, and clear data programmatically with consistent formatting.
  • Apply formatting (background color, borders, text) and create pivot tables for reporting.

Quick Start

Install dependencies and run the sheet_api.py CLI to manage a spreadsheet.

Frequently Asked Questions about sheet

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

FAQPage Schema
How do I read and update Google Sheets data using Python?▼

You can read and update Google Sheets data using Python scripts via the sheet_api.py CLI, which supports range operations, appending rows, and clearing data programmatically through the Google Sheets API.

Can I create pivot tables in Google Sheets via API?▼

Yes, you can create pivot tables in Google Sheets via API. The skill supports pivot table creation and applies formatting like background colors and borders through batch update requests.

What authentication is needed to automate Google Sheets workflows?▼

Automating Google Sheets workflows requires ADC-based authentication. You must configure Application Default Credentials to authorize the Python scripts to access and manipulate your spreadsheet data.

How do I parse a spreadsheet URL to get the ID for API requests?▼

The skill includes URL parsing functionality to automatically extract spreadsheet IDs from links. This allows the Python CLI to target the correct document for reading, updating, and formatting operations.

What is the best way to batch update formatting across multiple ranges?▼

The best way to batch update formatting is using the sheet_api.py suite, which translates range definitions and applies formatting like borders and text styles across specified ranges in a single batch update request.

Does this approach work for automating data-entry and reporting tasks?▼

Yes, this approach works for data-entry and reporting tasks. The Python CLI applies consistent formatting and performs range operations, replacing manual spreadsheet manipulation to prevent data inconsistencies.