@apilium/google-sheets

Google Sheets integration skill for Mayros -- read, write, format spreadsheets via Sheets API v4.

Installation

Copy this skill directory into your Mayros skills folder:

cp -r skills/google-sheets ~/.mayros/skills/google-sheets

Or install via the Mayros CLI:

mayros skill install @apilium/google-sheets

Configuration

This skill requires a GOOGLE_ACCESS_TOKEN environment variable with the https://www.googleapis.com/auth/spreadsheets scope.

Obtain a Token

Option 1 -- gcloud CLI:

export GOOGLE_ACCESS_TOKEN=$(gcloud auth print-access-token --scopes=https://www.googleapis.com/auth/spreadsheets)

Option 2 -- OAuth2 flow: Create credentials in the Google Cloud Console and complete the OAuth2 authorization code flow.

Usage

Once configured, the agent can:

• Read data: Fetch cell ranges from any spreadsheet
• Write data: Update cells with values or formulas
• Append rows: Add new rows to existing sheets
• Create spreadsheets: Create new spreadsheets with custom titles
• Add sheets: Add new tabs to existing spreadsheets
• Clear ranges: Remove data from specified cell ranges

Example Prompts

"Read the data in Sheet1 from A1 to D10"
"Write these sales figures to the Q1 tab"
"Create a new spreadsheet called Budget 2026"
"Append a row with today's metrics to the tracker"
"Clear the old data in column E"

Semantic Predicates

Operation Annotations

The skill automatically annotates query results with the operation type:

• read -- Data retrieval operations
• write -- Cell update operations
• append -- Row append operations
• create -- Spreadsheet or sheet creation
• clear -- Range clear operations

License

MIT