Create spreadsheets & documents with Google ADK

In the Google Agent Development Kit (ADK), wrap the OpenOfficeAI API as a FunctionTool so your agent can create shareable spreadsheets. ADK builds the tool schema from your typed function and docstring, and the agent calls it when the task calls for a document.

import requests
from google.adk.agents import Agent
from google.adk.tools import FunctionTool

def create_spreadsheet(title: str, rows: list) -> str:
    """Create a shareable spreadsheet (first row = header). Returns a URL."""
    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"]

agent = Agent(
    model="gemini-2.0-flash",
    tools=[FunctionTool(func=create_spreadsheet)],
)

How to create a spreadsheet with Google ADK

1. 1Write a typed create_spreadsheet function with a docstring.
2. 2Wrap it with FunctionTool(func=...).
3. 3Add it to your ADK Agent's tools list.
4. 4Run the agent; it calls the tool and returns the shareable link.

Why use OpenOfficeAI with Google ADK

• Native ADK tool — schema generated from your function.
• Pairs naturally with Gemini models.
• Deployable to Vertex AI Agent Engine.

Frequently asked questions