馃憢 - have a set of about 2500 records with a referring provider (medical professional name) with state and city. Would welcome guidance on best/fastest way to look at these 3 fields to match to a website and ultimately contact information
Hey hey! Can you drop the URL for your table here? (if applicable) 馃 Don't worry, only admins will be able to open your table 馃槈
Hey Joe - happy to help here. It looks like you used the Google Search option which may be a good bet here. From the search results column, you can add the URL as another column

You could create a formula column called Included_States. E.g. Where state is equal to {state names} then TRUE, else FALSE. Then you can filter on the Included_States for any matching TRUE.
Thats probably what I'd recommend, thanks John!
MASSIVE - thank you lads 馃槃
You're welcome Joe!
Hi John P. + George D. - been working through this list. A lot of the contact information is not accurate. What is the best workflow to sift through the 5 returned results from google and identify the one most similar to the medical space? (table here)
am thinking of looking at the 5 returned results and pulling all emails and numbers affiliated with those 5 results
Hey Joe, there is an integration that helps us filter a list of results like those, select a field to filter by like the "snippet" and based on keywords that may be included there and you think would help. Here's a video about that: https://www.loom.com/share/5a648ca690c645c8a19261af0630aeaf?sid=4745d7c9-6e13-426c-841c-30516699bde9
Otherwise, if you need a more in-depth analysis than just keywords, I'd probably ask AI (chatGPT or Claude) to determine this for you based on a bit more complex conditions you may have in mind.