I require assistance with creating a script for automating the printing process in a Google Sheets document. My spreadsheet contains a dropdown list for selecting a ‘campaign name.’ When I make a selection, two charts are generated based on data from another sheet. I want to develop a script that automatically selects each item in this list, pauses for 15 seconds to allow for data processing, prints the corresponding page, and continues this cycle until all items have been printed. Can anyone guide me on how to approach this task or where I can begin? I understand that Google Apps Script, which is similar to JavaScript, is used for this purpose. Thanks in advance for your help!
hey ClimbingLion! have you thought about using the Utilities.sleep() function in Google Apps Script? It can help with setting up delays like the 15-second pause you mentioned. the autoTrigger might be useful too, for triggering the script when the dropdown changes. good luck!