Create spreadsheets & documents with Claude (Tool Use / MCP)

Give Claude the ability to create shareable spreadsheets and documents by defining a tool in the Anthropic Messages API (or exposing it from an MCP server). Claude decides when to call it and supplies the data; your handler runs the request and returns a link Claude can share in the conversation.

import anthropic, requests

client = anthropic.Anthropic()

tools = [{
    "name": "create_spreadsheet",
    "description": "Create a shareable spreadsheet and return its URL.",
    "input_schema": {
        "type": "object",
        "properties": {
            "title": {"type": "string"},
            "rows": {"type": "array",
                     "items": {"type": "array"}},
        },
        "required": ["title", "rows"],
    },
}]

# When Claude returns a tool_use block, run:
def create_spreadsheet(title, rows):
    r = requests.post("https://openofficeai.com/api/v1/sheets",
        headers={"Authorization": "Bearer YOUR_API_KEY"},
        json={"title": title, "sheets": [{"rows": rows}]})
    return r.json()["url"]

How to create a spreadsheet with Claude (Tool Use / MCP)

1. 1Declare a create_spreadsheet tool with a title + rows input_schema.
2. 2Pass tools to client.messages.create and watch for a tool_use block.
3. 3Run the matching HTTP request to /api/v1/sheets in your handler.
4. 4Return the url as a tool_result so Claude can share the link.

Why use OpenOfficeAI with Claude (Tool Use / MCP)

• Works with the Messages API tool use and with MCP servers.
• JSON Schema maps directly to the API body — minimal glue.
• Claude returns an openable link instead of a pasted table.

Frequently asked questions