@tank/google-sheets

Name: @tank/google-sheets
Availability: InStock
Author: tankpkg

Read, write, format, and analyze Google Sheets data via the API.

1|1|Updated Feb 20, 2026

Search Tags:#automation #api #reporting #spreadsheet #data manipulation #google sheets

Ready to run

npx skills add https://github.com/tankpkg/skills --skill tank-google-sheets

💬 Prompt for ChatGPT / Claude Chat▼

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill empowers AI agents to interact with Google Sheets, automating tasks like data entry, analysis, and visualization, thereby reducing manual spreadsheet management overhead.

Core Features & Use Cases

Data Manipulation: Read, write, and update cell data, including batch operations.
Formatting & Styling: Apply conditional formatting, data validation, and cell styling.
Advanced Features: Create charts, manage named ranges, and manipulate sheets.
Use Case: An agent can use this skill to automatically update a sales report in Google Sheets with new data appended from a CSV file, then apply conditional formatting to highlight top-performing regions.

Quick Start

Use the google-sheets skill to read the range 'Sheet1!A1:B10' from the spreadsheet with ID '12345'.

Frequently Asked Questions about @tank/google-sheets

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

FAQPage Schema

How do I automate reading and writing Google Sheets data via API?▼

Automating Google Sheets data via API involves using OAuth 2.0 authentication to enable programmatic reading, writing, and batch updating of cell ranges, allowing agents to manipulate spreadsheet data without manual entry.

Can I apply conditional formatting and data validation to a spreadsheet programmatically?▼

Yes, conditional formatting and data validation can be applied programmatically. This functionality allows agents to automatically style cells and enforce data rules within Google Sheets, highlighting specific data patterns like top-performing regions.

Does the Google Sheets API support creating charts and managing named ranges?▼

The Google Sheets API supports creating charts and managing named ranges. These advanced features allow programmatic visualization of spreadsheet data and structured cell referencing for automated reporting workflows.

What do I need to set up before using a Google Sheets API automation skill?▼

Before using a Google Sheets API automation skill, you need Google OAuth 2.0 authentication configured with appropriate scopes to grant programmatic access for reading, writing, and managing spreadsheet data securely.

How do I append new data from a CSV file into an existing Google Sheets report?▼

Appending CSV data into a Google Sheets report involves reading the external file and using batch update operations via the API to write new rows, after which you can apply conditional formatting to highlight specific metrics.