The following is offered on the basis that there are usually many ways to solve a problem. This is just one approach.
There are three elements to the resolution of this question:
1 - update the data in columns columns A-to-G
This is achieved through a virtual "copy/paste" using copyValuesToRange(sheet, column, columnEnd, row, rowEnd) doc ref.
2 - set the ...