title: How to programmatically download zip files shared in google drive via form?
body: <p>I have a google form that accepts file uploads, all of them in zip format.</p>
  <p>That form generated a spreadsheet, where each row has a link with a unique uri, that represents a zip. I want to download all of these zip files to disk.</p>
  <p>Using gspread it is easy to get all the URIs. However these do not have .zip extensions, and they seem to be google drive paths.</p>
  <p>I've tried extracting the ids from the URI and using the requests package to get:</p>
  <ul>
  <li><code>https://drive.google.com/uc?export=download&amp;id=DRIVE_FILE_ID</code></li>
  <li><code>https://drive.google.com/u/2/uc?id=DRIVE_FILE_ID&amp;export=download</code></li>
  </ul>
  <p>but neither of these approaches seemed to work.</p>
  <p>It seems like the URI is linking to a preview of the inside of the zip, but I can't figure out how to simply download it programatically. Clicking on hundreds of links and downloading each by hand isn't really an option.</p>