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 Googles 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.