Query (from Excel) importing of multiple Hubspot API reports directly to Excel spreadsheet


We currently have multiple Hubspot API reports (landing page, forms, etc) that we have to manually download excel files from hubspot biweekly in order to create internal cumulative performance reports. It is very time consuming to download individual reports and then work to merge them all together in excel before analyzing the data.

Excel is able to connect to other platforms like SQL for example to merge datasets from the source location (SQL) and through a simple query form where you can select the date range, the respective data from SQL will automatically migrate from SQL to the excel spreadsheet merged and ready to be analyzed.

How can we do this with Hubspot reports and data?