skills.rest
Open-Curiosity
Open-CuriosityOFFICIAL
Explore all skills by this author →
WebsiteGitHub

google-sheets

Manage Google Sheets v4 data via the gws CLI with read/write, append, and batch updates.

1.7k|523|Updated May 5, 2026
Search Tags:#automation#data management#scripting#google sheets#batch update
One-click install
npx skills add https://github.com/Open-Curiosity/gini-agent --skill google-sheets-open-curiosity
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: google-sheets
Source: https://github.com/Open-Curiosity/gini-agent/tree/main/skills/google/google-sheets
Command: npx skills add https://github.com/Open-Curiosity/gini-agent --skill google-sheets-open-curiosity

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires gws, and includes scripts (resource) components.

What problem does it solve?

This Skill simplifies data management tasks in Google Sheets, enabling quick access, editing, and batch updates to spreadsheet data.

Core Features & Use Cases

  • Read and Write Cells: Access and modify specific cell values or ranges in Google Sheets.
  • Append Rows: Add new rows to a Google Sheet efficiently.
  • Batch Updates: Perform structured batch edits for advanced operations.
  • Use Case: For example, automate the updating of sales figures across multiple sheets or append a new set of project tasks to a project management sheet.

Quick Start

Use the gws sheets +append command to add a new row to the Google Sheet with ID '12345' and the following values: 'Project A', '2023-10-01', 'In progress'.

Frequently Asked Questions about google-sheets

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

FAQPage Schema
How do I automate batch updates to Google Sheets data?▼

You can automate batch updates in Google Sheets by using a command-line interface to perform structured batch edits, enabling efficient modification of spreadsheet data for sales or project workflows.

What's the best way to append rows to a Google Sheet via command line?▼

Appending rows to a Google Sheet is done by executing the append command with your specific sheet ID and values, which adds new data rows efficiently without manual entry.

Do I need Google Workspace credentials to read and write Google Sheets cells?▼

Yes, reading and writing Google Sheets cells requires authenticated Google Workspace credentials configured with the correct API scopes to manage data operations securely.

Can I use this for automating data management tasks in finance workflows?▼

Yes, this approach is ideal for automating data management tasks in finance workflows, allowing you to quickly access, edit, and batch update spreadsheet data.

How does the Google Sheets API v4 handle structured batch edits?▼

The Google Sheets API v4 handles structured batch edits through a command-line interface that executes structured batch operations, allowing advanced simultaneous modifications across spreadsheet ranges.

What are the limitations of using a CLI for Google Sheets data operations?▼

Using a CLI for Google Sheets data operations requires prerequisite configuration of Google Workspace credentials and authenticated scopes, making it dependent on proper environment setup rather than direct browser interaction.

Related Skills

Explore More Data & Analytics Skills→
m13vm13v
312

recipe-backup-sheet-as-csv

Export a Google Sheets spreadsheet into a CSV file format.

Community
Basic
Ryko1141Ryko1141

reporting-automation

Automate analytics report generation and distribution through n8n workflows.

Community
Advanced
traygerbigtraygerbig
1

jooto-agent

Manage tasks, boards, and recurring tasks in Jooto via the PR TIMES API.

Community
Advanced
Gull-StackGull-Stack

referral-program

Design and optimize referral and affiliate programs with incentive strategies.

Official
Intermediate