How to interact with Google Apps Script?

Question

Google Workspace

Good day, colleagues.
There is the following task: On Google Drive there is a Google Spreadsheet table with some complex analysis of a bunch of data. Periodically, this data needs to be added to this table. The data comes to us by mail in the form of an xls file. The algorithm for parsing the xls file and adding data to the table is not complicated (quite clear and understandable) to implement even in JS. Questions arise rather on the implementation of the algorithm in the form of a Google Apps Script. I have not worked with this technology, so I have questions How is the interaction of the end user with the script implemented in general:
- Is it possible to put the script in the Google Drive folder so that the user can "run" the script, select files for processing in the graphical interface and click "OK" to run the script?
- Is it possible to teach a script to monitor a certain folder on Google Drive and process all the files that got into it
- Is it possible to teach a script to monitor a mailbox for letters from a specific correspondent?
In fact, the first option is enough for me to start.
Thanks in advance

Answer 1

You can create a script for individual files on Google Drive and link it to your table(s). You can also embed the script directly into the table.
In a Google Apps Script script, you can implement your task of parsing data, transferring, converting, reading mail, etc.
Ready to help [email protected]