google-sheets

Automate spreadsheet operations by reading cell values and ranges using A1 notation, writing updates including formulas, and appending rows. This Skill handles 2D input arrays and batch updates across multiple sheets, eliminating manual data entry while maintaining consistent output with status, range, and updated_cells metadata.

Yes, formulas are supported through the input_option parameter: use USER_ENTERED to write formulas that calculate on submission, or RAW to write literal formula text. This enables automated metric calculations and dynamic updates across your spreadsheet without manual formula entry.

Apply formatting, create sheets, and perform batch updates across multiple ranges in a single operation. The Skill supports cell-level formatting changes alongside data operations, letting you standardize appearance and structure as part of automated workflows.

Yes, the Skill uses shared OAuth authentication with Google Drive, Docs, Calendar, and Contacts, enabling seamless integration across your Google Workspace. This means one token handles authentication for coordinated workflows across multiple Google services.

Clear ranges and manage multiple sheets through batch operations, letting you restructure spreadsheets programmatically. Combine clearing, writing, and formatting tasks across different sheets to automate complex data workflows in a single call.

Use 2D input arrays with A1 notation ranges to specify target cells. This structured format enables batch updates across multiple ranges simultaneously, with consistent output that includes status, affected range, and updated cell count for tracking changes.