Download and sort a Google Sheet as JSON

logs.py

#! /usr/local/bin/python

import json, requests

# Your Google Sheet as JSON feed
url = "https://spreadsheets.google.com/feeds/list/YOUR_KEY_HERE/od6/public/values?alt=json"

# Get the data and store it as a dictionary you can sort
r = requests.get(url)
logs = r.json()
list = []

# Turn the whole feed into an iterable list
for log in logs['feed']['entry']:
    list.append((log['gsx$timestamp']['$t'], log['gsx$action']['$t']))

# Show the last 5 items only
for item in list[-5:]:
    print ('%s %s' % (item[0], item[1]))