Surprisingly even small models can do this quite well. I have Sonnet on a claw-like generate something based on my emails, airbnb receipts, and so on, and it was perfect and it could edit fields and whatnot, but the Gemini tool can't do anything.

Can it work with comments in sheets as well? When I looked into it, that seemed like a limitation.

You mean cell notes? If so, perfectly well, yes.

It also works fine with Ruby and the "caxlsx" gem. Codex works fine with it as also.