I've been using macros to save my scheduled saved searches that get sent to my email with CSV attachment. I'm looking for other solutions because I have to be at my computer to manually fire off the macro and I want to get away from that. What other options are out there to pull these saved searches automatically preferably in real time when I open an Excel sheet? ODBC connector? I've looked into PowerAutomation but I don't know if that will actually solve my problem. My macro is saving scheduled saved searches on our One Drive and my Excel file lives in our OD also.

@Adam Weaver CloudExtend's Excel Data Connector for NetSuite enables you to run your NS searches on demand or on a schedule and they will all flow into your OneDrive file(s).

Guessing this is a paid service?