Hello, I have built an automation bot for round-robin lead assignment, but it is not working correctly. I have already performed extensive troubleshooting and have isolated a very unusual problem.
Goal: Assign leads from a Google Form to salespeople based on their market (“South Korea” or “Outside South Korea”).
Problem:
-
The bot works perfectly when a lead is added directly in the AppSheet app.
-
The bot does not trigger for new rows created by a connected Google Form, even after a manual sync.
-
A new problem has started: the bot is now assigning “South Korea” leads to the wrong sales team, meaning the IF [Country] = “South Korea” condition is failing.
Troubleshooting Steps Already Taken:
-
Confirmed the bot is enabled and the app is fully deployed.
-
Used the “Test” feature, which shows the trigger condition evaluates to TRUE for the rows that fail to trigger the bot.
-
Corrected all column types (Ref for the salesperson) and ensured formulas return the Key value.
-
Confirmed that editing and re-saving a row from Google Form inside AppSheet still does not trigger the bot.
-
Switched the trigger formula from a series of ORs to the IN(…, LIST(…)) function.
