Create spreadsheets & documents with Gemini Function Calling

Declare a function for Google Gemini and the model can create shareable spreadsheets on its own. Gemini returns a function call with the arguments; your code runs the API request and feeds the URL back. Works with the Google GenAI SDK.

from google import genai
from google.genai import types
import requests

def create_spreadsheet(title: str, rows: list) -> str:
    """Create a shareable spreadsheet; 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"]

client = genai.Client()
resp = client.models.generate_content(
    model="gemini-2.0-flash",
    contents="Make a sheet of Q3 revenue",
    config=types.GenerateContentConfig(tools=[create_spreadsheet]),
)
print(resp.text)

How to create a spreadsheet with Gemini Function Calling

1. 1Define a typed Python function with a docstring.
2. 2Pass it in tools= on GenerateContentConfig.
3. 3The SDK auto-calls the function when Gemini requests it.
4. 4Gemini incorporates the returned url into its reply.

Why use OpenOfficeAI with Gemini Function Calling

• Automatic function calling — the SDK runs your function.
• Type hints + docstring become the function declaration.
• Pairs with Gemini's long context for big data exports.

Frequently asked questions