A simple script which can be added to triggers on Google sheets which opens and runs import functions
- Follow workflow stated here to setup time based trigger docs
- When in script editor add the code in app.js, changing the spreadsheet ID and Sheet name fields
- Save trigger