How to use/reference a variable instead of value for cell address when sending data to Gsheet

[FarmBuis]

Hi Mobizt,
I have figured out one way of doing this and it seems to work fine when I use update to send the data (have not tried sending more that 400 unsigned long values). However when I use batchUpdate and batchUpdateByDataFilter it will not work if there are more than 390 values (each a byte size) to be sent. Is there a reason for this, am I missing something?

char buffer [40];
for (int counter=0 ; counter <400 ; counter++) {
sprintf(buffer, "values/[%d]/[0]", counter); //this puts the value of counter at %d
valueRange.set(buffer, value) //this adds a value to the previous mentioned address
}

This is what Ive got at the moment but does not work for batchUpdate and batchUpdateByDataFilter it the limit of the for loop is greater than 390.

Is there a different way of sending big amounts of data without having to specify each cell address manually in the code? All I want to do is to be able to manipulate the cell address within a for loop instead of having to write valueRange.set +400 times. In the example below I will try to illustrate what I want to achieve.

for (int counter=0 ; counter <400 ; counter++) {
valueRange.set("values/[counter]/[0]", value);
}

I want to manipulate the value allocated to the row with a variable, in this case the variable is counter. Thanks