Loading...
Loading...
Read and write Google Sheets data. Load when user mentions 'google sheets', 'spreadsheet', 'update sheet', 'read sheet', 'append to sheet', or references extracting data to update a tracking sheet.
npx skill4agent add abdullahbeam/nexus-design-abdullah google-sheetspython3 00-system/skills/google/google-master/scripts/google_auth.py --check --service sheetspython3 00-system/skills/google/google-master/scripts/google_auth.py --loginpython3 00-system/skills/google/google-sheets/scripts/sheets_operations.py read <spreadsheet_id> "Sheet1!A1:D10"python3 00-system/skills/google/google-sheets/scripts/sheets_operations.py write <spreadsheet_id> "Sheet1!A1" --values '[["Name", "Amount"], ["Contract A", 5000]]'python3 00-system/skills/google/google-sheets/scripts/sheets_operations.py append <spreadsheet_id> "Sheet1!A:D" --values '[["New Row", "Data", "Here", "Now"]]'python3 00-system/skills/google/google-sheets/scripts/sheets_operations.py info <spreadsheet_id>python3 00-system/skills/google/google-sheets/scripts/sheets_operations.py list --query "tracking"python3 00-system/skills/google/google-sheets/scripts/sheets_operations.py create "New Spreadsheet" --sheets "Data" "Summary"from sheets_operations import append_rows
data = [
["Contract A", "2024-01-15", 5000, "Active"],
["Contract B", "2024-02-01", 7500, "Pending"]
]
result = append_rows(spreadsheet_id, "Contracts!A:D", data)
print(f"Added {result['updated_rows']} rows")from sheets_operations import batch_update
data = [
{"range": "Sheet1!A1", "values": [["Header 1"]]},
{"range": "Sheet1!B1", "values": [["Header 2"]]},
]
batch_update(spreadsheet_id, data)https://docs.google.com/spreadsheets/d/[SPREADSHEET_ID]/edit| Example | Meaning |
|---|---|
| Single cell |
| Range from A1 to B5 |
| Range in specific sheet |
| Entire column A |
| Entire row 1 |
| Operation | Function | Description |
|---|---|---|
| Read | | Read data from range |
| Write | | Write data to range |
| Append | | Append rows to sheet |
| Clear | | Clear values (keep formatting) |
| Batch | | Update multiple ranges |
| Create | | Create new spreadsheet |
| Info | | Get metadata and sheets |
| List | | List accessible spreadsheets |
pip install google-auth google-auth-oauthlib google-api-python-client.envGOOGLE_CLIENT_ID=your-client-id.apps.googleusercontent.com
GOOGLE_CLIENT_SECRET=your-client-secret
GOOGLE_PROJECT_ID=your-project-idpython3 00-system/skills/google/google-master/scripts/google_auth.py --login