Is there a way to create a data source that can be made to point to a CSV on my website? e.g. https://mysite.com/datasource/leaddata.csv
My plan is to update the csv once a day with fresh data assuming my workbooks will reflect the refreshed data.
Not really, you would have to create a Web Data Connector, but you might be better going with a cloud database for more functionality.
Retrieving data ...