google-sheets-api

Manage Google Sheets and Drive files using curl-only API calls.

Updated Feb 24, 2026
One-click install
npx skills add https://github.com/coolcrazycool/google-api-skills --skill google-sheets-api-coolcrazycool
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: google-sheets-api
Source: https://github.com/coolcrazycool/google-api-skills/tree/main/skills/google-sheets-api
Command: npx skills add https://github.com/coolcrazycool/google-api-skills --skill google-sheets-api-coolcrazycool

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines Google Sheets and Google Drive operations by providing a secure, curl-only interface, eliminating the need for complex SDKs or manual UI interactions.

Core Features & Use Cases

  • Spreadsheet Management: Read, write, append, and clear data in Google Sheets.
  • Sheet & Dimension Operations: Create, delete, rename, resize, and move sheets and rows/columns.
  • Formatting & Filtering: Apply cell formatting, highlighting, and set up basic filters.
  • Drive Integration: Find and retrieve metadata for Google Sheets files.
  • Use Case: Automatically update a sales report in Google Sheets by appending new data and highlighting rows that meet specific criteria, all triggered by a simple command.

Quick Start

Use the google-sheets-api skill to read values from the range 'Sheet1!A1:B10' in your default spreadsheet.

Frequently Asked Questions about google-sheets-api

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

FAQPage Schema
How do I automate Google Sheets updates using curl?

You can automate Google Sheets updates using curl by sending API requests to read, write, append, and clear spreadsheet values without needing complex SDKs or manual UI interactions.

Can I manage Google Drive files and sheets with curl without an SDK?

Yes, you can manage Google Drive files and sheets with curl without an SDK by using a secure, curl-only interface that requires curl, jq, and openssl for API authentication and file discovery.

What do I need to authenticate Google Sheets API requests via curl?

To authenticate Google Sheets API requests via curl, you need curl, jq, and openssl installed, along with secure environment variable-based authentication configured for API access.

How do I format cells and apply filters in Google Sheets via API?

You format cells and apply filters in Google Sheets via API by executing structural edits and batch operations through curl commands, enabling cell highlighting and basic filter setup.

Does this approach support batch operations for spreadsheet data management?

Yes, this approach supports batch operations for spreadsheet data management, allowing you to efficiently perform structural edits, resize dimensions, and move sheets through curl commands.

What's the best way to append new data to a Google Sheets report?

The best way to append new data to a Google Sheets report is using curl commands to interact with the Google Sheets API, automatically adding rows and applying formatting like highlighting specific data.