Refresh data in an Excel spreadsheet without opening it

[danielfeatley]

Hi

I've recently managed to use Flow to manipulate data from my database into Excel speadsheets.

I've then connected these spreadsheets to a master data table which also lives in Sharepoint. However, for this data to refresh I have manually open it and refresh the data connections every day. 

Can a connector be built to replicate this manual task, so that I could refresh the data contained within a spreadsheet based on a trigger action (i.e. an email being sent)

Many thanks