Hi rambizn,
For your second question about pasting rows from one sheet into another, i recently came across the same issue. I found the most efficient solution to be generating a string of values separated by a comma with a text aggregator, then using the Google Sheets Make an API call module to batch update the sheet.
In my scenario, I am deleting a large range of old data, and replacing it with new data from an air table. Using the make an api call, I’m deleting a large range of data and replacing it with new data that is aggregated using a text aggregator. Using the make an api call module instead of search row, and update row modules saves over 1000 operations per run.
Here is a link to the google docs on how to structure the request body.
And here is an example of the request body I’m using.
{
“requests”: [{
“deleteRange”: {
“range”: {
“sheetId”: 0,
“endColumnIndex”: 7,
“startColumnIndex”: 0,
“startRowIndex”: 1,
“endRowIndex”: 2000
},
“shiftDimension”: “ROWS”
}
},
{
“pasteData”: {
“coordinate”: {
“sheetId”: 0,
“rowIndex”: 1,
“columnIndex”: 0
},
“data”: “{{5.text}}”,
“delimiter”: “,”
}
}
]
}
Hope that helps!