Import data from CSV file in Google Drive, to Google Sheet
<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>