This is a popular post from 2018….
In the previous post in the Google Apps Script Pattern series we looked at selectively updating rows of data in a Google Sheet. For this post we will look at a couple of patterns for inserting multiple rows of data into Google Sheets.
Source: Google Apps Script Patterns: Writing rows of data to Google Sheets – MASHe

Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.