Get the FREE Ultimate OpenClaw Setup Guide →

googledocs-automation

Scanned
npx machina-cli add skill ComposioHQ/awesome-claude-skills/googledocs-automation --openclaw
Files (1)
SKILL.md
5.6 KB

Google Docs Automation via Rube MCP

Create, edit, search, export, and manage Google Docs documents programmatically using Rube MCP (Composio).

Toolkit docs: composio.dev/toolkits/googledocs

Prerequisites

  • Rube MCP must be connected (RUBE_SEARCH_TOOLS available)
  • Active connection via RUBE_MANAGE_CONNECTIONS with toolkit googledocs
  • Always call RUBE_SEARCH_TOOLS first to get current tool schemas

Setup

Get Rube MCP: Add https://rube.app/mcp as an MCP server in your client configuration. No API keys needed — just add the endpoint and it works.

  1. Verify Rube MCP is available by confirming RUBE_SEARCH_TOOLS responds
  2. Call RUBE_MANAGE_CONNECTIONS with toolkit googledocs
  3. If connection is not ACTIVE, follow the returned auth link to complete setup
  4. Confirm connection status shows ACTIVE before running any workflows

Core Workflows

1. Create a New Document

Use GOOGLEDOCS_CREATE_DOCUMENT to create a new Google Doc with a title and initial text content.

Tool: GOOGLEDOCS_CREATE_DOCUMENT
Parameters:
  - title (required): Document filename/title
  - text (required): Initial text content to insert into the document

2. Search for Documents

Use GOOGLEDOCS_SEARCH_DOCUMENTS to find Google Docs by name, content, date, or sharing status.

Tool: GOOGLEDOCS_SEARCH_DOCUMENTS
Parameters:
  - query: Search query string
  - max_results: Limit number of results
  - modified_after / created_after: Filter by date
  - shared_with_me: Filter shared documents
  - starred_only: Filter starred documents
  - include_shared_drives: Search shared drives
  - order_by: Sort results
  - page_token: Pagination token

3. Update Document Content with Markdown

Use GOOGLEDOCS_UPDATE_DOCUMENT_MARKDOWN to replace the entire content of a document with Markdown-formatted text.

Tool: GOOGLEDOCS_UPDATE_DOCUMENT_MARKDOWN
Parameters:
  - id (required): Document ID
  - markdown (required): Markdown content to replace entire document body

4. Find and Replace Text

Use GOOGLEDOCS_REPLACE_ALL_TEXT to replace all occurrences of a string in a document.

Tool: GOOGLEDOCS_REPLACE_ALL_TEXT
Parameters:
  - document_id (required): Target document ID
  - find_text (required): Text to search for
  - replace_text (required): Replacement text
  - match_case: Case-sensitive matching (boolean)
  - search_by_regex: Use regex for find_text
  - tab_ids: Specific tabs to search

5. Export Document as PDF

Use GOOGLEDOCS_EXPORT_DOCUMENT_AS_PDF to export a Google Doc to PDF format.

Tool: GOOGLEDOCS_EXPORT_DOCUMENT_AS_PDF
Parameters:
  - file_id (required): Document file ID
  - filename: Output PDF filename

6. Copy a Document

Use GOOGLEDOCS_COPY_DOCUMENT to duplicate an existing Google Doc.

Tool: GOOGLEDOCS_COPY_DOCUMENT
Parameters:
  - document_id (required): Source document ID to copy
  - title: Title for the new copy
  - include_shared_drives: Search shared drives for the source

Common Patterns

  • Search then edit: Use GOOGLEDOCS_SEARCH_DOCUMENTS to find a document by name, then use the returned document ID with GOOGLEDOCS_UPDATE_DOCUMENT_MARKDOWN or GOOGLEDOCS_REPLACE_ALL_TEXT to modify it.
  • Create from template: Use GOOGLEDOCS_COPY_DOCUMENT to duplicate a template, then GOOGLEDOCS_REPLACE_ALL_TEXT to fill in placeholder text.
  • Retrieve then update: Use GOOGLEDOCS_GET_DOCUMENT_BY_ID to read current content, then apply edits with GOOGLEDOCS_UPDATE_EXISTING_DOCUMENT.
  • Batch text insertion: Use GOOGLEDOCS_INSERT_TEXT_ACTION to insert text at specific positions (by index) or append to the end of a document.
  • Share documents: Combine with GOOGLEDRIVE_ADD_FILE_SHARING_PREFERENCE (googledrive toolkit) to share documents after creation.

