google-sheets-skill

name	google-sheets-skill
description	Read, write, and append data to Google Sheets spreadsheets. Supports cell ranges, formulas, and batch operations.
allowed-tools	google_sheets
metadata	{"author":"opencompany","version":"1.0","category":"productivity"}

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 Sheet1
• Sheet1!A:D - Entire columns A through D
• Sheet1!1:10 - Rows 1 through 10
• A1:D10 - Default sheet, specific range
• Sheet1 - 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", "[e-mail]", "Sales", "2024-02-01", "Active"],
    ["Diana", "[e-mail]", "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

1. Import data: Write headers, then append data rows
2. Update records: Read to find row, write to specific cells
3. Generate reports: Read data, process, write summary
4. Log entries: Append new rows with timestamps

Tips

• Always check spreadsheet exists before writing
• Use USER_ENTERED for formulas to work
• Range must match data dimensions
• Append is safer than write for adding data

Setup Requirements

1. Connect Sheets node to AI Agent's input-tools handle
2. Authenticate with Google Workspace in Credentials Modal
3. Ensure Sheets API scopes are authorized
4. Spreadsheet must be accessible to authenticated account