Is AppSheet able to perform the following

[lam]

I want to know if AppSheet is able to perform the following functions

1. update a google sheet the date of operation (eg.20200521) and name of user (eg Peter_Chan, use underscore instead of space in between)
2. upload multiply photos to the Google drive with a specific folder name combining date of operation and name of user (eg 20200521_Peter_Chan)
3. sending email to Peter Chan if the above process was finished.

For those who are familiar with App Sheet and google app script, please advice me that App Sheet and google app script are better to perform the above functions.

Thanks!