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)