Make speedtest google sheet raspberry8/11/2023 ![]() First, create speedtest-cron.I did them on a Pi 4 using only integrated NIC and Raspbian, building kernels using the bcm2711_defconfig file provided within their source code. For the sake of logging, we will create another script to run speedtest-ifttt.sh with some extra local outputs. Now that we are logging our results, let’s setup a recurring command by setting up a cron script. When you open it, you should have a new row with the results: Augat 11:17 AM Now check Google Drive, you should have a new Speedtest sheet under a new folder called IFTTT. Once complete, you should see the following message:Ĭongratulations! You’ve fired the speedtest event To test this and make sure that it works type: Now, we will make sure that the script is executable: Once complete, save (Ctrl+O, then enter) and exit (Ctrl+X). Scroll down towards the bottom of the file, and change the SECRET_KEY text to your key from the Webhooks IFTTT channel page (Click the documentation button to see the secret key, copy it, and paste between the yellow quotations) We will need to modify to include your Webhooks Secret Key, and then make sure that the script can be be executed. This will place a copy of speedtest-ifttt.sh in /home/pi/speedtest-cli-extras/bin. We will now get an IFTTT version of the speedtest-csv script: Now that the IFTTT section is setup, let’s jump back to the local Terminal window. Make sure that you set the name the recipe “speedtest” before you click the Add button With that complete, we will then need to add the Log Speedtest results to Spreadsheet recipe to our account.Ĭlick this link to navigate to a pre-made recipe already setup – Log Speedtest results to Spreadsheet Next, connect to the Webhooks IFTTT channel. Make sure that you allow the Google Drive channel to have access to the account that you want your results to be saved to. Open up a browser window, and then connect to the Google Drive IFTTT channel. We will then move on to the next section in IFTTT to allow our speedtest data to be logged into a Google Sheet. ![]() If the output looks similar to above, great! This command will take a little bit of time after you execute speedtest-csv and when it provides an output similar to below as it is running the speedtest in the background. ![]() Now, we will test the new script to see its output: Next, we will get another script to help format the text for easy of transferring it to a spreadsheet. You should see a result similar to this (I have modified some information for privacy) Next, make sure speedtest-cli works by running it: Continue typing the following commands into Terminal: Once your Raspberry Pi is up-to-date, we will set it up for speedtest tracking. Type the following into the Terminal window to manually run update and upgrade options: Google account (either a Gmail or Google for Work account).Raspberry Pi (I used a Raspberry Pi 3b). ![]() Here is what will be needed to complete this project: I want to document the simplest steps to getting this project setup – I hope this is helpful for others out there! While the walkthrough showed the end result, some steps aren’t explicitly listed. This project was exactly what I was looking for, the Raspberry pi will run speed tests with and log the data to a Google Sheet on your Google Drive. Thinking I could use my spare Raspberry pi for this task, I looked to the internet and found an article by Alasdair Allan titled Use Raspberry Pi to Measure Broadband Speeds to Hold Your ISP Accountable. Asking them to review the logs on their end over the last two months got me $80 back recently, but I wanted to find a way to keep my own logs as well. I called my internet provider and they have all the outage logs, and all the leverage in the refund conversation. ![]() In my personal life, I want a stable internet connection at home to ensure my personal server and smarthome gadgets function correctly, but my connection has been going out multiple times per week. One of the biggest frustrations in today’s modern world is when the internet goes out. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |