google-workspace

Files (1)

• SKILL.md

SKILL.md (first lines)

# Google Workspace Skill — arifOS_bot

Triggers: "gmail", "email", "google calendar", "calendar", "schedule", "google drive",
          "drive", "google sheets", "spreadsheet", "sheets", "google docs", "send email",
          "check calendar", "what's on my calendar", "read email", "upload to drive"

Auth: OAuth 2.0 | Client ID: `26699057...` (already configured at `~/.openclaw/gog/`)

---

## ⚙️ One-Time Setup — Complete OAuth Flow

**Status: Client credentials exist. Access token not yet obtained.**

OAuth credentials are at `~/.openclaw/gog/credentials.json`. Run the flow once to get a token:

```bash
# On VPS host (not inside container):
cd /opt/arifos/data/openclaw/gog

# Install google-auth libraries if not present
pip3 install --quiet google-auth google-auth-oauthlib google-auth-httplib2 google-api-python-client 2>/dev/null

# Run auth flow
python3 << 'PYEOF'
from google_auth_oauthlib.flow import InstalledAppFlow
import json

SCOPES = [
    'https://www.googleapis.com/auth/gmail.readonly',
    'https://www.googleapis.com/auth/gmail.send',
    'https://www.googleapis.com/auth/calendar.readonly',
    'https://www.googleapis.com/auth/calendar.events',
    'https://www.googleapis.com/auth/drive.readonly',
    'https://www.googleapis.com/auth/spreadsheets',
]

flow = InstalledAppFlow.from_client_secrets_file('credentials.json', SCOPES)
# This prints an auth URL — open it in your browser, approve, paste the code back
creds = flow.run_local_server(port=0)

# Save token
with open('token.json', 'w') as f:
    f.write(creds.to_json())
print("Token saved to token.json")
PYEOF
```

After running, `token.json` will be at `~/.openclaw/gog/token.json` and auto-refreshes.

---

## Gmail

### Read unread emails
```bash
python3 << 'PYEOF'
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build

creds = Credentials.from_authorized_user_file('/home/node/.openclaw/gog/token.json')
service = build('gmail', 'v1', credentials=creds)

results = service.users().messages().list(userId='me', q='is:unread', maxResults=10).execute()
messages = results.get('messages', [])
print(f'Unread: {len(messages)} messages')

for msg in messages[:5]:
    m = service.users().messages().get(userId='me', id=msg['id'], format='metadata',
        metadataHeaders=['Subject','From','Date']).execute()
    headers = {h['name']: h['value'] for h in m['payload']['headers']}
    print(f"  From: {headers.get('From','?')}")
    print(f"  Subject: {headers.get('Subject','?')}")
    print(f"  Date: {headers.get('Date','?')}")
    print()
PYEOF
```

### Send email
```bash
python3 << 'PYEOF'
import base64
from email.mime.text import MIMEText
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build

creds = Credentials.from_authorized_user_file('/home/node/.openclaw/gog/token.json')
service = build('gmail', 'v1', credentials=creds)

msg = MIMEText("Email body here")
msg['to'] = 'recipient@example.com'
msg['subject'] = 'Subject here'
raw = base64.urlsafe_b64encode(msg.as_bytes()).decode()

result = service.users().messages().send(userId='me', body={'raw': raw}).execute()
print(f"Sent: {result['id']}")
PYEOF
```

---

## Google Calendar

### View upcoming events
```bash
python3 << 'PYEOF'
from datetime import datetime, timezone
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build

creds = Credentials.from_authorized_user_file('/home/node/.openclaw/gog/token.json')
service = build('calendar', 'v3', credentials=creds)

now = datetime.now(timezone.utc).isoformat()
events = service.events().list(
    calendarId='primary',
    timeMin=now,
    maxResults=10,
    singleEvents=True,

From ariffazil/arifOS, AGPL-3.0.

More from ariffazil/arifOS