skills.rest
plosson
plossonCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

agentio-gsheets

Read, write, format, and export Google Sheets via the agentio CLI.

2|Updated Jan 3, 2026
Search Tags:#ci/cd#cli#Google Sheets#spreadsheet automation#export#append rows#agentio
One-click install
npx skills add https://github.com/plosson/agentio --skill agentio-gsheets-plosson
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: agentio-gsheets
Source: https://github.com/plosson/agentio/tree/main/claude/skills/agentio-gsheets
Command: npx skills add https://github.com/plosson/agentio --skill agentio-gsheets-plosson

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Automating Google Sheets operations from scripts, CI pipelines, or LLM agents normally requires writing API client code and managing OAuth flows. This Skill exposes every common spreadsheet operation as a plain agentio CLI command that agents can invoke directly. ## Core Features & Use Cases - Read and Write Data: List spreadsheets, get ranges, update cells, append rows, and clear ranges with simple commands like agentio gsheets get <id> "Sheet1!A1:C2". - Formatting and Structure: Apply bold, colors, number formats, borders, merges, and column resizing, plus a raw batch escape hatch for any Sheets API request. - Workbook Management: Create, copy, inspect metadata, and export spreadsheets to xlsx, pdf, csv, ods, or tsv. - Use Case: A scheduled GitHub Actions workflow reads metrics from a sheet, appends a new daily summary row, formats the header, and exports a PDF report — all without writing any API code. ## Quick Start Use the agentio gsheets skill to read the range Sheet1!A1:D10 from my spreadsheet and append a new row with today's summary values.

Frequently Asked Questions about agentio-gsheets

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

FAQPage Schema
How do I read values from a Google Sheet using the command line?▼

Run `agentio gsheets get <spreadsheet-id-or-url> "Sheet1!A1:C2"` to read any range. Use --render FORMULA to see formulas instead of computed values, or --dimension COLUMNS to transpose the orientation.

How to append rows to a Google Sheet from a script?▼

Use `agentio gsheets append <id> "Sheet1!A:C" "alice|10|us,bob|7|fr"` where commas separate rows and pipes separate cells. Add --insert INSERT_ROWS to shift existing rows down instead of overwriting blanks.

Can I export a Google Sheet to CSV or PDF from the CLI?▼

Yes, `agentio gsheets export <id> --output report.pdf --format pdf` exports to xlsx, pdf, csv, ods, or tsv. Note that csv and tsv formats export only the first sheet.

Does agentio gsheets support formatting cells like colors and number formats?▼

Yes, the format command supports bold, italic, text and background colors, alignment, wrapping, number format patterns, borders, and cell merging. Use --clear-format to reset existing formatting first.

What if the built-in gsheets commands cannot do what I need?▼

Use `agentio gsheets batch` as an escape hatch to execute raw spreadsheets.batchUpdate requests from inline JSON or a file. It accepts any Sheets API Request object, such as freezing rows or updating sheet properties.

Related Skills

Explore More Data & Analytics Skills→
nsheapsnsheaps
3

op

Manage and retrieve 1Password secrets via the op CLI.

Community
Intermediate
breakcafebreakcafe
1

customize

Add channels, change triggers, and integrate MCP tools into NanoClaw.

Official
Advanced
vm0-aivm0-ai
76

rss-fetch

Fetches RSS/Atom feeds and converts them to JSON with curl and xmllint or jq.

Official
Basic
rnbenrnben

google-workspace

Integrate Gmail, Calendar, Drive, Contacts, Sheets, and Docs with Hermes via OAuth.

Community
Intermediate