otto8-ai / otto8

Open source AI Agent Platform
Apache License 2.0
19 stars 12 forks source link

Google Sheet Tools - Numeric field gets prepended with `'` #126

Closed sangee2004 closed 1 month ago

sangee2004 commented 1 month ago

Steps to reproduce the problem:

  1. Create an agent with github.com/gptscript-ai/tools/apis/google/sheets/write
  2. Chat with the agent and do the following: Create a new sheet - testnumbers Add row with values - test strings, 1000,2000 Add another row with values - test strings, 2000,3000

Notice that the field gets prepended with '

Screenshot 2024-10-05 at 9 27 50 AM

Any formulas used on these numeric fields error out .

Stack traces for the calls

calls (7).json calls (6).json calls (5).json

cjellick commented 1 month ago

as mentioned elsewhere, please include the debug output for bugs like this. its the best way for devs to be able to investigate after the fact

sangee2004 commented 1 month ago

This issue is not seen anymore when testing with latest versions of the tool.