I’m trying out the new Chatbot feature. I have two chatbots. One of them works great. And the other one doesn’t work, but I feel like it should. I work with a school. The school has an unofficial carpool program where parents fill out a carpool form to be added to the carpool database. The database contains the parent’s name, student’s name, home address, the campus the student goes to (there are five), and latitude and longitude coordinates to go along with the home address. All of this information is in a Google Sheet that syncs with a Zapier Table. When someone opens up the chatbot they are prompted to enter their home address, followed by the campus the student goes to. What’s supposed to happen is the chatbot will look through the Zapier table to find any parent addresses that are within 5 miles of the address the parent just entered AND goes to the same school that the parent just entered (both criteria are important). I have very clear directive instructions that include what the chatbot response should be if there are any matches or aren’t any matches. If there are matches, it should return the parent name, student name, address, distance (this is the distance from the address the parent entered into the chatbot and the match in the database), and a Google Maps link to the match’s address. What I’m finding is that it will return results, but they are never correct. It might pull someone’s information from the Zapier Table but the address will be 25 miles from the address the parent entered into the chatbot. My question is there a way to get a Zapier Chatbot to accurately figure out the locations of each person in the Zapier Table and then figure out the distances from those points to the address the parent entered and then filter by the school? I tried doing this with ChatGPT 4o and it worked. So I know the GPT 4o model can do it. Is it possible Zapier has some sort of limitation that is preventing it from accurately making this calculation?