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.
LinkedIn
Twitter
