Create spreadsheets & documents with Haystack

In Haystack, wrap the OpenOfficeAI API as a tool so an Agent or a tool-calling pipeline can produce shareable spreadsheets — for example, exporting retrieved or generated data. Define the function, register it as a Tool, and connect it to your generator.

import requests
from haystack.tools import Tool

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

sheet_tool = Tool(
    name="create_spreadsheet",
    description="Create a shareable spreadsheet and return its URL.",
    parameters={"type": "object", "properties": {
        "title": {"type": "string"},
        "rows": {"type": "array", "items": {"type": "array"}}},
        "required": ["title", "rows"]},
    function=create_spreadsheet,
)

How to create a spreadsheet with Haystack

1. 1Write a create_spreadsheet function that calls /api/v1/sheets.
2. 2Wrap it in a Haystack Tool with a JSON-schema parameters spec.
3. 3Pass the tool to a ToolInvoker or a tool-calling generator/Agent.
4. 4The pipeline returns the shareable url when the model invokes it.

Why use OpenOfficeAI with Haystack

• Plugs into RAG pipelines — export what you retrieve.
• Standard Tool abstraction works across generators.
• Turn pipeline output into a shareable artifact.

Frequently asked questions