title: Importing multiple CSV files into Google Sheets using Google Apps Script
body: <p>So I am doing a personal project for my home administration. I would like to automatically when opening my spread sheet (adminSheet.gs) to import .csv files. It is possible to do this manually, but I would like to automate this as I have to import 30+ .csv files, and more coming. I have enabled google apps script (GAS). However GAS is new for me, I am a bit comfortable with Javascript, however it has been a while since I was in college.. I hope you can help me out!</p>
  <p>Here are the facts.</p>
  <p>I have multiple .csv files, all with a different name. They are located in the same folder called CSVfolder. This folder is within the main folder MAINfolder in Google Drive. They are seperated by the delimiter ; (semicolon). The CSV files have the same data structure and the first row of each .csv file is the same. This first row has been put already in the sheet adminSheet.gs, serving as the header row called HEADER. So the first row needs to be deleted of each .csv file when imported.</p>
  <p>I will upload new .csv files in the CSVfolder. These file name follow the following naming structure. ID_01-09-2020_30-09-2020.csv or ID_01-10-2020_31-10-2020.csv. ID followed by a changing date. (the .csv data will be for that period of time. overlapping or duplicated data will not occur, as I will choose the dataset manually). However this would make it of course very neat.</p>
  <p>When I open the adminSheet.gs (located in the MAINfolder), it needs to automatically recognise any new .csv file and merge that into the existing adminSheet.gs with all the other (previously imported) .csv data. The new .csv file should merged below the fixed header row HEADER and above the previously imported .csv file. (this can also be explained as: between the HEADER and the data already in the adminSheet.gs) (this can also be explained as: the new data from the .csv should come above the old data already in the adminSheet.gs).</p>
  <p>What Google Apps Script could do this?</p>