Read, 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
Real data. Real impact.
Emerging
Developers
Per week
Open source
Skills give you superpowers. Install in 30 seconds.
Interact with Google Sheets using a service account.
Google Cloud Console:
Configure credentials (one of these):
GOOGLE_SERVICE_ACCOUNT_KEY=/path/to/key.jsonservice-account.jsoncredentials.json~/.config/google-sheets/credentials.jsonShare sheets with the service account email (found in JSON key as
client_emailInstall dependencies:
cd skills/google-sheets && npm install
node scripts/sheets.js <command> [args]
| Command | Args | Description |
|---|---|---|
| | Read cells |
| | Write data |
| | Append rows |
| | Clear range |
| Command | Args | Description |
|---|---|---|
| | Format cells |
| | Get cell formats |
| | Add borders |
| | Copy format between ranges |
| | Merge cells |
| | Unmerge cells |
| Command | Args | Description |
|---|---|---|
| | Resize columns/rows |
| | Auto-fit columns |
| | Freeze rows/columns |
| Command | Args | Description |
|---|---|---|
| | Create spreadsheet |
| | Get metadata |
| | Add sheet tab |
| | Delete sheet tab |
| | 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/editNo automatic installation available. Please visit the source repository for installation instructions.
View Installation Instructions
1,500+ AI skills, agents & workflows. Install in 30 seconds. Part of the Torly.ai family.
© 2026 Torly.ai. All rights reserved.