I would like to make a bot that helps out our treasurer in GTA.
Basically, I want it to look at any new message in the deposit log, look for the type of thing, and look for the quantity and then update it by adding or subtracting based on what the user puts. For example, there is a shee with a tools heading and under there is flashlight, and there is a quantity and under there is 5, next to flashlight. I would like to make it so when someone writes a message saying +1 flashlight it would search for the correct rows and change the 5 to a 6, etc. Just curious is this is possible? I’ve been messing around with it a bit but I can’t figure out how to search for specific content i.e. only number or only words? Any help is appreciated
@Jakeb2002 , It is absolutely possible to update on Google Spreadsheet.
To update on Google Spreadsheet, you need row id which you can get from lookup value action.