Known Pitfalls

  • GOOGLEDOCS_UPDATE_DOCUMENT_MARKDOWN replaces the entire document content -- it does not append. Use it for full rewrites only.
  • GOOGLEDOCS_INSERT_TEXT_ACTION requires a precise insertion_index (character position). Set append_to_end: true to safely add text at the end.
  • GOOGLEDOCS_UPDATE_EXISTING_DOCUMENT requires constructing an editDocs request body with raw Google Docs API batch update requests -- consult the API documentation for the correct structure.
  • Document IDs and file IDs are the same value for Google Docs, but parameter names differ across tools (id, document_id, file_id).
  • GOOGLEDOCS_SEARCH_DOCUMENTS uses Google Drive search syntax for the query parameter (e.g., name contains 'report').

Quick Reference

ActionToolKey Parameters
Create documentGOOGLEDOCS_CREATE_DOCUMENTtitle, text
Search documentsGOOGLEDOCS_SEARCH_DOCUMENTSquery, max_results, modified_after
Get document by IDGOOGLEDOCS_GET_DOCUMENT_BY_IDid
Update with MarkdownGOOGLEDOCS_UPDATE_DOCUMENT_MARKDOWNid, markdown
Programmatic editsGOOGLEDOCS_UPDATE_EXISTING_DOCUMENTdocument_id, editDocs
Insert textGOOGLEDOCS_INSERT_TEXT_ACTIONdocument_id, text_to_insert, insertion_index
Find and replaceGOOGLEDOCS_REPLACE_ALL_TEXTdocument_id, find_text, replace_text
Export as PDFGOOGLEDOCS_EXPORT_DOCUMENT_AS_PDFfile_id, filename
Copy documentGOOGLEDOCS_COPY_DOCUMENTdocument_id, title

Powered by Composio

Source

git clone https://github.com/ComposioHQ/awesome-claude-skills/blob/master/composio-skills/googledocs-automation/SKILL.mdView on GitHub

Overview

Automate Google Docs tasks using Rube MCP (Composio) to create, edit, search, export, and copy documents. This enables consistent, scalable document workflows without manual clicks. Always start by fetching current schemas with RUBE_SEARCH_TOOLS to ensure compatibility.

How This Skill Works

The skill connects to Rube MCP as an MCP server and invokes tools like GOOGLEDOCS_CREATE_DOCUMENT, GOOGLEDOCS_SEARCH_DOCUMENTS, GOOGLEDOCS_UPDATE_DOCUMENT_MARKDOWN, GOOGLEDOCS_REPLACE_ALL_TEXT, GOOGLEDOCS_EXPORT_DOCUMENT_AS_PDF, and GOOGLEDOCS_COPY_DOCUMENT to perform actions. Typical patterns involve searching to obtain document IDs before applying updates or exports, and reusing templates by copying documents.

When to Use It

  • Create a new Google Doc with a title and initial content
  • Find documents by name, date, or sharing status
  • Replace an entire document with Markdown content
  • Find and replace specific text across a document
  • Export as PDF or copy documents for templating or archiving

Quick Start

  1. Step 1: Set up Rube MCP to connect to toolkit googledocs and confirm RUBE_SEARCH_TOOLS is available
  2. Step 2: Create a document with GOOGLEDOCS_CREATE_DOCUMENT using a title and initial text
  3. Step 3: If editing, search first with GOOGLEDOCS_SEARCH_DOCUMENTS to get the document ID, then update with GOOGLEDOCS_UPDATE_DOCUMENT_MARKDOWN or GOOGLEDOCS_REPLACE_ALL_TEXT

Best Practices

  • Always fetch current schemas with RUBE_SEARCH_TOOLS before making calls
  • Verify the Rube MCP connection is ACTIVE via RUBE_MANAGE_CONNECTIONS
  • Use search to locate the document ID before edits
  • Choose the right operation: Markdown update for full replace vs. text replace for targeted edits
  • Test workflows on a sample document before applying to production docs

Example Use Cases

  • Create a project brief doc with an outline using GOOGLEDOCS_CREATE_DOCUMENT
  • Find a quarterly report and update sections with GOOGLEDOCS_UPDATE_DOCUMENT_MARKDOWN
  • Copy a template contract and fill in placeholders with GOOGLEDOCS_COPY_DOCUMENT and GOOGLEDOCS_REPLACE_ALL_TEXT
  • Export finalized docs as PDF with GOOGLEDOCS_EXPORT_DOCUMENT_AS_PDF for distribution
  • Batch replace a term across multiple docs with GOOGLEDOCS_REPLACE_ALL_TEXT

Frequently Asked Questions

Add this skill to your agents
Sponsor this space

Reach thousands of developers