/google-speedtest-chart

:chart_with_upwards_trend: Python script to create a beautiful Google Chart out of your speedtest results

Primary LanguagePythonMIT LicenseMIT

google-speedtest-chart

Simple Python script to push speedtest results (using speedtest-cli) to a Google Docs spreadsheet. I use this to measure and track my upload and download bandwith:

You can find an interactive demo (actually productive) version of the chart by clicking the image above.

Requirements

Installation and usage

  1. Clone and open repository:

    git clone https://github.com/frdmn/google-speedtest-chart.git
    cd google-speedtest-chart
    
  2. Install dependencies:

    pip install -r requirements.txt
    
  3. Symlink it into your $PATH:

    ln -s speedtest-charts.py /usr/local/bin/speedtest-to-google
    
  4. Authorization

    1. 📖 Authorize pygsheets
    2. 📖 Create an OAuth token, download the credential file and and store it as credentials.json
  5. Create a spreadsheet dedicated to collect your speedtest results:

    📖 docs/Create-a-spreadsheet-to-collect-data.md

  6. Run the script, you can pass a custom spreadsheet name by setting SPREADSHEET environment variable:

    SPREADSHEET="Speedtest-document" speedtest-to-google
    

License

MIT

Version

1.5.0