Google Sheets

The Google Sheets integration allows agents to read and write spreadsheet data programmatically.

Setup

skillett connect google-sheets

Skillett handles all authentication automatically when you connect.

Endpoints

Endpoint	Method	Description
get_spreadsheet	GET	Get spreadsheet metadata
get_values	GET	Read values from a range
update_values	PUT	Write values to a range
append_values	POST	Append rows to a sheet
clear_values	POST	Clear a range
create_spreadsheet	POST	Create a new spreadsheet
add_sheet	POST	Add a sheet tab
delete_sheet	POST	Delete a sheet tab
batch_get_values	GET	Read multiple ranges at once
batch_update_values	POST	Write to multiple ranges at once

Example usage

# Read a range
skillett run google-sheets get_values --spreadsheetId "abc123" --range "Sheet1!A1:D10"

# Write data
skillett run google-sheets update_values --spreadsheetId "abc123" --range "Sheet1!A1" --values '[["Name","Email"],["Alice","alice@example.com"]]'

# Append a row
skillett run google-sheets append_values --spreadsheetId "abc123" --range "Sheet1" --values '[["Bob","bob@example.com"]]'

Common patterns

• Range notation: A1 notation (e.g., Sheet1!A1:D10, Sheet1!A:A)
• Values format: 2D array of arrays (rows × columns)
• Spreadsheet IDs: Found in the Google Sheets URL after /d/