search

IsacSvensson / Speedtest-Google-Sheets

A python script that logs internet connection to a google sheet
MIT License
0 stars 0 forks source link
automation google-sheets-api internet-connection speedtest

readme

Speedtest-to-Google-Sheets

A python script that logs internet speed to a google sheet

Config

  1. Run the following command to install all libraries needed: pip install --upgrade speedtest-cli google-api-python-client google-auth-httplib2 google-auth-oauthlib
  2. Create a Google Sheets API with an OAuth 2.0 Client ID. Save credentials as "credentials.json" in project folder.
  3. Create a Google Sheet and set following cells: A1 = Datetime, B1 = Download, C1 = Upload
  4. Set up a diagram over the columns A:C
  5. Copy the sheet id and paste into "data.json".
  6. Run the script!