skills.rest
CraftOS-dev
CraftOS-devCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

google-sheet

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

375|38|Updated Dec 2, 2025
Search Tags:#automation#data management#api integration#node.js#spreadsheet#google sheets
One-click install
npx skills add https://github.com/CraftOS-dev/CraftBot --skill google-sheet
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: google-sheet
Source: https://github.com/CraftOS-dev/CraftBot/tree/main/skills/google-sheet
Command: npx skills add https://github.com/CraftOS-dev/CraftBot --skill google-sheet

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 the process of interacting with Google Sheets, eliminating the need for manual data entry, formatting, and management, thereby saving significant time and reducing errors.

Core Features & Use Cases

  • Data Operations: Read, write, append, and clear data within specified ranges of your spreadsheets.
  • Formatting & Layout: Apply custom formatting, resize columns/rows, and manage sheet layouts.
  • Sheet Management: Create, delete, and rename sheets within a spreadsheet.
  • Use Case: Automatically update a sales report in Google Sheets with new data from another source, or format a budget sheet with specific colors and fonts.

Quick Start

Use the google-sheet skill to read data from 'Sheet1!A1:B5' in the spreadsheet with ID 'YOUR_SPREADSHEET_ID'.

Frequently Asked Questions about google-sheet

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?▼

Automate Google Sheets data management by using the Node.js googleapis library to interact with the Google Sheets API. This supports programmatic CRUD operations on cell data, eliminating manual entry and reducing errors.

What do I need to read and write Google Sheets spreadsheet data programmatically?▼

To read and write Google Sheets spreadsheet data programmatically, you need a Google Cloud service account with the Google Sheets API enabled and appropriate permissions. This allows Node.js to access and modify your spreadsheets.

Can I apply custom formatting and manage sheet layouts via the Google Sheets API?▼

Yes, the Google Sheets API allows you to apply custom formatting, resize columns and rows, and manage sheet layouts. You can also create, delete, and rename sheets within a spreadsheet programmatically.

What is the best way to update a Google Sheets spreadsheet with new data from another source?▼

The best way to update a Google Sheets spreadsheet with new data from another source is to use the Google Sheets API via Node.js. It supports appending and writing data to specified ranges, saving time on manual data entry.

Does the googleapis Node.js package support clearing data within specific spreadsheet ranges?▼

Yes, the googleapis Node.js package supports clearing data within specific spreadsheet ranges. It enables full CRUD operations, allowing you to read, write, append, and clear data in specified ranges like 'Sheet1!A1:B5'.

Related Skills

Explore More Data & Analytics Skills→
dfpalhanodfpalhano

google-sheets

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

Community
Intermediate
cellarwoodcellarwood

gws-sheets-read

Read cell values from Google Sheets via the gws CLI.

Official
Basic
cdrgurucdrguru
1

gws-sheets-append

Append a row to a Google Sheets spreadsheet using spreadsheet ID and values.

Community
Intermediate
AdigunQAdigunQ

woocommerce

Manage WooCommerce products, orders, customers, and webhooks via REST API.

Community
Intermediate