@all,
Well, looks like I have not yet got to MVP on the Google Sheets. The remove redundant row properties sketch I listed above ran last night as intended. However, this morning, all the devices that connected ignored the existing device properties and simply appended a new row.
I feel like I am very close with this approach but I cannot use the spreadsheet for viewing of the current status or for using @rickkas7 CloudConfigRK if the number of rows simply grows and grows. I am going to go back to Stack Overflow and see if I can get someone who is good at App Script to help:
Stay tuned.
Chip