Google Sheets Skill
Read and write data to Google Sheets spreadsheets.
Tool: google_sheets
Consolidated Google Sheets tool with operation parameter.
Operations
| Operation | Description | Required Fields |
|---|---|---|
read | Read data from a range | spreadsheet_id, range |
write | Write data to a range | spreadsheet_id, range, values |
append | Append rows to a table | spreadsheet_id, range, values |
read - Read spreadsheet data
| Field | Type | Required | Description |
|---|---|---|---|
| operation | string | Yes | Must be "read" |
| spreadsheet_id | string | Yes | Spreadsheet ID from URL |
| range | string | Yes | A1 notation range (e.g., "Sheet1!A1:D10") |
How to find Spreadsheet ID:
From URL: https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit
Range Notation (A1):
Sheet1!A1:D10- Specific range on Sheet1Sheet1!A:D- Entire columns A through DSheet1!1:10- Rows 1 through 10A1:D10- Default sheet, specific rangeSheet1- Entire sheet
Example:
{
"operation": "read",
"spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"range": "Sheet1!A1:E10"
}
write - Write data to a range
| Field | Type | Required | Description |
|---|---|---|---|
| operation | string | Yes | Must be "write" |
| spreadsheet_id | string | Yes | Spreadsheet ID |
| range | string | Yes | A1 notation range |
| values | array | Yes | 2D array of values |
| value_input_option | string | No | "USER_ENTERED" or "RAW" (default: USER_ENTERED) |
Example - Write data:
{
"operation": "write",
"spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"range": "Sheet1!A1:C3",
"values": [
["Name", "Score", "Grade"],
["Alice", 95, "A"],
["Bob", 87, "B"]
]
}
Example - Write formula:
{
"operation": "write",
"spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"range": "Sheet1!D2",
"values": [["=SUM(B2:C2)"]],
"value_input_option": "USER_ENTERED"
}
append - Append rows to a table
| Field | Type | Required | Description |
|---|---|---|---|
| operation | string | Yes | Must be "append" |
| spreadsheet_id | string | Yes | Spreadsheet ID |
| range | string | Yes | Table range (e.g., "Sheet1!A:E") |
| values | array | Yes | 2D array of rows to append |
| value_input_option | string | No | "USER_ENTERED" or "RAW" (default: USER_ENTERED) |
| insert_data_option | string | No | "INSERT_ROWS" or "OVERWRITE" (default: INSERT_ROWS) |
Example:
{
"operation": "append",
"spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"range": "Sheet1!A:E",
"values": [
["Charlie", "charlie@example.com", "Sales", "2024-02-01", "Active"],
["Diana", "diana@example.com", "HR", "2024-02-15", "Active"]
]
}
Common Formulas
| Formula | Description |
|---|---|
=SUM(A1:A10) | Sum of range |
=AVERAGE(B1:B10) | Average of range |
=COUNT(A:A) | Count numbers in column |
=COUNTA(A:A) | Count non-empty cells |
=VLOOKUP(E1,A:C,2,FALSE) | Vertical lookup |
=IF(A1>90,"A","B") | Conditional logic |
=TODAY() | Current date |
=NOW() | Current date and time |
Common Workflows
- Import data: Write headers, then append data rows
- Update records: Read to find row, write to specific cells
- Generate reports: Read data, process, write summary
- Log entries: Append new rows with timestamps
Tips
- Always check spreadsheet exists before writing
- Use
USER_ENTEREDfor formulas to work - Range must match data dimensions
- Append is safer than write for adding data
Setup Requirements
- Connect Sheets node to AI Agent's
input-toolshandle - Authenticate with Google Workspace in Credentials Modal
- Ensure Sheets API scopes are authorized
- Spreadsheet must be accessible to authenticated account