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:

Platform	Model
OpenAI	o3, gpt-4.1, gpt-4.1-mini
Google	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