Understanding the Add Rows Function in Google Sheets Integration

Can anyone explain to me how the Add Rows function works (linking to a google sheet) in terms of how it puts them in, I can see it is 1 at a time but is that 1 at a time per individual sheet or per workbook or just for my account it will only run 1 at a time? (I have lots of different tables exporting to workbooks for cleaning and processing and wondering if it will move faster if I split up the sheets into seperate workbooks)