If you want the script launch the menu when you open the Google Sheet, just add a Trigger. Do this in the Script editor section. Select the "onOpen" function to run for the event type "On open" You could also create macros that will run a specific function and insert the data on scheduled basis. create a new file called macros.gs and then add this code // example function I want to run via macro
function DeviceUplinkDetails() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('A2').activate();
callUplinkInfos();
}; Then create a new trigger for this that calls the function on a schedule. Hope this helps!
... View more
