Google Sheets API limit?

I really have a quick question on using Lookerrun Api function,
how do i increase limits as i have data i would like to run in Google sheets that’s over 100,000 field.

but seems am only allowed to use 1999 rows only beyond that it breaks

will be happy to hear from you

Are you referring to this method?

How does it break? I wonder if that’s a google scripts error with data processing— I think the scripts cannot run for more than 30 seconds or something or it will timeout, so it’s possible that the increased amount of data makes the script time out.