Hi, is there a way to catch not found error with google sheet. I try to let the user ask questions, search google sheet as a ‘knowledge base’ then return the content. However, in case things are not in the knowledge base, is there a way to catch that not found error?
Catch google sheet not found error
DanielBeckett
(Daniel Beckett)
#2
Unfortunately there’s no way to run any actions based off of an error so the only place you’d find it is in the Interaction Logs.
As a workaround, you could write their message to a separate sheet, search for it in your main sheet and then if a result is found write back to the same row on the separate sheet to mark it as successful. This way you’ll know which search terms aren’t working.