import gspread
import urllib.request, json
data = urllib.request.urlopen("http://api.plos.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"])