At the moment, I have my Google Apps script set up to run “on edit”, which works perfectly when I manually input in a specific cell in Google Sheets. But, I’m trying to setup a zap that plugs in a specific value in that cell and will trigger those functions on its own. I’m able to get the zap to input the value into the cell but the functions aren’t getting triggered. I know “on edit” only works with user input so I was wondering what the workaround is for this so that the machine input can trigger the functions.
Any help is appreciated!