skills.rest
terraleiloa
terraleiloaCOMMUNITY
Explore all skills by this author →
GitHub

sheets

Read and write Google Sheets data using OAuth-authenticated connector operations.

2|Updated Feb 25, 2026
Search Tags:#oauth#spreadsheet automation#batch operations#google sheets#read range#write range#cell updates
One-click install
npx skills add https://github.com/terraleiloa/seren-skills --skill sheets-terraleiloa
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sheets
Source: https://github.com/terraleiloa/seren-skills/tree/main/google/sheets
Command: npx skills add https://github.com/terraleiloa/seren-skills --skill sheets-terraleiloa

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill removes the hassle of manually copying data into spreadsheets by letting you programmatically read, update, and format Google Sheets as part of AI-assisted workflows.

Core Features & Use Cases

  • Read Google Sheets ranges: Fetch cell values from a specified range for analysis or downstream steps.
  • Write and update cell ranges: Push new values into existing spreadsheets, including batch-style updates.
  • Create spreadsheets and manage worksheets: Create new spreadsheets and work with worksheet structure, plus apply formatting.
  • Formula operations: Set up or update cells that rely on formulas to keep results consistent.

Quick Start

Ask the AI to read the values in range A1:D10 from the spreadsheet ID you provide and return the extracted data for your next step.

Frequently Asked Questions about sheets

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

FAQPage Schema
How do I read a range of cells from Google Sheets automatically?▼

To read a range of cells from Google Sheets, the Skill fetches specified cell values using connector-based operations like sheets.get. You provide the spreadsheet ID and target range to extract data for downstream analysis or reporting steps.

Can I write and update Google Sheets cell values in batch?▼

Yes, you can write and update Google Sheets cell values in batch. The Skill supports pushing new values into existing spreadsheets and performing batch-style updates across worksheets to automate data reporting workflows.

Do I need OAuth authentication to automate Google Sheets workflows?▼

Yes, OAuth authentication is required to automate Google Sheets workflows. The Skill relies on OAuth to securely authorize connector-based operations, ensuring reliable read and write access for fetching ranges and updating cell values.

What is the best way to create a new spreadsheet and apply formatting?▼

The best way to create a new spreadsheet and apply formatting is through automated worksheet management. The Skill creates new spreadsheets, structures worksheets, and applies formatting programmatically to support consistent reporting.

How do I update cells with formulas in Google Sheets programmatically?▼

To update cells with formulas in Google Sheets programmatically, the Skill applies formula operations to target ranges. This ensures cells relying on formulas remain consistent when pushing new values or performing batch updates.

Related Skills

Explore More Data & Analytics Skills→
UniquecreteUniquecrete

gog

Manage Google Workspace content via a command-line interface for Gmail, Calendar, Drive, Contacts, Sheets, and Docs.

Community
Basic
pacphipacphi
6

performance-analysis

Detect performance bottlenecks in Claude Flow swarm operations.

Community
Advanced
niclasmartinsson-sysniclasmartinsson-sys
8

gws-sheets-append

Append single or multiple rows to Google Sheets via gws CLI.

Community
Intermediate
tankpkgtankpkg
1

@tank/google-sheets

Read, write, format, and analyze Google Sheets data via the API.

Official
Advanced