Unless there is a standard way to export data from investing.com, you will need to write a scraper that pulls all of the data from the website that you want, and then use google sheets API (or some other method) to import it into your workbook.
This scraper can then be scheduled to run automatically so that you don't need to update your workbook.
Now, for the sake of legality because of course I promote ethical scripting, you will have to check whether you have permission to scrape this data, as many platforms don't allow this because they have rights to the data.
Re: terms and conditions from investing.com
The Services may not be used or accessed by any automated machine, bot, spider, or such other automated feature or service;