Create spreadsheets & documents with Flowise
In Flowise, add a Custom Tool node with a short JavaScript function that POSTs to OpenOfficeAI, then connect it to an Agent or Tool Agent node. Your chatflow can then generate shareable spreadsheets and return the link in the conversation.
Flowise — Custom Tool (JS)
// Custom Tool node — JavaScript function body
// Input variables: title (string), rows (array)
const res = await fetch("https://openofficeai.com/api/v1/sheets", {
method: "POST",
headers: {
"Authorization": "Bearer " + $vars.OPENOFFICEAI_KEY,
"Content-Type": "application/json",
},
body: JSON.stringify({
title: $title,
sheets: [{ rows: $rows }],
}),
});
const data = await res.json();
return data.url;How to create a spreadsheet with Flowise
- 1Add a Custom Tool node and define title + rows input variables.
- 2Paste the fetch function; store the key in Flowise Variables ($vars).
- 3Connect the tool to an Agent / Tool Agent node.
- 4The agent calls the tool and returns the shareable url.
Why use OpenOfficeAI with Flowise
- Visual agent builder — drag, connect, done.
- Custom Tool node gives you full fetch flexibility.
- Keep the key in Flowise Variables, not in the flow.
Frequently asked questions
How do I store the API key in Flowise?
Add it under Variables as OPENOFFICEAI_KEY and reference it as $vars.OPENOFFICEAI_KEY in the Custom Tool function, so it isn't hardcoded in the exported flow.
Which node calls the tool?
Connect the Custom Tool to an Agent (or Tool Agent / Conversational Agent) node. The agent decides when to invoke it based on the tool name and description.
Can I return more than the URL?
Yes. Return a JSON string with url and id; the agent can then reference the document id later in the conversation if needed.
Start creating documents with Flowise
Free tier includes 500 API calls per month — no card required.