Clay Icon

Extracting Contacts and Filtering CEO/Founders Emails from Table

·
·

Is there any way to extract the data from 'Find contacts at company' (highlighted) in this table or in a separate table? Somehow, this time I decided to get the emails on this table, plus any suggestions to filter the data like (CEO,s and founders only)

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To extract data from 'Find contacts at company', get emails, and filter for CEOs and founders: 1. Use "Find people at these companies" in the Actions menu. 2. Set search parameters for CEOs and founders. 3. Choose "Save to new table" to create a separate table with results. 4. In the new table, use "Enrich Person From Apollo" to get emails. 5. Use our "write to table" feature to combine data if needed. This process will give you a filtered list of CEOs and founders with their email addresses.

    Source: [FAQ: Why am I seeing email_not_unlocked@domain.com in Apollo?](https://docs.clay.com/en/articles/9757360-faq-why-am-i-seeing-email%5Fnot%5Funlocked-domain-com-in-apollo)

  • Avatar of Mujahid A.
    Mujahid A.
    ·
    ·

    Can you tell 'How to use write to table' feature?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To use the "write to table" feature in Clay: 1. Click "Add Enrichment" and select "Write to Table". 2. Choose a destination table within your workbook. 3. Select the data to transfer: • For lists: Choose the column with lists to map. • For single values: Enter "/" to skip list selection. 4. Map the data: • For lists: Select list properties to map to new table columns. • For single values: Match source columns to destination columns. 5. (Optional) Configure run settings like auto-update. This process allows you to transfer data between tables, break down lists into individual rows, or mirror column data from one table to another.

  • Avatar of Mujahid A.
    Mujahid A.
    ·
    ·

    future conversation will be under the same thread?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Yes, future conversations and follow-up questions will typically remain under the same thread in Clay Support. This helps maintain context and continuity in your support experience. If you need further assistance or have more questions, you can continue the conversation in this thread. For complex issues or if you feel you need more direct help, you can request to talk to a human agent within this conversation.

  • Avatar of Mujahid A.
    Mujahid A.
    ·
    ·

    I have learnt how to use 'write to table' thanks to you... Now, using 'write to table' I sent 'work email' and 'Job title' from the find people to the find company table. The data got transferred (10 rows) but its not sorted. For example, the related email adjacent to related company name to name to title... Instead its unsorted Here's the screenshot as well what Im trying to say is there are 100 rows in company data and I only enriched 10 emails, 10 titles so I want them sorted

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To sort and align the transferred 'work email' and 'Job title' data in your company table: 1. Click "Filter" above the table. 2. Select the column with company names. 3. Choose "is not empty" to show only rows with company data. 4. Sort the table by company name to group related data. You can also merge columns to combine information: 1. Click "Add Column" > "Merge columns". 2. Use a formula to combine company name, work email, and job title. This approach will help align the subset of enriched data with the correct companies. If you need more specific assistance, please provide a screenshot of your current table layout.