How to parse a google spreadsheet into an object?

Question

Google Apps Script

There is a table for generating a complex object with different nesting. The number of columns can be dynamic (2, 3.4, etc.). The last column is the final value of the property.
How to properly parse a table so that the result (in this case) is an object of the form:

obj1: {
        prop1: val1
    },
obj27: {
        prop2: val2,
        prop3: val3,
        obj45: {
            prop4: val4,
            prop5: val5
        },
        obj6: {
            prop6: val6
        },
        prop7: val7
 }

I did not find a solution for such issues on the Internet. Prompt the correct universal writing algorithm. Or maybe there are ready-made scripts somewhere.

Answer 1

google sheets to json