addToSpreadsheet

#!/usr/bin/env python

import gspread
import sys
import json
from oauth2client.client import SignedJwtAssertionCredentials
timestamp = sys.argv[1]
ping = sys.argv[2]
up = sys.argv[3]
down = sys.argv[4]

json_key = json.load(open('/path/to/my-123123123.json'))
scope = ['https://spreadsheets.google.com/feeds']
credentials = SignedJwtAssertionCredentials(json_key['client_email'], json_key['private_key'], scope)
gc = gspread.authorize(credentials)

document = gc.open("Speedtest Results")
worksheet = document.worksheet("main")
data = (timestamp, ping, up, down)
column_count = len(data)
if worksheet.col_count < column_count:
    worksheet.resize(cols=column_count)
worksheet.append_row(data)

dependencies.sh

yum install gcc python-devel openssl-devel libffi-devel
pip install gspread
pip install oauth2client
pip install PyOpenSSL

#See here for instructions on the oauth json setup
#http://gspread.readthedocs.org/en/latest/oauth2.html

speedtest_cron.sh

#!/bin/sh
result=$(/bin/speedtest-cli --simple)
download=$(echo $result | grep -oP "(?<=Download: )[0-9\.]* .*?/s")
upload=$(echo $result | grep -oP "(?<=Upload: )[0-9\.]* .*?/s")
ping=$(echo $result | grep -oP "(?<=Ping: )[0-9\.]* .*?ms")
addToSpreadsheet "$(date)" "$upload" "$download" "$ping"