If you intend to add multiple lines to a Google Sheet using a batch API call, use batch append instead of batch update. Batch update overwrites existing data, while batch append inserts new rows.
You can refer to the below images for batch append API call.
