Hi there,
I am an expert Google App Script and automation services developer with more than two years of experience. To implement what you are asking, you will need the following:
1. Cloud (Instance or serverless) environment or a dedicated VPS to implement/deploy a server that can listen for incoming webhook messagesdev/requests
2. The same server will be responsible for firing a background task that updates the Google Sheet of interest with the values as required
3. The sheet will implement a macro and related options (buttons) for generating various reports, graphs, etc., as required
To get started, please ensure you have an appropriate server environment setup. The webhook server will be developed in Node.js and can be deployed in a dedicated VPS or as a serverless Cloud Function.
Let me know what you think of my offer. Thanks for your time and consideration.