Automatically update all rows


I want to make an automatically update all rows in my table.

I calculate the rest of the warehouse from several tables. It is convenient to do this in a virtual column, since it is constantly updated. But I need this data in Google Sheets, respectively, they need to be transferred to a regular column. I made an Action that does this, but this naturally does not happen automatically and not for all rows at once. I tried to use a bot that, upon updating a row in the table, triggers this Action, but it doesn’t work either. How can I get out of the situation?