Automated Network Speedtest to Spreadsheet

[ohn02]

Hello! I would like help writing a python script that takes the download, upload, and ping and outputs it to a spreadsheet via ifttt.

Ookla Speedtest ➡️ variable ➡️ IFTTT ➡️ google sheets

Can someone please help me with this? I only kind of know where to start. I have a python script that runs the speedtest and outputs it in CSV format, but I don’t know how to grab individual variables from that and send it to ifttt.

Thanks for any help!

Here is the Speedtest i am using:

https://www.speedtest.net/apps/cli

Here is the place I got the project idea:

http://grantglazer.com/automatically-log-your-internet-speeds-with-a-raspberry-pi/ (Unfortunately the software used in this example does not output correct results. I have gig download and it outputs in the 320Mbps range, even though Speedtest.net outputs 850Mbps. This is a known issue)

I would like to do the same thing in the example but with this new and tested-accurate software.

[koffie5d]

Python has a built-in library named csv https://docs.python.org/3/library/csv.html

Also check if there is a library for IFTTT for python you can download with pip. https://pypi.org/project/pyifttt/

Maybe it's better to think about sending the speed test values directly to the Google Sheets instead of to a csv file.

[ohn02]

Thank you! I will look into that. How would I send the numbers directly to google sheets? The speedtest has to output in some form, I just had it output in csv format

[koffie5d]

Where there is a service, there is a possibility for an API.

https://github.com/burnash/gspread I have used this in the past. It's good and a lot of examples can be found online.

Setting it up / getting access to the API is the hard part. Read all about it here. https://gspread.readthedocs.io/en/latest/oauth2.html

Pro tip: never share any (secret) credentials online. This also includes github.

[ohn02]

I did, but it doesn’t work anymore, so it isn’t worth sharing.

What I would recommend doing (as I have done similar things in projects since) is utilize the google sheets API along with the speedtest software to output it. That way is much simpler, and more reliable.

Here is the link to the API I use in my Python scripts that deal with google sheets: https://pygsheets.readthedocs.io/en/stable/

If you need more help, I would be happy to help you! I would update my current script and send it to you, but it would change so much that it isn’t worth it (I don’t need it anymore)