Skill UI

Exports a Google Contacts directory into a Google Sheets spreadsheet by listing domain people via the gws-people tool and appending the retrieved name, email, and phone data row by row.

This comprehensive tool automates nearly every aspect of Google Sheets management. Users can programmatically read, write, update, and append data across multiple ranges. Key functionalities include creating new spreadsheets, managing tabs (renaming, hiding), applying cell formatting, filtering data, performing lookups, and performing 'upsert' operations (update or insert records based on a unique key). Ideal for integrating spreadsheet data into automated workflows.

This script provides a lightweight, standalone Python integration for Google Sheets, offering full read and write access without needing a dedicated server. Users can retrieve spreadsheet data in multiple formats (plain text, CSV, JSON), extract specific ranges, find sheets via search queries, and perform advanced write operations like updating, appending, or clearing cell values. It is highly suitable for automating data reporting, extraction, and workflow integrations involving Google Workspace.