title: how to read (or parse) google spreadsheet colums note(comment) using python
body: <p>I've a Google Spreadsheet and there is a two column </p>
  
  <pre><code>id , name
  1     aaaa
  </code></pre>
  
  <p>and  there a note for Colum <strong>name</strong> and row 1 that means in the cell(2,2)
  I am able to read data for tow column of the spreadsheet but could not read the note of that cell.
  I am using <strong>gspread</strong> library for reading data from the spreadsheet.</p>
  
  <pre><code>import gspread
  from gspread_dataframe import get_as_dataframe
  
  scope = ['https://www.googleapis.com/auth/drive', 'https://www.googleapis.com/auth/spreadsheets']
  credentials = ServiceAccountCredentials.from_json_keyfile_name(
              'jasonfileNlocation.json',
              scope)
  google_spreadsheet_connection = gspread.authorize(credentials)
  
  wks = google_spreadsheet_connection.open("spreadsheet_name")
  worksheet = wks.get_worksheet(0)
  df = get_as_dataframe(worksheet, evaluate_formulas=True, index='false')
  </code></pre>
  
  <p>for better understanding i have added below image
  <a href="https://i.stack.imgur.com/q2NSz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/q2NSz.png" alt="enter image description here"></a>
  Any help will be appriciated</p>