google-sheets

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

Updated Jan 22, 2026
One-click install
npx skills add https://github.com/FahadImdad/Nexus-Fahad --skill google-sheets-fahadimdad
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: google-sheets
Source: https://github.com/FahadImdad/Nexus-Fahad/tree/main/00-system/skills/google/google-sheets
Command: npx skills add https://github.com/FahadImdad/Nexus-Fahad --skill google-sheets-fahadimdad

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires google-auth, google-auth-oauthlib, google-api-python-client, and includes scripts (resource) components.

What problem does it solve? Manually updating Google Sheets with data from other sources is repetitive and error-prone. This Skill lets you read, write, append, and manage spreadsheet data programmatically through authenticated API calls, so tracking sheets and reports stay current without copy-pasting. ## Core Features & Use Cases - Full CRUD Operations: Read ranges, write values, append rows, clear cells, and batch-update multiple ranges in one request using A1 notation. - Spreadsheet Management: Create new spreadsheets, add or delete sheets, list accessible spreadsheets via Drive, and retrieve sheet metadata. - Cell Formatting: Apply bold, italic, background colors, number formats, alignment, and auto-resize columns. - Use Case: After extracting contract data from documents, append rows like ["Contract A", "2024-01-15", 5000, "Active"] directly into a tracking sheet with a single command. ## Quick Start Ask the AI to read the range Sheet1!A1:D10 from your Google Spreadsheet ID, or to append a new row of data to your tracking sheet.

Frequently Asked Questions about google-sheets

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

FAQPage Schema
How do I append rows to a Google Sheet with Python?

Use the append command with the spreadsheet ID, an A1 notation range like Sheet1!A:D, and a JSON array of row values. The script calls the Sheets API values.append endpoint with INSERT_ROWS so existing data is never overwritten.

How do I read data from a Google Sheets range?

Run the read command with the spreadsheet ID and an A1 notation range such as Sheet1!A1:D10. The spreadsheet ID is the long string in the sheet's URL between /d/ and /edit, and results print as rows or JSON.

What authentication does the Google Sheets API require?

It uses OAuth 2.0 with a Desktop app credential from Google Cloud Console, with the Sheets API and Drive API enabled. Store GOOGLE_CLIENT_ID, GOOGLE_CLIENT_SECRET, and GOOGLE_PROJECT_ID in a .env file, then run the google_auth.py login flow.

Can I update multiple Google Sheets ranges in one request?

Yes, the batch_update function accepts a list of range-and-values objects and sends them in a single spreadsheets.values.batchUpdate call. This reduces API calls when writing headers and data across different areas of a sheet.

Why does clearing a range not remove formatting in Google Sheets?

The clear operation uses values.clear, which only removes cell values and intentionally preserves formatting. To change formatting, use the format_range function with options like bold, background color, or number format.