Using an Agent to reason and then update a data table entry

Has anyone tried using an Agent to read, infer and update data tables? I’m curious if there are any existing learnings or best practices around this. Specifically curious around feeding a data entry, feeding additional data inputs, and having the agent update the entry based on its inference. Is it even possible with today’s models, and would you include it as part of a larger prompt or have a dedicated agent for this action?

For example:
I have a data table called tasks
For task “plan dinner party” there is a column called get_ingredients which has a dictionary which includes ‘{“bacon brussel sprouts”}: {“brussel sprouts, bacon”}’
User says “Sam is vegan”
Agent updates get_ingredients to update to “brussel sprouts, vegan bacon”