Thought I'd share the following solution, which leans heavily on the fantastic work kindly shared by +Romain Vialard
. This attempts to recreate SharePoint list functionality where items can be edited both in bulk or via edit forms, with changes made to the sheet also appearing in the edit forms. This also allows for a bulk import of historical data.
I am still very much learning my way with GAS, so any script improvements or comments welcomed. Hope it is of interest.