gog

What This Skill Does

The gog skill provides a command-line interface (CLI) for interacting with Google Workspace applications, including Gmail, Calendar, Drive, Contacts, Sheets, and Docs. It streamlines common tasks by allowing you to manage your emails, schedule events, search your files, access contacts, and manipulate spreadsheets and documents directly from your terminal. This skill requires OAuth setup to securely authenticate with your Google account, ensuring that your data is accessed only with your explicit permission. The gog skill empowers users to perform complex Google Workspace operations with simple, intuitive commands, making it a powerful tool for automation and productivity.

Installation

To install the gog skill, use the following command:

clawhub install openclaw/openclaw/skills/gog

This command will download and set up the necessary files for the gog skill. After installation, you will need to set up your Google OAuth credentials and authorize the services you wish to use.

Setup Steps (once):

1. Provide Client Secrets: Obtain your client_secret.json file from the Google Cloud Console and run:

   gog auth credentials /path/to/client_secret.json
   

2. Add Account and Services: Authorize gog to access specific Google services for your account:

   gog auth add [email protected] --services gmail,calendar,drive,contacts,docs,sheets
   

3. Verify Authorization: List the authorized accounts and services:

   gog auth list
   

Use Cases

• Email Management: Quickly search your inbox for specific emails, send plain text or HTML emails, create drafts, send replies, and manage messages without leaving your terminal.
• Calendar Operations: List upcoming events, create new events with specific times and summaries, update existing events, and even set event colors for better organization.
• File Management: Search for files and documents within your Google Drive using powerful query parameters.
• Contact Access: List and manage your Google Contacts directly from the command line.
• Spreadsheet Manipulation: Retrieve data from Google Sheets, update cells, append new rows, clear content, and get metadata for your spreadsheets.
• Document Handling: Export Google Docs in various formats (like plain text) or view their content directly in the terminal.

Example Prompts

1. "Find the last 5 emails from '[email protected]' that are in my inbox and display their subjects."
2. "Create a new calendar event for tomorrow at 10 AM with the title 'Team Meeting' in my primary calendar."
3. "Export the Google Doc with ID '123abcXYZ' to plain text and save it as 'meeting_notes.txt'."

Tips & Limitations

• OAuth is Essential: Proper OAuth setup is critical for this skill to function. Ensure you have followed the setup steps carefully.
• Service Specificity: When authorizing, specify only the Google services you intend to use to maintain better security.
• Error Handling: Pay attention to command output for any error messages, which usually indicate issues with authentication, permissions, or command syntax.
• Rate Limits: Be mindful of Google Workspace API rate limits, especially when performing bulk operations.
• Complex Queries: For advanced searching (Gmail, Drive, Sheets), consult the respective Google API documentation for optimal query construction.
• Dynamic Content: When sending emails with dynamic bodies, using --body-file - to read from stdin or --body-file ./message.txt for a local file is recommended for multi-line content.
• Calendar Colors: Familiarize yourself with the available calendar event color IDs using gog calendar colors to visually organize your schedule.