skills.rest
tankpkg
tankpkgOFFICIAL
Explore all skills by this author →
GitHub

@tank/google-sheets

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
One-click install
npx skills add https://github.com/tankpkg/skills --skill tank-google-sheets
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
vm0-aivm0-ai
76

google-sheets

Read, write, and manage Google Sheets data via curl.

Official
Advanced
I-OnlabsI-Onlabs
3

dashboard-creator

Generate self-contained HTML dashboards with KPI cards and inline SVG charts.

Community
Intermediate
Mohamed-ElkahefMohamed-Elkahef

csv-data-visualizer

Generate interactive Plotly visualizations and statistical profiles from CSV datasets.

Community
Intermediate
heximaoheximao

lark-sheets

Manage Lark spreadsheets with sheet, cell, style, image, and filter operations.

Community
Advanced