Howdy! I am running into an issue every time I use the Fetch Google Sheet block. It will only fetch the first 63 rows of any sheet, nothing beyond that. I am coming to that conclusion because my workflow is set to run on repeat for each of the rows in my sheet any it only executes 63 times. Below is the debugger link. Is this a set limit in MindStudio?
If you look at the debugger link you shared, the block is correctly fetching 215 rows from the sheet. The subsequent JSON transformation being performed by the Generate Text block is configured with a maximum response size of 4,000 tokens, and so does not have enough tokens to transform the entire result set. You need to increase the maximum response size to have enough tokens to process the entire list.
Fantastic! Thanks Sean!! Just made that update. Appreciate your guidance!