Dear Client,
I am working on Google Sheet since last 5 years. I have worked on like posted project. I seen your shared video. Based on you requirement, there are two solutions:
1. Apply formula from external application
2. Apply formula when Sheet will be open
Please messageme to discuss more or in case of any demo working need to show you.
Thanks