Creating a Waterfall Flow with Lookup for Multiple Rows in Sheets

Jasper T. · 2025-08-04T10:45:50.252Z

Hi Clay Team, I am wanting to create Waterfall Flow with Lookup for Multiple Rows in Tables between my new hire sheet and main sheet. i am using the company name as the row value to cross reference between the two sheets (the company name column in both sheets have been produced using the ai enrichment process and source domain). I am unable to select any output, and hence, unable to avoid a 'missing attribute path' error message despite the fact both columns contain the same company names. any help would be appreciated

Creating a Waterfall Flow with Lookup for Multiple Rows in Sheets | Clay

10 comments

· Sorted by Oldest

Abdul S.
·
·
Hey Jasper T. that error usually means the field you're trying to pull doesn't exist yet at that step. A few quick things to check: Click the output bubble after the lookup to see if data is showing Use if it's pulling multiple rows Make sure both sheets have the enriched data before the lookup runs
Jasper T.
·
·
Hi, thank you for your response, there doesnt seem to be any data showing in the output bubble at any stage of filling in the setup inputs, both before or after
Jasper T.
·
·
i also made sure each column was in plain text and that specific company names matched exactly before testing this stage out
Abdul S.
·
·
Got it if there’s no data in the output bubble at all, it likely means the lookup isn’t connecting properly double check: the matching field is the same format in both tables (like domain vs full URL) The lookup is pulling from the correct table/view That the source table has data in the lookup field at that step If everything looks right and still no output try running the lookup on just a few rows to test lmk what you're seeing and I can help debug further!
Jasper T.
·
·
hi, the domain used to enrich and source the company name for both sheets is the same. Also i changed the name of the new hire sheet slightly to see if it would update on the lookup multiple rows section, and it did so successfully. also both tables have complete data in all the rows of the columns i am trying to 'target'/use as 'row value'. I am also confident that there are values which do match up in their exact format (case, spacing, etc).
1
Jasper T.
·
·
And it still doesnt seem to offer any output properties
1
Sourabh
·
·
Hey Jasper! You're doing all the right checks already. A couple of things to try that have helped us in similar cases:
Try simplifying the row value temporarily—use plain domains (like example.com) instead of enriched names. Sometimes enriched values look identical but contain hidden formatting or whitespace issues.
Double-check that:
You’re referencing the correct view in the Lookup step (not just the table).
The source table’s view has the field you're trying to pull selected and visible.
You apply a test filter (e.g., match just “Acme Inc”) to confirm it's connecting properly.
Also, try running the lookup on just a few rows to isolate issues.
I’ve seen a lot of teams run into quirks like this while scaling Clay setups, so if you’re ever looking for an extra set of hands—my team and I specialize in exactly this: Clay workflows, GTM automation, and getting data pipelines right the first time. Happy to take a look in more detail if you need a deeper fix. Let me know how it goes!
Clay
APP
·
·
Since you've verified matching data and formats, try these additional troubleshooting steps: Check Formula Logic: ** Ensure your lookup formula includes conditional logic like "if {{response}} exists..." to handle cases where no match is found Refresh Dependencies: ** Try rerunning the lookup column to refresh the connection between tables Test with Minimal Data: ** Create a test view with just 2-3 rows that you know match exactly ** Run the lookup on this smaller dataset first Verify Column Dependencies: ** Confirm the enriched company name columns completed successfully before the lookup runs ** Check that both tables show the same exact values (no hidden characters or formatting differences) If these steps don't resolve the issue and you still see no output properties, you may need to request human assistance by clicking "Talk to a person" for deeper debugging of your specific table setup.
Source: Enrich People (Waterfalls) [CRM Enrichment] - Clay University
Jasper T.
·
·
thank you Sourabh and Clay for your replies, will try out each of these steps.
Channeled
APP
·
·

Abdul S.
·
·
Hey Jasper T. that error usually means the field you're trying to pull doesn't exist yet at that step. A few quick things to check: Click the output bubble after the lookup to see if data is showing Use if it's pulling multiple rows Make sure both sheets have the enriched data before the lookup runs
Jasper T.
·
·
Hi, thank you for your response, there doesnt seem to be any data showing in the output bubble at any stage of filling in the setup inputs, both before or after
Jasper T.
·
·
i also made sure each column was in plain text and that specific company names matched exactly before testing this stage out
Abdul S.
·
·
Got it if there’s no data in the output bubble at all, it likely means the lookup isn’t connecting properly double check: the matching field is the same format in both tables (like domain vs full URL) The lookup is pulling from the correct table/view That the source table has data in the lookup field at that step If everything looks right and still no output try running the lookup on just a few rows to test lmk what you're seeing and I can help debug further!
Jasper T.
·
·
hi, the domain used to enrich and source the company name for both sheets is the same. Also i changed the name of the new hire sheet slightly to see if it would update on the lookup multiple rows section, and it did so successfully. also both tables have complete data in all the rows of the columns i am trying to 'target'/use as 'row value'. I am also confident that there are values which do match up in their exact format (case, spacing, etc).
1
Jasper T.
·
·
And it still doesnt seem to offer any output properties
1
Sourabh
·
·
Hey Jasper! You're doing all the right checks already. A couple of things to try that have helped us in similar cases:
Try simplifying the row value temporarily—use plain domains (like example.com) instead of enriched names. Sometimes enriched values look identical but contain hidden formatting or whitespace issues.
Double-check that:
You’re referencing the correct view in the Lookup step (not just the table).
The source table’s view has the field you're trying to pull selected and visible.
You apply a test filter (e.g., match just “Acme Inc”) to confirm it's connecting properly.
Also, try running the lookup on just a few rows to isolate issues.
I’ve seen a lot of teams run into quirks like this while scaling Clay setups, so if you’re ever looking for an extra set of hands—my team and I specialize in exactly this: Clay workflows, GTM automation, and getting data pipelines right the first time. Happy to take a look in more detail if you need a deeper fix. Let me know how it goes!
Clay
APP
·
·
Since you've verified matching data and formats, try these additional troubleshooting steps: Check Formula Logic: ** Ensure your lookup formula includes conditional logic like "if {{response}} exists..." to handle cases where no match is found Refresh Dependencies: ** Try rerunning the lookup column to refresh the connection between tables Test with Minimal Data: ** Create a test view with just 2-3 rows that you know match exactly ** Run the lookup on this smaller dataset first Verify Column Dependencies: ** Confirm the enriched company name columns completed successfully before the lookup runs ** Check that both tables show the same exact values (no hidden characters or formatting differences) If these steps don't resolve the issue and you still see no output properties, you may need to request human assistance by clicking "Talk to a person" for deeper debugging of your specific table setup.
Source: Enrich People (Waterfalls) [CRM Enrichment] - Clay University
Jasper T.
·
·
thank you Sourabh and Clay for your replies, will try out each of these steps.
Channeled
APP
·
·