speedtest-google-sheets

This is a small python script which runs a speedtest using speedtest.net and inserts it into a Google Docs Spreadsheet.

Setup

1. Create a new Project in the Google Cloud Platform Console.

2. Enable the Google Sheets API in the API Library.

3. Go to Credentials and create a new OAuth 2.0 Client ID for Desktop Applications.

4. Download the Credentials in the format of a json file.

.

5. Rename the file to credentials.json.

6. If you don't want to use Docker, you can now just run main.py and you are good to go. Otherwise you need to run the app locally to generate a google login and need to mount the credentials.json and token.json into the docker container, see docker-compose.yml for an example. Also don't forget to set your Google Sheet ID in the SPREADSHEET_ID environment variable. Also your sheet needs to be named Speedtest.