title: IMPORTDATA Google Sheet CSV on Google Drive
body: <p>So I'm starting to really get into utilizing Google Drive to streamline my many personal projects. One of the things I'd love to do is figure out how to download CSV files onto my Google Drive, and have Google Sheets automatically do an <code>=IMPORTDATA</code> on any new .csv files in a specific directory.</p>
  <p>I've come across a number of problems trying to figure this out, but the biggest issue is that putting any kind of file on the Google Drive doesn't give you a link to the file itself, but rather something like such:</p>
  <pre><code>https://drive.google.com/a/xxxx/file/x/xxxxxxxxxxxxxxxx/view?usp=sharing
  </code></pre>
  <p><code>=IMPORTDATA</code> doesn't recognize this as a .csv file. How can I go about doing this?</p>