Google Apps Script: SpreadsheetApp, getUI, HTMLservice,
What if you want to get a value or a range from Google Sheets and show it in your sidebar using Google Apps Script?
First, you will need to get the value or range by using Google’s server-side script. Then you will have to display it client-side in your HTML document.
Documentation on getting the server-side and client-side talking nicely to each other is a little vague. Hopefully, this very basic tutorial will help clear things up.
In this tutorial, I will also be using Jquery.
Let’s get started.