Anyone have a good GPT prompt to to flag email addresses and Linkedin profiles as questionable (in need of a manual check) if the name of the contact and/or organization doesn’t match the email address or slug of the linkedin?
Hey, thanks for reaching out! You can achieve this by using Formulasto check for mismatches and it's free. For example, you could create a new formula column with a prompt like: “Does the /domain of the email match the root /domain of the organization? Fuzzy matching can also be applied for slight variations." You would reference columns with forward slash. This way, you can flag any emails or LinkedIn profiles that don’t align with the contact name or organization for a manual check. Let me know if you need help setting this up! 😊 P.S If you still want to use ChatGPT open "USE AI" enrichment found in the enrichment panel by clicking the "add enrichment" button at the top right of the page and then use the "help me button" for prompt. https://downloads.intercomcdn.com/i/o/w28k1kwz/1225260113/bd10af5441cabd0216b8f4c82a84/557df95a-d749-4b3c-84dd-742cb958cfb5?expires=1729631700&signature=6f03b41cc1f1c96fb0fffeb9684142b2910f458b8d73efd8087a5a68ee482085&req=dSIlE8t4nYBeWvMW1HO4zZjkg9k9IA5VX3bkp2oP3hjciYiq%2Fye2wo4QgWSW%0A20KU%0A
Sweet. Will try this.