This is my sheet in which i fill the start time for first row manually. I open the link manually for the first time and mark my judgement for “Purchasable” Column as Y/N. As soon as i mark my judgement i want the “end time” column to fill automatically and the link in the “URL” column of the next row to open up automatically and repeat the same series. Is it possible by app script as I need to perform this task on google spreadsheet. I cannot find any solution of opening the URL automatically.