We use this HubSpot Google Sheets integration to automatically sync the company data to a Google Sheet.
We then use the Google Sheet Import Range function to import this data into another sheet which we can add functions to.
We then do a lookup on this sheet using the Parent ID against the Company ID to add the Parent Company Name as a Column which can then be used in other reports, etc.