Google Apps Script: To show values from a Google Sheet in a sidebar
This is a demo of a Google Apps Script that displays values from a selected row in the sidebar.
The change in sidebar values is triggered when the value in column D is edited.
The sidebar background colour changes to match the one in column A of the selected row.