import gspread
import urllib.request, json
data = urllib.request.urlopen("http://a...content-available-to-author-only...s.org/search?q=title:DNA").read()
jdata = json.loads(data)

gc = gspread.oauth()
worksheet = gc.open("json to sheet").sheet1


worksheet.update('A1', "journal")
worksheet.update('B1', "eissn")
worksheet.update('C1', "publication_date")

worksheet.update('A2', jdata["journal"])
worksheet.update('B2', jdata["eissn"])
worksheet.update('C2', jdata["publication_date"])