I’m building an agent that conducts ~120 prompts across different Nova and Gemini models and outputs the generated content as a string and saves it to a variable in my workflow. I then want to output all of these variables in a single column in a worksheet in Google Sheets.
However, when I originally designed the workflow to do so, I kept getting errors saying that the agent tried to write/update the specified range, saying it needed to do so into adjacent columns. So now, as a temporary work around, I’ve set the following logic for the range to update as follows: Workingsheet!{{columnLetter}}1:XFD
But in reality I want to function as such: Workingsheet!{{columnLetter}}1:{{columnLetter}}
The annoying thing about the current workaround is that becuase variables get strung across multiple columns, I have to manually cleanup the output using the =CONCATENATE function in Google Sheets and add columns in between each break in the output with [" “] and then copy the concatenated values into a new column then use Ctrl+F to find and replace each instance of [” "] with just a space or delete the quotation marks, that way there isn’t random missing spaces.
But if the variables would just write or output into a single cell rather than spilling over and randomly breaking across the next cell in the adjacent column, I wouldn’t have to do all that annoying nonsense with the concatenation function.
Am I the only one having this problem?
