How to pass the agent output argument values to spreadsheet

Help Agent Builder
1

This is my first time building an agent in Studio Web. In my scenario, I’ve created a web‑search agent, and I need to pass the output argument values into a spreadsheet. Can anyone help me understand how to do this?

AGENT_BUILDER
AGENT_BUILDER1905×1107 252 KB

2

@adarsh_kotagiri PFB screenshot

image
image353×400 12.8 KB

3

@adarsh_kotagiri

You can add RPA workflow as a tool in your agent to write the output you got from web search tool.

1 Like
4

Hi @adarsh_kotagiri

You can’t write to Excel directly inside the Studio Web agent. Do it via a tool/automation.

  1. Define the agent Output schema (which you already did – array with Name, ClosingTime, Cuisine, etc.).
  2. Create a Studio (desktop or web) automation with:
  • Input = same structure (list/JSON).
  • Use Excel / Write Range activity to write data to spreadsheet.
  1. In Studio Web Agent → Tools, add “Run Automation” (or API).
  2. Pass the agent output object to that automation as input.
  3. Automation writes the data to Excel.

Flow:

Agent (Web Search)
   → Output (Array/JSON)
      → Run Automation tool
         → Excel Write

Studio Web agents generate data, but file operations (Excel) must be done via a called automation or API, not inside the agent itself.

5

Thank you so much @Gokul001

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.