Append range values in Google Sheets with Extra Column Data - Apps Script

[@dannysoda1]

Thanks again for these videos, works great!

[@yagisanatode]

Great to hear!

[@dannysoda1]

@@yagisanatode I have noticed that the script takes a long time (sometimes up to a minute) when you have over a few hundred rows already filled in your destination sheet. I am using the binary method as well which I figured would be faster. Is there something that I can do to speed this up?

[@yagisanatode]

@@dannysoda1 Hmm, it should't be taking that long to process. Are you drawing data from multiple locations or adding a single row at a time? Appending a range of rows will be much more peformant and if you need to collect data from multiple locations in your Spreadsheet then something like getRangeList() might be more efficient.

[@dannysoda1]

@@yagisanatode I am drawing data from one tab and appending in one other tab. I am using a range of columns A2:N in the source tab and appending B:0 in the destination tab. Not really sure why its hanging up. I just deleted everything from the destination tab to try from scratch and its just as slow with a clean slate. Just looking through my executions the times range from about 3.5seconds to about 255seconds. Not sure why.

[@yagisanatode]

@@dannysoda1 Hmm. The data that you are drawing from, are you retrieving a single range of data, for example the last 5 rows, or are you drawing from multiple rows within the range? Whend you are appending the data, are you appending a range or a single row each time?