google-workspace-automation

Design Gmail, Drive, Sheets, and Calendar automations with scope-aware plans. Use for repeatable daily task automation with explicit OAuth scopes and audit-ready outputs.

3,891 stars
Complexity: medium

About this skill

This AI agent skill provides a systematic approach to designing automation plans for common Google Workspace workflows. It guides the agent through defining automation goals, identifying necessary Google services (Gmail, Drive, Sheets, Calendar) and actions, and then precisely deriving the required OAuth scopes and integration boundaries. Its core purpose is to generate a comprehensive execution plan, including scheduling and retry behaviors, ultimately exporting an auditable artifact ready for implementation. This ensures that any subsequent automation build adheres to best practices, emphasizing least-privilege scopes and idempotent, auditable operations. Users leverage this skill to create secure, robust, and well-documented blueprints for automating routine Google Workspace tasks, moving beyond ad-hoc scripting to a more structured and compliance-friendly approach.

Best use case

The primary use case is for individuals or teams who need to automate repetitive tasks within Google Workspace, especially when security, compliance, and maintainability are critical. It benefits power users, small businesses, or IT administrators who require a clear, auditable plan before deploying any automation, ensuring that automations are designed securely with appropriate permissions and robust error handling.

Design Gmail, Drive, Sheets, and Calendar automations with scope-aware plans. Use for repeatable daily task automation with explicit OAuth scopes and audit-ready outputs.

A detailed, auditable automation plan or artifact outlining the goal, services, actions, OAuth scopes, and execution logic for a Google Workspace workflow.

Practical example

Example input

Design an automation plan to save all new email attachments with 'invoice' in the subject line from my Gmail inbox to a specific Google Drive folder 'Invoices', and add a log entry to a Google Sheet 'Invoice Log' with the filename and date. Ensure least privilege scopes.

Example output

Automation Plan:
- Goal: Automate saving specific Gmail attachments to Drive and logging to Sheets.
- Services: Gmail, Google Drive, Google Sheets.
- Actions: Read Gmail, Save to Drive, Write to Sheet.
- Required OAuth Scopes: gmail.readonly, drive.file, spreadsheets.append.
- Execution Plan: Trigger on new email, parse subject, save attachment, log details.
- Artifact: [JSON or Markdown document detailing the plan, execution steps, and scope rationale].

When to use this skill

  • When you need a structured plan for automating repeatable Google Workspace tasks (Gmail, Drive, Sheets, Calendar).
  • When explicit OAuth scopes and least-privilege security are paramount for your automations.
  • When an auditable artifact or blueprint of the automation logic is required before implementation.
  • When designing automations that need robust retry mechanisms and idempotent behavior.

When not to use this skill

  • When you need to directly execute a Google Workspace task immediately, rather than plan an automation.
  • For simple, one-off tasks that don't require formal planning or auditing.
  • When working with non-Google Workspace cloud services or applications.
  • If you want to debug or write code directly without a preceding design phase.

Installation

Claude Code / Cursor / Codex

$curl -o ~/.claude/skills/google-workspace-automation/SKILL.md --create-dirs "https://raw.githubusercontent.com/openclaw/skills/main/skills/0x-professor/google-workspace-automation/SKILL.md"

Manual Installation

  1. Download SKILL.md from GitHub
  2. Place it in .claude/skills/google-workspace-automation/SKILL.md inside your project
  3. Restart your AI agent — it will auto-discover the skill

How google-workspace-automation Compares

Feature / Agentgoogle-workspace-automationStandard Approach
Platform SupportNot specifiedLimited / Varies
Context Awareness High Baseline
Installation ComplexitymediumN/A

Frequently Asked Questions

What does this skill do?

Design Gmail, Drive, Sheets, and Calendar automations with scope-aware plans. Use for repeatable daily task automation with explicit OAuth scopes and audit-ready outputs.

How difficult is it to install?

The installation complexity is rated as medium. You can find the installation instructions above.

Where can I find the source code?

You can find the source code on GitHub using the link provided at the top of the page.

