@Aj check the SearchTask method in the N/task module. You can schedule those searches programmatically, and run a merging script on the CSV results once ready.

Thank you @Felipe Chang... I will read about SearchTask method... Is there any sample script in Suite Answers that I can refer? Just the one with merging the CSV results using script?

Also check out Celigo's live Excel connector. Looks pretty robust.