When working with google products whether that be Sheets, Docs, or anything else, Google Apps Script provides an easy way to manipulate and…