skills.rest
peteanderson80
peteanderson80COMMUNITY
Explore all skills by this author →
Website𝕏@panderson_meGitHub

google-sheets

Read, write, and format Google Sheets ranges via the Codexclaw wrapper script.

Updated Mar 22, 2026
Search Tags:#automation#metadata#spreadsheet#google-sheets#google-workspace#data-management#wrapper-cli
One-click install
npx skills add https://github.com/peteanderson80/skills --skill google-sheets-peteanderson80
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: google-sheets
Source: https://github.com/peteanderson80/skills/tree/main/skills/google-sheets
Command: npx skills add https://github.com/peteanderson80/skills --skill google-sheets-peteanderson80

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manual Google Sheets operations (reading, writing, formatting, and creating spreadsheets) are repetitive and error-prone; Codexclaw's wrapped Google Workspace CLI enables automation within defined boundaries to reduce toil.

Core Features & Use Cases

  • Read and modify sheet values
  • Create spreadsheets and inspect metadata
  • Format ranges and automate common workflows
  • Use Case: automatically populate templates or generate reports from data across multiple sheets

Quick Start

Invoke the wrapper script with read_sheet_values and the required parameters to read data from a sheet.

Frequently Asked Questions about 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?▼

Automate Google Sheets data management by invoking a wrapped CLI to read, write, and format spreadsheet ranges. This approach reduces manual toil and handles repetitive spreadsheet operations within defined boundaries.

Can I create spreadsheets and inspect metadata automatically?▼

Yes, you can create spreadsheets and inspect metadata automatically using the Google Workspace wrapper CLI. It executes these operations while enforcing environment variable boundary checks for secure automation.

What is the best way to populate spreadsheet templates from multiple sheets?▼

The best way to populate templates or generate reports from multiple sheets is using a wrapper-based CLI. It automates range reads and writes, applying formatting to streamline data workflows.

Do I need environment variables to automate Google Sheets tasks?▼

Yes, environment variables are required to enforce boundary checks when automating Google Sheets tasks. The wrapper script relies on them to maintain secure execution within the Google Workspace boundary.

Why use a wrapper CLI instead of manual spreadsheet operations?▼

Use a wrapper CLI instead of manual operations because manual spreadsheet reading, writing, and formatting are repetitive and error-prone. The CLI automates these workflows to significantly reduce toil.

Related Skills

Explore More Data & Analytics Skills→
jusjinukjusjinuk
1

onboard

Configure Slack tokens, environment files, and repository hooks for internbot deployment.

Community
Intermediate
wuyyyyyouwuyyyyyou

recipe-backup-sheet-as-csv

Export a Google Sheets spreadsheet to a CSV file for local backup.

Community
Intermediate
sobhanashinesobhanashine
1

retro

Generate engineering retrospectives from commit history and project data.

Community
Intermediate
novskidevnovskidev
2

template-skill

Executes predefined tasks for automating routine operations and varied inputs.

Community
Basic