Skill UI

Exports a Google Sheets spreadsheet to CSV via gws commands for local backup or downstream processing, using sheets metadata and drive export or direct read operations.

Automates reading event rows from Google Sheets and inserting matching Google Calendar entries via gws commands, keeping schedules synced from a single spreadsheet.

Creates a Google Sheets spreadsheet prepopulated with headers, a sample expense entry, and sharing permissions so teams can immediately start logging and reviewing travel costs.

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.