Testing automated data pulling and visualisation of ISP speed testing
The task:
- setting up automated speed test on QNAP
- syncing resulting log file to Google Drive
- importing log data into a Google Sheet
- visualising some explanatory data
- publishing to web page
The references:
- https://forum.qnap.com/viewtopic.php?t=10571&start=30
- https://github.com/Entware/Entware-ng/wiki/Install-on-QNAP-NAS
- https://github.com/Entware/Entware-ng/wiki/Self-installation-of-python-modules
- https://github.com/sivel/speedtest-cli
- https://www.labnol.org/internet/direct-links-for-google-drive/28356/
- https://mashe.hawksey.info/2012/10/feeding-google-spreadsheets-exercises-in-import/
- https://stackoverflow.com/questions/26937539/parse-tab-separated-text-file-in-google-sheets
- …