The following pdf is an example data flow diagram with multiple proposals to automate and process data originating from LCPTracker and eBuilder websites.
The Tableau Dashboard is on Tableau’s public site… which will update from Google Sheets once per day. LCPTracker would only provide us a Power BI dashboard that they kept updated. Once we extracted the data, we needed to transform and merge the data into a single dataset (Google Sheet).