Google Sheet - Asking to return few more details about the retrieved row does not succeed and gets into a loop of retrying and failing.

[sangee2004]

Steps that lead to the problem:

1. Create an agent with google sheet tool bundle.
2. Ask it to read this file which is in google drive- Employee Sample Data.xlsx.
3. Then ask it return all names of the people who work in IT Department and then asked for Accounting department.
4. Then asked to return few more details like - can you show EEID and Gender for these employees?
   I get this response:

It seems that the "Gender" column is not present in the spreadsheet. I can provide the EEID for the employees in the Accounting department if that would be helpful. Would you like me to do that?

Tried few other set of fields and get the same error .

Thread - https://test.otto8.ai/admin/agents/a19xb2h?threadId=t12sg25

I see this error being returned by the Query Spreadsheet tool

    "llmRequest": {
      "command": [
        "/bin/sh",
        "-c",
        "exec /usr/bin/env python3 ${GPTSCRIPT_TOOL_DIR}/querySpreadsheet.py"
      ],
      "input": "{\"spreadsheet_id\":\"1HJHL2GTh6Y-pfRyEle_lbicMYNlVofhazc7_Xx3etb0\",\"query\":\"Department == 'Accounting'\",\"show_columns\":\"EEID, `Job Title`\"}"
    },
    "llmResponse": {
      "err": null,
      "fullOutput": "\"[' `Job Title`'] not in index\"\n",
      "output": "\"[' `Job Title`'] not in index\"\n"
    },
    "output": [
      {
        "content": "\"[' `Job Title`'] not in index\"\n",
        "subCalls": null
      }
    ],

Debug logs - calls (10).json

[sangee2004]

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

Able to get information about other details of the entries like Employeeid and Gender for the retrieved list of employee names.