How to generate an Excel file from Gemini on Vertex AI

# pip install google-genai doconda
from doconda import Doconda
from google import genai
from google.genai import types

client = genai.Client(vertexai=True, project="my-project", location="europe-west1")
tools = Doconda().tools()
config = types.GenerateContentConfig(
    tools=[types.Tool(function_declarations=[
        types.FunctionDeclaration(name=t.name, description=t.description, parameters_json_schema=t.input_schema) for t in tools
    ])]
)
contents = [types.Content(role="user", parts=[types.Part.from_text(text="Make me an Excel file with the event budget")])]

while True:
    res = client.models.generate_content(model="gemini-3.5-flash", contents=contents, config=config)
    if not res.function_calls:
        break
    contents.append(res.candidates[0].content)
    parts = [
        types.Part.from_function_response(name=c.name, response={"result": next(t for t in tools if t.name == c.name).run(dict(c.args or {}))})
        for c in res.function_calls
    ]
    contents.append(types.Content(role="user", parts=parts))

print(res.text)

// npm install ai @ai-sdk/google-vertex @doconda/sdk
import { createVertex } from "@ai-sdk/google-vertex"
import { generateText, isStepCount, jsonSchema, tool } from "ai"
import { Doconda } from "@doconda/sdk"

const vertex = createVertex({ project: "my-project", location: "europe-west1" })
const doconda = new Doconda()
const tools = Object.fromEntries(
  doconda.tools().map((t) => [
    t.name,
    tool({ description: t.description, inputSchema: jsonSchema(t.inputSchema), execute: (input) => t.run(input as Record<string, unknown>) }),
  ]),
)

const { text } = await generateText({
  model: vertex("gemini-3.5-flash"),
  tools,
  stopWhen: isStepCount(5),
  prompt: "Make me an Excel file with the event budget",
})

console.log(text)