title: How to find the first empty row of a google spread sheet using python GSPREAD?
body: <p>I am struggling to write codes that find me the first empty row of a google sheet.</p>
  
  <p>I am using gspread package from github.com/burnash/gspread</p>
  
  <p>I would be glad if someone can help :)</p>
  
  <p>I currently have just imported modules and opened the worksheet</p>
  
  <pre><code>scope = ['https://spreadsheets.google.com/feeds']
  
  credentials = ServiceAccountCredentials.from_json_keyfile_name('ddddd-61d0b758772b.json', scope)
  
  gc = gspread.authorize(credentials)
  
  sheet = gc.open("Event Discovery")
  ws = sheet.worksheet('Event Discovery')
  </code></pre>
  
  <p>I want to find row 1158 which is the first empty row of the worksheet with a function, which means everytime the old empty row is filled, it will find the next empty row
  <a href="https://i.stack.imgur.com/cdKC6.png" rel="noreferrer">See here</a></p>