PromptShop

Gigasheet Automation

This skill automates operations within Gigasheet using Composio's Gigasheet toolkit via Rube MCP.

Install

npx promptshop add gigasheet-automation

Details

What This Skill Does

This skill automates operations within Gigasheet using Composio's Gigasheet toolkit via Rube MCP. It is designed for users who need to programmatically interact with Gigasheet for tasks like data analysis and manipulation. The skill requires an active Gigasheet connection and Rube MCP setup.

When to Use

Import data into GigasheetAnalyze data in GigasheetExport data from GigasheetAutomate data cleaning tasksSchedule data updatesCreate custom data visualizations

Key Features

  • Uses Rube MCP for automation.
  • Requires active Gigasheet connection.
  • Discovers available tools via RUBE_SEARCH_TOOLS.
  • Checks connection status via RUBE_MANAGE_CONNECTIONS.
  • Executes tools with RUBE_MULTI_EXECUTE_TOOL.
  • Provides setup and usage instructions.

Manual Installation

Gigasheet Automation via Rube MCP

Automate Gigasheet operations through Composio's Gigasheet toolkit via Rube MCP.

Toolkit docs: composio.dev/toolkits/gigasheet

Prerequisites

Rube MCP must be connected (RUBE_SEARCH_TOOLS available) Active Gigasheet connection via RUBE_MANAGE_CONNECTIONS with toolkit gigasheet 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.

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

Tool Discovery

Always discover available tools before executing workflows:

RUBE_SEARCH_TOOLS queries: [{use_case: "Gigasheet operations", known_fields: ""}] session: {generate_id: true}

This returns available tool slugs, input schemas, recommended execution plans, and known pitfalls.

Core Workflow Pattern

Step 1: Discover Available Tools

RUBE_SEARCH_TOOLS queries: [{use_case: "your specific Gigasheet task"}] session: {id: "existing_session_id"}

Step 2: Check Connection

RUBE_MANAGE_CONNECTIONS toolkits: ["gigasheet"] session_id: "your_session_id"

Step 3: Execute Tools

RUBE_MULTI_EXECUTE_TOOL tools: [{ tool_slug: "TOOL_SLUG_FROM_SEARCH", arguments: {/ schema-compliant args from search results /} }] memory: {} session_id: "your_session_id"

Known Pitfalls

Always search first: Tool schemas change. Never hardcode tool slugs or arguments without calling RUBE_SEARCH_TOOLS Check connection: Verify RUBE_MANAGE_CONNECTIONS shows ACTIVE status before executing tools Schema compliance: Use exact field names and types from the search results Memory parameter: Always include memory in RUBE_MULTI_EXECUTE_TOOL calls, even if empty ({}) Session reuse: Reuse session IDs within a workflow. Generate new ones for new workflows Pagination: Check responses for pagination tokens and continue fetching until complete

Quick Reference

OperationApproach
Find toolsRUBE_SEARCH_TOOLS with Gigasheet-specific use case
ConnectRUBE_MANAGE_CONNECTIONS with toolkit gigasheet
ExecuteRUBE_MULTI_EXECUTE_TOOL with discovered tool slugs
Bulk opsRUBE_REMOTE_WORKBENCH with run_composio_tool()
Full schemaRUBE_GET_TOOL_SCHEMAS for tools with schemaRef

Gigasheet Automation via Rube MCP

Automate Gigasheet operations through Composio's Gigasheet toolkit via Rube MCP.

Toolkit docs: composio.dev/toolkits/gigasheet