title: gspread "SpreadsheetNotFound" on certain workbooks
body: <p>I have a google drive folder with hundreds of workbooks. I want to cycle through the list and update data. For some reason, gspread can only open certain workbooks but not others. I only recently had this problem. </p>
  
  <p>It's not an access issue because everything is in the same folder. </p>
  
  <p>I get <code>raise SpreadsheetNotFound</code> when I <code>open_by_key(key)</code>. But then when I take the key and paste it into an URL, the sheet opens. Which means it's not the key.</p>
  
  <p>What's going on here? I'm surprised other people are not encountering this error.</p>
  
  <p>Have I hit my limit on the number of Google sheets I can have? I have about 2 thousand.</p>
  
  <p>Update: I find that if I go into the workbook and poke around, the sheet is then recognized??!! What does this mean? It doesn't recognize the sheet if the sheet isn't recently active???</p>
  
  <p>Also if I try using Google App Script <code>SpreadsheetApp.openById</code>, the key is recognized! So the sheet is there, I just can't open it with <code>gspread</code>. I have use Google script to write something to the sheet first before it is recognized by <code>gspread</code>.</p>
  
  <p>I'm able to open the sheet using <code>pygsheets</code> but since it is new and so buggy, i can't use it. It looks like a <code>APIv4</code> issue? Some sheets can't be opened with <code>APIv3</code>?</p>
  
  <p>update: here is another observation. Once you open the workbook with APIv4, you can no longer open it with V3. </p>