googlesheets-automation
Automate Google Sheets with Claude
Stop manually updating spreadsheets. This skill helps you read, write, format, and manage Google Sheets programmatically through Claude using Composio integration.
下載技能 ZIP
在 Claude 中上傳
前往 設定 → 功能 → 技能 → 上傳技能
開啟並開始使用
測試它
正在使用「googlesheets-automation」。 Read the first 10 rows from the 'Customers' sheet in my 'Sales Database' spreadsheet
預期結果:
I found the spreadsheet 'Sales Database' (ID: 1AbC...xYz). Reading rows 1-10 from the 'Customers' sheet (A1:J10). The data contains: 10 rows including headers with columns: Name, Email, Phone, Company, Status, Last Contact. Total customers: 9 active records.
正在使用「googlesheets-automation」。 Add a new customer to the sheet: Jane Doe, jane@example.com, 555-0123, Acme Corp
預期結果:
Successfully appended the new row to 'Customers' sheet. The record was added to row 11. Updated range: Customers!A11:E11. Confirmation: Jane Doe is now in the spreadsheet.
安全審計
安全All 139 static findings are false positives. The 'external_commands' detections are Markdown code spans (backticks) used for formatting tool names, not shell execution. The 'hardcoded URL' is the official Rube MCP server endpoint in documentation. This is a documentation-only skill with no executable code - it provides instructions for using Google Sheets via the Rube MCP service.
低風險問題 (1)
品質評分
你能建構什麼
CRM Data Synchronization
Keep customer records synchronized between your database and Google Sheets. Use upsert operations to update existing contacts or add new ones based on email addresses as unique keys.
Inventory Tracking
Maintain real-time inventory levels in shared spreadsheets. Read current stock, update quantities after sales, and format low-stock items with red background colors for visibility.
Report Generation Automation
Generate weekly reports by pulling data from multiple sheets, formatting headers with bold styling, and writing summary metrics to a dashboard sheet for team review.
試試這些提示
Read the data from 'Sheet1' in my Google Sheet named 'Q4 Sales Data'. Show me the first 100 rows from columns A through F.
Update the 'Inventory' spreadsheet. In the 'Stock' sheet, set quantity to 50 for rows where SKU is 'PROD-001' through 'PROD-010'. Use batch update for efficiency.
Upsert these customer records into the 'Clients' sheet in my 'CRM Database' spreadsheet. Use 'Email' as the key column to update existing contacts or add new ones: [your data here]
Create a new sheet called 'Summary' in my 'Analytics' spreadsheet. Copy the total row from 'Data' sheet, make the headers bold with blue background, and set column widths to 200.
最佳實務
- Always call RUBE_SEARCH_TOOLS first to verify connection and get current tool schemas before operations
- Use bounded ranges like 'A1:Z1000' instead of unbounded ranges like 'A:Z' to avoid timeouts on large sheets
- Batch multiple read operations together with GOOGLESHEETS_BATCH_GET to stay within the 60 reads/minute rate limit
- Read existing sheet data before writing to understand the current layout and avoid overwriting important information
避免
- Do not use unbounded ranges (e.g., 'A:Z') on sheets with more than 10,000 rows as this causes timeouts
- Do not assume default sheet names like 'Sheet1' exist - they are locale-dependent and may differ in non-English accounts
- Do not perform more than 60 read or write operations per minute or Google Sheets API will return rate limit errors