Table Write Agent
Table Write Agent uses large language models (LLMs) to autonomously edit information in tables (XLSX, CSV, TSV, Google Sheet) based on a natural language prompt.
API KEY
Enter an OpenAI or Google API key. The %VARIABLE% format is supported.
OpenAI API Key: Refer to https://platform.openai.com/api-keys
Google API Key: Refer to https://ai.google.dev/gemini-api/docs/api-key
MODEL
The following model types are currently supported:
OpenAI
o3, gpt-4.1, gpt-4.1-mini
gemini-2.5-pro, gemini-2.5-flash, gemini-2.0-flash
Generally, the models listed above are billed based on usage. For billing details, refer to:
OpenAI: https://openai.com/pricing
Google Gemini: https://ai.google.dev/gemini-api/docs/pricing
XLSX/CSV/TSV/GOOGLESHEET
The input "name" of the table file located in the working directory.
Supported formats: XLSX, CSV, TSV, Google Sheets
To prevent data loss caused by agent overwrites when users have not backed up the original file, this module is restricted to reading files only from the working directory.
Recommended usage: Use the
Import File module in EMILY to copy the target file into the working directory before processing.
SHEET
The input sheet name. Please note that when using XLSX or Google Sheet files, this field cannot be left empty.
MAX ACTION
Defines the maximum number of actions the agent can perform. Range: 1–100.
GOAL
Define the task using natural language.
STATUS
The next table action determined and executed by the model.
Example
Goal: Edit the data inside the table
Step 1: Import target table
Step 2: Use the natural language prompt to guide the model
Result
Last updated