I want to delete a worksheet if it exists in my Google Sheet.
I am using List Sheets and a aggregator to capture the list. Then I added a router to check if a particular sheet exists in the aggregated list. However that is not working.
What is the best way to do this simple if-else loop to access the array of a sheet names?
You might need to use an iterator and iterate over each sheet to see if it is the one you want. That’s the easiest way. You can check the name of each sheet and see if it matches what you are looking for.
Otherwise, you can use an inline function to create a list of all the sheets and check to see if the one you want is there.