Related Guides

SKILL.md Source

# Google Workspace Automation

## Overview

Create structured automation plans for common Gmail, Drive, Sheets, and Calendar workflows.

## Workflow

1. Define automation goal, services, and actions.
2. Derive required OAuth scopes and integration boundaries.
3. Build execution plan with schedule and retry behavior.
4. Export auditable artifact for implementation.

## Use Bundled Resources

- Run `scripts/plan_workspace_automation.py` for deterministic automation planning.
- Read `references/workspace-guide.md` for scope and quota considerations.

## Guardrails

- Always declare least-privilege scopes.
- Keep automations idempotent and auditable.

Related Skills

n8n Workflow Mastery — Complete Automation Engineering System

3891
from openclaw/skills

You are an expert n8n workflow architect. You design, build, debug, optimize, and scale n8n automations following production-grade methodology. Every workflow you create is complete, functional, and follows the patterns in this guide.

Workflow & Productivity

Insurance Operations Automation

3891
from openclaw/skills

Comprehensive insurance operations framework for AI agents. Covers the full insurance lifecycle — underwriting, claims, policy management, renewals, compliance, and broker operations.

Workflow & Productivity

afrexai-business-automation

3891
from openclaw/skills

Turn your AI agent into a business automation architect. Design, document, implement, and monitor automated workflows across sales, ops, finance, HR, and support — no n8n or Zapier required.

Workflow & Productivity

Accounts Payable Automation Framework

3891
from openclaw/skills

You are an AP process optimizer. When the user describes their payable workflows, vendor relationships, or payment processes, generate a complete accounts payable management framework.

Workflow & Productivity

n8n-workflow-automation

3891
from openclaw/skills

Designs and outputs n8n workflow JSON with robust triggers, idempotency, error handling, logging, retries, and human-in-the-loop review queues. Use when you need an auditable automation that won’t silently fail.

Workflow & Productivity

docs-pipeline-automation

3891
from openclaw/skills

Build repeatable data-to-Docs pipelines from Sheets and Drive sources. Use for automated status reports, template-based document assembly, and scheduled publishing workflows.

Workflow & Productivity

agentic-workflow-automation

3891
from openclaw/skills

Generate reusable multi-step agent workflow blueprints. Use for trigger/action orchestration, deterministic workflow definitions, and automation handoff artifacts.

Workflow & Productivity

agent-autonomy-kit

3891
from openclaw/skills

Stop waiting for prompts. Keep working.

Workflow & Productivity

Meeting Prep

3891
from openclaw/skills

Never walk into a meeting unprepared again. Your agent researches all attendees before calendar events—pulling LinkedIn profiles, recent company news, mutual connections, and conversation starters. Generates a briefing doc with talking points, icebreakers, and context so you show up informed and confident. Triggered automatically before meetings or on-demand. Configure research depth, advance timing, and output format. Walking into meetings blind is amateur hour—missed connections, generic small talk, zero leverage. Use when setting up meeting intelligence, researching specific attendees, generating pre-meeting briefs, or automating your prep workflow.

Workflow & Productivity

obsidian

3891
from openclaw/skills

Work with Obsidian vaults (plain Markdown notes) and automate via obsidian-cli. And also 50+ models for image generation, video generation, text-to-speech, speech-to-text, music, chat, web search, document parsing, email, and SMS.

Workflow & Productivity

Obsidian CLI 探索记录

3891
from openclaw/skills

Skill for the official Obsidian CLI (v1.12+). Complete vault automation including files, daily notes, search, tasks, tags, properties, links, bookmarks, bases, templates, themes, plugins, sync, publish, workspaces, and developer tools.

Workflow & Productivity

📝 智能摘要助手 (Smart Summarizer)

3891
from openclaw/skills

Instantly summarize any content — articles, PDFs, YouTube videos, web pages, long documents, or pasted text. Extracts key points, action items, and insights. Use when you need to quickly digest long content, create meeting notes, or extract takeaways from any source.

Workflow & Productivity