How to update a variable cell with tool only, without overwriting other cells in the same row

[03_2_CS]

I am building an AI agent, but I’m stuck on this question.

One of the agent’s functions is to process inputs such as “P000, 1/30, 200”. The agent will extract the Code, Month, and Paid Amount, then write the Paid Amount into Google Sheets with use tool only.

My Google Sheet like below

1. Code is used to match the row.
2. Month is used as the column header.
3. I’m using Map Automatically because there’s no way to specify a variable column in the Google Sheets tool.

Currently, I can update the cell, but the rest of the row gets overwritten with empty values. Is there a solution that allows the AI agent to update only the specific cell with use tool only, without affecting the other data in the same row?

[Wouter_Nigrini]

Hi @03_2_CS is it possible to share your workflow in a code block or your system prompt.

[Sifatullahsolo]

@ 03_2_CS I used IF node and append or updating each outputs parsed individually and that was the only was worked for me