Is it possible to export Google Sheets data as JSON?

Yes, by using the 'gog sheets get' command with the --json flag, you can retrieve spreadsheet data in a structured JSON format for easier processing.

Can I send HTML emails using this skill?

Yes, gog supports sending rich-text emails using the --body-html flag, allowing you to include paragraphs, links, and lists in your messages.

How do I authenticate gog with my Google account?

You must first provide a client_secret.json using 'gog auth credentials' and then authorize your specific email account using the 'gog auth add' command.

Does gog support multiple Google accounts?

Absolutely. You can add multiple accounts and switch between them using the --account flag or by setting the GOG_ACCOUNT environment variable.

Can I use this to edit Google Docs in real-time?

No, gog currently supports exporting, reading (cat), and copying Docs. In-place editing is not supported by the gog CLI at this time.

Google Workspace Manager (gog)

Name: Google Workspace Manager (gog)
Author: openxjarvis

byopenxjarvis

•

Productivity & Workflow

Automates Google Workspace tasks including Gmail, Calendar, Drive, and Sheets through a powerful command-line interface.

The gog skill empowers Claude to interact directly with the Google Workspace ecosystem, enabling seamless management of emails, calendar events, documents, and spreadsheets. By leveraging the gog CLI, users can perform complex tasks like searching Gmail threads, updating Google Sheets with JSON data, and managing calendar schedules without leaving the terminal. This tool is particularly effective for developers and power users looking to integrate Google services into their automated workflows, scripts, or AI-driven productivity pipelines while maintaining full control over OAuth authentication and account management.

Key Features

01Calendar event orchestration with color-coding and ISO-based scheduling.

0239 GitHub stars

03Full Gmail management including advanced searching, sending, and drafting with HTML support.

04Streamlined multi-account support with environment variable configuration for rapid switching.

05Google Drive file searching and Google Docs content extraction and export.

06Robust Google Sheets integration for reading, updating, and appending data via JSON.

Use Cases

01Managing daily schedules and meeting invites programmatically through the CLI.

02Syncing local data or script outputs directly to Google Sheets for collaborative tracking.

03Automating recurring email reports or notification systems based on local file content.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add openxjarvis/openclaw-python gog

For use in Claude.ai and ChatGPT

Download Skill