What options are there for automatically getting data from Netsuite into excel? for example, i want to automatically fetch the balance sheet or trial balance as of a specific period and export/post that result into Excel. Can this be done with SuiteQL or Suiteanalytics Connect? Are those options free? I am only interested in free options this can be done. As I have understood it, RESTlet APIs are free but can only be used for saved reports, and not inherent reports like trial balance, income statement etc.

@marjor NetSuite financial statements do not have the Web Query option. It is possible to use SuiteQL to recreate them however I am not aware of any free options to then get that query into Excel on demand or on a schedule.

I have a rough setup. Saved searches, emailed to a folder, then VBA script saves to One Drive and another script in Excel file to pull new data upon opening