skills.rest
dfpalhano
dfpalhanoCOMMUNITY
Explore all skills by this author →
GitHub

google-sheets

Manage Google Sheets data and formatting via the Sheets API with Node.js.

Updated Feb 26, 2026
Search Tags:#automation#api#data management#node.js#spreadsheet#google sheets
One-click install
npx skills add https://github.com/dfpalhano/openclaw-workspace --skill google-sheets-dfpalhano
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: google-sheets
Source: https://github.com/dfpalhano/openclaw-workspace/tree/main/skills/google-sheet
Command: npx skills add https://github.com/dfpalhano/openclaw-workspace --skill google-sheets-dfpalhano

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires googleapis, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill automates interactions with Google Sheets, allowing you to read, write, format, and manage your spreadsheets programmatically, eliminating manual data entry and manipulation.

Core Features & Use Cases

  • Data Operations: Read, write, append, and clear data within specified ranges.
  • Formatting: Apply various formatting options like background color, text styles, and alignment.
  • Sheet Management: Create, rename, and delete sheets within a spreadsheet.
  • Use Case: Automatically update a sales report in Google Sheets with new data fetched from another source, or format a budget sheet with specific styling for better readability.

Quick Start

Use the google-sheets skill to read data from "Sheet1!A1:B10" in spreadsheet with ID "YOUR_SPREADSHEET_ID".

Frequently Asked Questions about google-sheets

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

FAQPage Schema
How do I automate Google Sheets data management using Node.js?▼

Google Sheets automation with Node.js enables programmatic CRUD operations on cells, ranges, and sheet management via the Google Sheets API, eliminating manual data entry. This Skill executes those interactions directly.

What do I need to authenticate Google Sheets API requests in Node.js?▼

Authenticating Google Sheets API requests in Node.js requires a Google Cloud service account with the Google Sheets API enabled. You must configure this service account to authorize access for your spreadsheet interactions.

Can I format spreadsheet ranges and manage sheets programmatically?▼

Yes, you can format spreadsheet ranges and manage sheets programmatically. The Skill supports applying background colors, text styles, alignment, alongside creating, renaming, and deleting sheets within a spreadsheet.

How do I read and write data to specific Google Sheets ranges?▼

To read and write data to specific Google Sheets ranges, you specify the target range like "Sheet1!A1:B10" and the spreadsheet ID. The Skill then executes read, write, append, and clear operations within that defined range.

Is there a way to append new data fetched from another source to a spreadsheet?▼

Yes, you can append new data fetched from another source to a spreadsheet. The Skill automates updating reports by appending fetched data into specified ranges, streamlining programmatic data ingestion workflows.

Related Skills

Explore More Data & Analytics Skills→
CraftOS-devCraftOS-dev
375

google-sheet

Manage Google Sheets data, formatting, and sheets via the API with Node.js.

Community
Intermediate
terraleiloaterraleiloa

sheets

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

Community
Intermediate
jamditisjamditis
359

python-pipeline

Build and orchestrate modular Python data pipelines with a dispatcher-driven architecture.

Community
Advanced
tankpkgtankpkg
1

@tank/google-sheets

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

Official
Advanced