Import a folder of CSVs into a single Google Sheet (1 per tab)
Got this from ChatGPT and tested. Go to apps script: Paste the script below, add your folder ID, and save. The folder ID can be obtained from the URL to the folder: Then, click Run – you will have to go through several security prompts to agree to trust the script.