auto import csv or xlsx format files from a google drive folder to separate tabs in a master google sheet
Budget: $30 – $250 USD
I have 1 master google sheet and 1 google drive folder that contains multiple files which are each a seperate source data table (either csv format or xlsx). I need a script that will be in ran from the master google sheet that when executed does the following simple task:
1) looks at the google drive folder contents file names and if there is currently a tab already with the same name in the master sheet, it will automatically overwrite that tab's contents with the new contents
2) if there isn't a tab with that name yet it will add it to the master sheet as a new tab
The only other criteria is the google drive folder is will be input in the master google sheet as a variable that should be referenced in the script so the folder can be dynamic.
I found a lot of similar script searching on google but couldn't quite piece something together that worked. I would think this would be straight forward for an experience GAS developer that has done similar projects.
Thanks
1) looks at the google drive folder contents file names and if there is currently a tab already with the same name in the master sheet, it will automatically overwrite that tab's contents with the new contents
2) if there isn't a tab with that name yet it will add it to the master sheet as a new tab
The only other criteria is the google drive folder is will be input in the master google sheet as a variable that should be referenced in the script so the folder can be dynamic.
I found a lot of similar script searching on google but couldn't quite piece something together that worked. I would think this would be straight forward for an experience GAS developer that has done similar projects.
Thanks