Optimizing AI API Usage for Unique Company Phone Number Retrieval
Hi everyone -- I have a Find People Table where many of the contacts belong to the same companies. I'm trying to run the Claygent (AI Web Researcher) template that uses the following prompt:
Visit the website of the following company: /Company Domain and find a phone number to contact them. You might have to look at the footer or on the "Contact", "Support" or other relevant pages on website. If you are unable to find a phone number on the website, try looking at other sources on the web & Google. If a phone number is found, return just the phone number and nothing else. Otherwise, just return: "Not Found".
Because there are multiple people belonging to the same company, I only want the AI Web Researcher column to run on the first unique value of /Company Domain. The goal is to only using the AI API to find phone numbers from each unique website, rather than it running on the same website multiple times. I am trying to use the "Only Run If" formula to make this work, but even using Use AI I am unable to get a formula that allows this. Anyone experience something similar? I can't imagine I'm the only one who only wants to use API credits when necessary and not have duplicative work ๐