Scheduler to pickup files from temp folder and import them to Google Drive Collection files table

AppSheet AppSheet Q&A
1

I have connected the Google Drive Collection files table to manage files using Appsheet within this connected folder. It works fine I can add/edit/delete files using the Appsheet UI.

Need an Apps Script or a solution to set up a scheduled batch job that will auto-import multiple files from a temp folder to this connected Google Drive Collection files table?

Update: Besides the AppsScript, I am primarily looking for direction/solution on updating the auto-generated GoogleDrive Document Database Table with these imported files. That way these files will connect to my other database entities.

I have followed this video in implementing my solution: https://www.youtube.com/live/IidYmj9o2co?si=vn95XpCC3M6Bm4f_&t=1207

Thanks

2

Google App Scripts can be triggered on a schedule. I recommend searching those forums for help. You might even find a starting script by searching for Google App Script to move files

3

I am sure app scripts to move files I will find there.

But the main thing I would need will be to add entries in the auto-generated Document Database Table which is where I connect these uploaded documents to my other Appsheet Database Entities.