Agent step for long survey - add to sheet
I'm hoping somebody can help me with my agent config.
I want my agent to conduct a survey in whatever language the user chooses. There are 17 questions. Some are multiple choice, some are free text. Most of this works really well. The agent asks the questions in the chosen language, presents multiple choice buttons using the Buttons tool in the agent step.
Then I want to use the Add to sheet tool to save the answers to Google sheets.
This is where it gets inconsistent. When I only have 3 questions in the survey, then the agent logs them in the Google sheet really consistently, even adding the English translation after the other language when something other than English is chosen. When I add other questions in, it logs the later ones but either leaves Q1, 2, 3 blank, or even adds wrong answers in.
I updated the max tokens to be 8000, raised the number of turns that would be remembered but it's still inconsistent. I've played around with different LLM instrutions for the Add to sheets tool but can't find something that works all the time.
Can anyone shed any light? Should I be splitting the survey into multiple agents and log to different columns in the same row?
1 Reply
Anyone have any ideas for this at all?