title: Import data from CSV file in Google Drive, to Google Sheet
body: <p>I am using SAS to generate two CSV files every 24 hours. And I have used a bat script to save the generated CSV files in a folder in Google Drive. The CSV files are replaced, so there will always only be these two files in the folder.</p>
  
  <p>The CSV files are seperated by "," and contain only three columns or four columns.</p>
  
  <p>I want to create a direct link between a google sheet and the CSV files, so that the google sheet updates to the newest numbers automatically.</p>
  
  <p>I have tried using the function "ImportData" with no luck</p>
  
  <pre><code>=IMPORTDATA("https://drive.google.com/file/d/123231jshu231731/edit?usp=sharing")
  </code></pre>
  
  <p>where 123231jshu231731 is the file_id.</p>
  
  <p>But the error I get is </p>
  
  <pre><code>Result was not automatically expanded, please insert more columns (896).
  </code></pre>
  
  <p>Which does not make sense as the file only have 3 columns</p>
  
  <p>Hope some have a better solution to my automatization problem</p>
  
  <p>Thanks</p>