Bulk import CSV file into a single sheet in a Google Sheet file

Question

I'm trying to write a Google Sheet App script that bulk import CSV files into a single sheet in a google sheet.

Every week my server is sending me a CSV file reporting with some updated data from my database. Each CSV file has exactly the same structure, since it's the same report and only date is changing.

I automatically download all the csv in a single Folder on Google Drive Is there a way to build a script that scans the folder, open the first CSV file fills a Google sheet with the data (and the date of the CSV report) deletes the current CSV from the folder then moves to the next CSV files.

Answer 1

if you dont want to mess around with code, you might as well us this add-on: https://www.sheetgo.com/

Worked well for us. :)