Alternating between two conditions files while randomly selecting from each, without repetition

Have a look at my independent randomisation demo for one way to do this – which involves preloading one of your two spreadsheets into a list.