Perhaps you can look into a web data connector? https://onlinehelp.tableau.com/current/api/wdc/en-us/help.htm
Another good link would be a post from a brilliant colleague of mine. https://www.interworks.com/blog/rrouse/2015/07/14/extract-web-data-directly-tableau-our-importio-web-connector
This lets you connect to data on a website directly from within Tableau.
Thank you so much, it really helped