skills.rest
LaurentPRAT-DB
LaurentPRAT-DBCOMMUNITY
Explore all skills by this author →
GitHub

google-sheets-creator

Create and manipulate Google Sheets via the Sheets API using gcloud CLI and curl.

Updated Feb 27, 2026
Search Tags:#automation#api#data management#spreadsheet#gcloud#google sheets
One-click install
npx skills add https://github.com/LaurentPRAT-DB/LPT_claude_config --skill google-sheets-creator
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: google-sheets-creator
Source: https://github.com/LaurentPRAT-DB/LPT_claude_config/tree/main/skills/fe-vibe-export/fe-google-tools/1.1.0/skills/google-sheets-creator
Command: npx skills add https://github.com/LaurentPRAT-DB/LPT_claude_config --skill google-sheets-creator

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the creation and management of Google Sheets, eliminating the need for manual spreadsheet manipulation and complex API calls.

Core Features & Use Cases

  • Programmatic Spreadsheet Creation: Generate new spreadsheets with specified titles and initial sheets.
  • Data Manipulation: Update, append, and clear cell values using A1 notation or grid coordinates.
  • Formatting and Styling: Apply colors, fonts, number formats, borders, and conditional formatting.
  • Chart Generation: Create various chart types (column, pie, line) directly within spreadsheets.
  • Formula Insertion: Add complex formulas, including array formulas and cross-sheet references.
  • Sheet Management: Add, delete, rename, and duplicate sheets.
  • Use Case: Automatically generate a monthly sales report spreadsheet, populate it with data, apply currency formatting, add a sales trend chart, and set up conditional formatting for high-value sales.

Quick Start

Use the google-sheets-creator skill to create a new spreadsheet titled 'Monthly Report'.

Frequently Asked Questions about google-sheets-creator

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

FAQPage Schema
How do I automate Google Sheets creation and data updates via API?▼

You can automate Google Sheets creation and data updates by using the Google Sheets API via gcloud CLI and curl. This allows programmatic spreadsheet generation, cell value updates, data appending, and range clearing using A1 notation or grid coordinates.

What's the best way to apply conditional formatting and generate charts in Google Sheets programmatically?▼

Applying conditional formatting and generating charts in Google Sheets programmatically is done through the Google Sheets API. You can apply colors, fonts, borders, and create column, pie, or line charts directly within spreadsheets via gcloud CLI.

Do I need gcloud authentication to manage Google Sheets with the API?▼

Yes, gcloud authentication and a quota project are required to access the Google Sheets API. This setup allows you to automate sheet management tasks like adding, deleting, renaming, and duplicating sheets.

Can I insert complex formulas and cross-sheet references into Google Sheets automatically?▼

Inserting complex formulas and cross-sheet references into Google Sheets automatically is supported via the API. You can add array formulas and perform complex calculations without manual spreadsheet manipulation.

How does programmatic spreadsheet manipulation handle monthly report generation?▼

Programmatic spreadsheet manipulation handles monthly report generation by creating a spreadsheet, populating it with data, applying currency formatting, adding trend charts, and setting up conditional formatting for specific values.

What are the limitations of using gcloud CLI for Google Sheets automation?▼

Using gcloud CLI for Google Sheets automation requires proper authentication and a configured quota project. Limitations include dependency on API quotas and the need for precise A1 notation or grid coordinate inputs for data manipulation tasks.

Related Skills

Explore More Software Engineering Skills→
LaurentPRAT-DBLaurentPRAT-DB

google-auth

Manage unified authentication for Google Workspace APIs using gcloud CLI and Application Default Credentials.

Community
Intermediate
sandmark78sandmark78

data-analyst

Analyze raw data with SQL and Python to generate business insights.

Community
Advanced
heximaoheximao

lark-sheets

Manage Lark spreadsheets with sheet, cell, style, image, and filter operations.

Community
Advanced
omriariavomriariav
7

gws-sheets

Read, write, and manage Google Sheets data via the gws CLI.

Community
Advanced