I suppose that the disability to refresh sheet is due to the error on apps script in 'parameter' sentence. I shared the error message before:
Here is the code for the web app, which is a script bound to the spreadsheet
When you publish the script as a web app, you should run it as you, but ensure that anyone can access it. Every time you make a change to the web app you must publish a new version.
You can also run the web app in your browser using the web app url, it will return a white page with the latest number in the top left corner:
Here is the link for the spreadsheet, so you can see the sheet updating as you activate the web app:
But the run function doesn't have doGet execution in my project. How can I run it? The url finishing with "exec" didn't run it.
The blocks attached is too complicated. I think that one ID is enough to connect spreadsheet and I tried it. Can you explain why you use two IDs please?
For your purposes, you should remove the code section from your script, then you do not need the second sheet, unless you want a record of the files deleted on the second sheet