To set up a CSV file upload from your Google Drive into Data Studio, please follow the steps below:
- The CSV file should only contain comma separated data, with the field headers as the first values, and the data in field matching order after that. If you would open the file in Google Drive preview, it would render into columns like this:
..and when opened in Excel, it would look something like this:
- When using Google Drive as the source of the CSV file, you only need to give Supermetrics the folder path plus file name. As you are already logged in to Supermetrics for Data Studio with your Google login, you don't need to give the file any specific permissions, as you are reading from your own drive (assuming your logged in to Data Studio with the same login as the Drive you use).
Examples on how the file path configuration could look like in Google Drive:
Matching the above settings in Data Studio, in Custom JSON/CSV data source connection editing view:
- After the file location path is set up, you should see your headers as fields when you click Connect in Data Studio: