title: How can I most easily authenticate with gspread in a Jupyter notebook?
body: <p>Many of my partners at work are comfortable mainly with spreadsheets, and not python, scala, java, SQL, etc. These people are non-technical, but they need data and it's my job to get it in their hands. Reading about Google colaboratory, and <a href="https://colab.research.google.com/notebook#fileId=/v2/external/notebooks/io.ipynb&amp;scrollTo=WgXqE02UofZG" rel="nofollow noreferrer">their example notebook on io</a>, I discovered gspread and the apparent ease of authentication:</p>
  
  <pre><code>from google.colab import auth
  auth.authenticate_user()
  
  import gspread
  from oauth2client.client import GoogleCredentials
  
  gc = gspread.authorize(GoogleCredentials.get_application_default())
  </code></pre>
  
  <p>We use a local deployment of Jupyter with several customizations for simplifying access to Presto, Hive, Spark, etc, so I tried installing colab in our environment to no avail (it's not open source). The next best approach I found was <a href="http://gspread.readthedocs.io/en/latest/oauth2.html" rel="nofollow noreferrer">using oauth2</a>, but this seems to require a GCP account for access to the <a href="https://console.developers.google.com/apis/dashboard" rel="nofollow noreferrer">Google Developer's Console</a>. This seems overly complicated for something that boils down to authenticating with a remote service.</p>
  
  <p>So, group mind, how do <em>you</em> most easily authenticate with gspread in a jupyter notebook?</p>