skills.rest
huynguyenh
huynguyenhCOMMUNITY
Explore all skills by this author →
GitHub

hnh-gg-sheets

Create, read, write, format, and share Google Sheets via APIs.

3|Updated Mar 9, 2026
Search Tags:#automation#api#gcp#data management#spreadsheet#google sheets
One-click install
npx skills add https://github.com/huynguyenh/skills --skill hnh-gg-sheets
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: hnh-gg-sheets
Source: https://github.com/huynguyenh/skills/tree/main/skills/hnh-gg-sheets
Command: npx skills add https://github.com/huynguyenh/skills --skill hnh-gg-sheets

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill streamlines the process of interacting with Google Sheets, allowing users to create, read, update, format, and share spreadsheets programmatically without needing to manually open the Google Sheets interface.

Core Features & Use Cases

  • Create Spreadsheets: Generate new Google Sheets with specified titles and headers.
  • Read/Write Data: Extract data from specific ranges or append new rows to existing sheets.
  • Format Cells: Apply various styling options like bolding, background colors, and alignment.
  • Search & Share: Find existing spreadsheets by name and manage access permissions.
  • Use Case: Automatically create a new ZenLabs project tracker spreadsheet, populate it with initial task headers, and share it with the project team.

Quick Start

Use the hnh-gg-sheets skill to create a new Google Sheet named "My Project Tracker" with headers "Task,Owner,Status".

Frequently Asked Questions about hnh-gg-sheets

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

FAQPage Schema
How do I automate Google Sheets data management without manual interface interaction?▼

Yes, you can format Google Sheets cells programmatically. The API supports applying styling options like bolding text, setting background colors, and adjusting alignment directly through scripts.

Do I need gcloud CLI to read and write Google Sheets via API?▼

Yes, reading and writing Google Sheets via API requires the gcloud CLI with Application Default Credentials (ADC) configured, along with specific Python packages, to authenticate and access the APIs.

Can I search for an existing spreadsheet and manage sharing permissions programmatically?▼

Yes, you can search for existing spreadsheets by name and manage sharing permissions programmatically. The API interaction allows you to find documents and configure access for collaborative teams.

How do I create a new Google Sheet and append rows to existing spreadsheets?▼

Create new Google Sheets with specified titles and headers, or append new rows to existing sheets, by interacting with the Google Sheets API. This supports automated data population and project tracker generation.

What are the limitations of using Google Sheets API for automated document workflows?▼

Limitations of automated Google Sheets workflows include strict dependencies on gcloud CLI ADC authentication and specific Python packages. You must configure these environment prerequisites before executing any programmatic document management.

Related Skills

Explore More Software Engineering Skills→
LaurentPRAT-DBLaurentPRAT-DB

google-auth

Manage unified authentication for Google Workspace APIs using gcloud CLI and Application Default Credentials.

Community
Intermediate
iOfficeAIiOfficeAI
31.8k

xlsx

Create, edit, and analyze Excel spreadsheets with pandas and openpyxl.

Official
Advanced
m13vm13v
312

recipe-create-expense-tracker

Create and configure a Google Sheets expense tracker with headers and sample data.

Community
Basic
cellarwoodcellarwood

gws-sheets-read

Read cell values from Google Sheets via the gws CLI.

Official
Basic