Now that we have access to all of the data within one of the CSV files, we need to extract specific values. Let us therefore make use of ' Utilities.parseCsv': We could opt to convert them into Google Sheets (which was how I first started) but then we are spending time converting them and ultimately needing to delete afterwards. In this instance we have data in CSV files which cannot be accessed in the usual manner like a Google Sheet.
There are a couple of aspects of the code I want to tease out as they are relatively new. The following Google Apps Script is designed to loop through a folder of CSV files in Google Drive, extract the data, create a Google Sheet file per CSV, and insert the data into specific rows/columns.
0 kommentar(er)
