Problem:
A friend of mine has a company, in which 5(five) users use Google Sheets in a shared way. Every night, Spreadsheets receive new demand records (new lines) from the company's ERP system. Every morning, he runs a Macro that distributes Tasks among users, that is, distributes new demands among users. Throughout the day, users enter data and update the Spreadsheets simultaneously. At the end of the day (or during), my friend runs other Macros that prepare the data for visualizations (charts and reports). These Macros are written in AppScript and are stored in these shared Google Sheets. As Macros are accessible by all users, eventually, one of them changes some code.
Searching for a Solution:
So, I would like to know is there a Google application that: (1) allows you to create/import these Macros, isolating them from Sheets; (2) allows automation of tasks in a logical and structured way; (3) allows building them via "No Code" or "Low Code"; (4) manage (and restrict) user access to execute each Macro and (5) manage logs of the execution of each user's actions, including errors that occurred, aiming at a later audit.
User | Count |
---|---|
28 | |
14 | |
3 | |
3 | |
3 |