google-sheetRead, write, append, and manage Google Sheets via the Google Sheets API (Node.js SDK). Use when you need to interact with spreadsheets โ reading data, writing/updating cells, appending rows, clearing ranges, formatting cells, managing sheets. Requires a Google Cloud service account with Sheets API enabled.
Install via ClawdBot CLI:
clawdbot install longmaba/google-sheetInteract with Google Sheets using a service account.
GOOGLE_SERVICE_ACCOUNT_KEY=/path/to/key.jsonservice-account.json or credentials.json in the skill directory~/.config/google-sheets/credentials.jsonclient_email)
cd skills/google-sheets && npm install
node scripts/sheets.js <command> [args]
| Command | Args | Description |
|---------|------|-------------|
| read | | Read cells |
| write | | Write data |
| append | | Append rows |
| clear | | Clear range |
| Command | Args | Description |
|---------|------|-------------|
| format | | Format cells |
| getFormat | | Get cell formats |
| borders | | Add borders |
| copyFormat | | Copy format between ranges |
| merge | | Merge cells |
| unmerge | | Unmerge cells |
| Command | Args | Description |
|---------|------|-------------|
| resize | | Resize columns/rows |
| autoResize | | Auto-fit columns |
| freeze | | Freeze rows/columns |
| Command | Args | Description |
|---------|------|-------------|
| create | | Create spreadsheet |
| info | | Get metadata |
| addSheet | | Add sheet tab |
| deleteSheet | | Delete sheet tab |
| renameSheet | | Rename sheet tab |
# Read data
node scripts/sheets.js read "SPREADSHEET_ID" "Sheet1!A1:C10"
# Write data
node scripts/sheets.js write "SPREADSHEET_ID" "Sheet1!A1:B2" '[["Name","Score"],["Alice",95]]'
# Format cells (yellow bg, bold)
node scripts/sheets.js format "SPREADSHEET_ID" "Sheet1!A1:B2" '{"backgroundColor":{"red":255,"green":255,"blue":0},"textFormat":{"bold":true}}'
# Copy format from one range to another
node scripts/sheets.js copyFormat "SPREADSHEET_ID" "Sheet1!A1:C3" "Sheet1!D1:F3"
# Add borders
node scripts/sheets.js borders "SPREADSHEET_ID" "Sheet1!A1:C3"
# Resize columns to 150px
node scripts/sheets.js resize "SPREADSHEET_ID" "Sheet1" cols A C 150
# Auto-fit column widths
node scripts/sheets.js autoResize "SPREADSHEET_ID" "Sheet1" A Z
# Freeze first row and column
node scripts/sheets.js freeze "SPREADSHEET_ID" "Sheet1" 1 1
# Add new sheet tab
node scripts/sheets.js addSheet "SPREADSHEET_ID" "NewSheet"
{
"backgroundColor": {"red": 255, "green": 255, "blue": 0},
"textFormat": {
"bold": true,
"italic": false,
"fontSize": 12,
"foregroundColor": {"red": 0, "green": 0, "blue": 0}
},
"horizontalAlignment": "CENTER",
"verticalAlignment": "MIDDLE",
"wrapStrategy": "WRAP"
}
{
"style": "SOLID",
"color": {"red": 0, "green": 0, "blue": 0}
}
Border styles: DOTTED, DASHED, SOLID, SOLID_MEDIUM, SOLID_THICK, DOUBLE
From URL: https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit
Generated Mar 1, 2026
Sales teams can use this skill to automatically update a Google Sheet with new leads, deal stages, and closed-won amounts from CRM systems. It enables real-time data synchronization, allowing managers to generate reports and dashboards without manual entry.
Retail businesses can integrate this skill to read and write inventory levels, track stock movements, and update reorder points in a Google Sheet. It automates data flow from POS systems or e-commerce platforms, reducing errors and improving stock visibility.
Finance departments can automate the consolidation of expense data, revenue figures, and budget allocations into a Google Sheet from various sources. This skill facilitates formatting for presentation and ensures data accuracy for monthly or quarterly reports.
Project managers can use this skill to update task statuses, assignees, and deadlines in a shared Google Sheet from project management tools. It supports real-time collaboration, enabling teams to track progress and adjust timelines dynamically.
Customer support teams can automate the collection of feedback scores, comments, and issue types into a Google Sheet from survey platforms or helpdesk software. This allows for trend analysis and reporting to improve service quality.
Offer a subscription-based service that integrates this skill with popular SaaS platforms like Shopify or Salesforce, automating data sync to Google Sheets for clients. Revenue comes from monthly fees based on usage tiers and support levels.
Provide consulting services to businesses needing tailored automation solutions using this skill, such as setting up complex workflows or custom formatting. Revenue is generated through project-based fees and ongoing maintenance contracts.
Develop and sell an add-on product that leverages this skill to pull data from Google Sheets into analytics tools, offering enhanced visualization and insights. Revenue streams include one-time purchases or annual licenses for the add-on software.
๐ฌ Integration Tip
Ensure the Google service account JSON key is securely stored and shared sheets have appropriate permissions to avoid 403 errors during API calls.
Edit PDFs with natural-language instructions using the nano-pdf CLI.
Comprehensive PDF manipulation toolkit for extracting text and tables, creating new PDFs, merging/splitting documents, and handling forms. When Claude needs to fill in a PDF form or programmatically process, generate, or analyze PDF documents at scale.
Convert documents and files to Markdown using markitdown. Use when converting PDF, Word (.docx), PowerPoint (.pptx), Excel (.xlsx, .xls), HTML, CSV, JSON, XML, images (with EXIF/OCR), audio (with transcription), ZIP archives, YouTube URLs, or EPubs to Markdown format for LLM processing or text analysis.
็จ MinerU API ่งฃๆ PDF/Word/PPT/ๅพ็ไธบ Markdown๏ผๆฏๆๅ ฌๅผใ่กจๆ ผใOCRใ้็จไบ่ฎบๆ่งฃๆใๆๆกฃๆๅใ
Generate hand-drawn style diagrams, flowcharts, and architecture diagrams as PNG images from Excalidraw JSON
The awesome PPT format generation tool provided by baidu.