title: How to upload a worksheet using pygsheets
body: <p>I'm working with <a href="http://pygsheets.readthedocs.io/en/latest/index.html" rel="nofollow noreferrer">http://pygsheets.readthedocs.io/en/latest/index.html</a> a wrapper around the google sheets api v4. </p>
  
  <p>I have a small script where I am trying to select a json sheet to upload to a google sheets worksheet. The file name is made up of the:</p>
  
  <pre><code>spreadsheetname_year_month_xxx.json
  </code></pre>
  
  <p>The code:</p>
  
  <pre><code>import tkinter as tk
  import tkFileDialog
  import pygsheets
  
  
  root = tk.Tk()
  root.withdraw()
  file_path = tkFileDialog.askopenfilename()
  print file_path
  file_name = file_path.split('/')[-1]
  print file_name
  file_name_segments = file_name.split('_')
  spreadsheet = file_name_segments[0]
  worksheet = file_name_segments[1]+'_'+file_name_segments[2]
  
  gc = pygsheets.authorize(outh_file='client_secret_xxxxxx.apps.googleusercontent.com.json')
  
  ssheet = gc.open(spreadsheet)
  ws = ssheet.add_worksheet(worksheet(ssheet,str(raw_input(file_path))))
  </code></pre>
  
  <p>The file path leads to a generated json file that looks like:</p>
  
  <pre><code>{
    "count": 12, 
    "results": [
      {
        "case": "abc1", 
        "case_name": "invalid", 
        "case_type": "invalid", 
  
      }, 
      {
        "case": "abc2", 
        "case_name": "invalid", 
        "case_type": "invalid", 
        },
  ............
  </code></pre>
  
  <p>I am getting :</p>
  
  <pre><code>File "upload_to_google_sheets.py", line 27, in &lt;module&gt;
  ws = ssheet.add_worksheet(worksheet(ssheet,str(raw_input(file_path))))
  TypeError: 'unicode' object is not callable
  </code></pre>
  
  <p>As you can see I'm trying to instantiate a worksheet with the json data. What am I doing wrong?</p>