Clay Icon

Guidance Needed for Workflow: Importing Contacts to Campaigns from Tables

ยท
ยท

Hi Team! I am trying to implement the following workflow and would appreciate your guidance:

  1. 1.

    I have a table of companies (Table X) and a table of contacts (Table Y).

  2. 2.

    In Table X, I use the Lookup Multiple Rows in Other Table function to display related contacts from Table Y in a specific column (let's call it Column 1).

  3. 3.

    My goal is to use the Instantly โ†’ Add Lead to Campaign enrichment feature to import contacts from Column 1, but only for a subset of companies in Table X that match specific filter criteria.

Could you please advise on the best way to achieve this? Are there alternative approaches to handle this use case efficiently?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    You can use conditional formulas in the Instantly enrichment to selectively add leads to your campaign. Here's how:1. Add the "Instantly โ†’ Add Lead to Campaign" enrichment to your table. 2. In the enrichment settings: โ€ข Select your campaign ID โ€ข Map the required email field and any optional fields (first name, last name, company name) โ€ข Add any custom variables for personalization 3. Scroll down to "Run Settings" in the enrichment panel to set up your conditional formula. You can either: โ€ข Type your condition manually, or โ€ข Click "Use AI" and describe your filter criteria in plain language (e.g., "Only run if /headcount is greater than 40")Make sure to use the correct column names from your table when setting up the enrichment to avoid any "missing input" errors. Sources: Conditional Formulas Add Lead to Campaign with Instantly Push Data To Your Email Sequencer [Clay 101] - Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.