Skill UI

Command-line helper in the gws toolkit that fetches values from a specified Google Sheets spreadsheet via spreadsheet ID and range arguments, keeping the interaction strictly read-only for reporting or automation tasks.

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.

Loads two tabs from a Google Sheet, compares their rows with gws-sheets commands, and highlights differences to support audits or cross-period updates.

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.

Reads sales data from Google Sheets, formats it into a Google Docs report, and shares it via Drive permissions, simplifying recurring reporting workflows for stakeholders.

Append a sales deal status update directly into a Google Sheets tracking spreadsheet to keep pipeline data synchronized across your team.

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.

Utilize this tool to programmatically access and parse search engine result pages (SERP) data from multiple sources, including Google, Bing, YouTube, and Google News. It returns comprehensive, structured JSON data, allowing developers and marketers to extract organic results, knowledge graph entries, ads, and local information for advanced SEO analysis, market research, and data science projects. Supports both Python and Node.js implementations.

This skill details advanced techniques for exploiting formula injection vulnerabilities within CSV, Excel, LibreOffice, and Google Sheets environments. It covers DDE, obfuscation methods, and high-risk functions like IMPORT* that can be triggered when user-controlled data is exported or imported into spreadsheet software. Use this for penetration testing of data pipelines and export features.