We are trying to handle (to import data via Plaid API), large amount of data on the spreadsheet (google sheet). The external API needs to be used in the while loop because response needs to be check the condition is true or false. If the conditions meets true then the loop will continue until condition false. And also the external API has limit restrictions(50 calls per minute). We need to store all the response in a single variable like array collection then we need to format and manipulate them in the spreadsheets.