Search for an Email Across All Tables in Your Database

Yes, you can search for a specific email across your Clay tables using our Lookup integration. Use the Lookup Single Row in Other Table feature to check if a specific email exists in another table. This integration allows you to look up a single row in another Clay table and verify the existence of specific data across different tables within your workspace. If you need to check multiple rows at once, the Lookup Multiple Rows in Other Table option is also available.

Source: Lookup Single Row in Other Table with Clay