reddit_spreadsheet.py

import requests
import gspread
gc = gspread.login('[email protected]', 'password')
wks = gc.open('Reddit Analysis Data').sheet1

# Grab the hot topics
r = requests.get("http://www.reddit.com/hot.json?limit=50")
j = r.json()
cols = ['title', 'author', 'over_18', 'url', 'permalink', 'created_utc', 'subreddit', 'num_comments', 'ups', 'downs', 'score']

# Loop through results
row = 3
for post in j['data']['children']:
    col = 0
    print(post['data']['title'])
    row_data = wks.range('A%d:K%d' % (row, row))
    for col_name in cols:
        row_data[col].value = post['data'][col_name]
        col += 1
    row_data[4].value = 'http://www.reddit.com'+row_data[4].value
    wks.update_cells(row_data)
    row += 1