Troubleshooting Lookup Issues for Gong Call Transcripts Aggregation

Angus M. · 2025-11-28T03:57:14.743Z

I have a main table full of Opportunities from SFDC. I have send to another table each related gong call to these opportunities with the transcripts. On the Opportunities table I want to aggregate all the gong call transcripts by each OpportunityId. When I use the Lookup multiple rows, I cannot select any tables at all. Why is this?

Troubleshooting Lookup Issues for Gong Call Transcripts Aggregation | Clay

10 comments

· Sorted by Oldest

Clay Support
APP
·
·
The Lookup Multiple Rows action requires you to specify the Table to Search as the first input. If you can't select any tables, this typically means:
• The tables aren't in the same workspace
• There's a connection issue with your workspace
• The target table with Gong transcripts hasn't been properly created
Make sure both your Opportunities table and Gong calls table are in the same Clay workspace. The lookup will search your Gong calls table using OpportunityId as the Target Column to match and return multiple transcript rows.
Clay Support
APP
·
·
Is that what you were looking for?
Angus M.
·
·
The table does exist, and the transcripts exist, so I am not sure why I cannot select a table at all
Clay Support
APP
·
·
That's frustrating—let me help troubleshoot this. If you can't select any tables in Lookup Multiple Rows, check these potential causes:
• Workspace row limit: You might be at or near your workspace's total row limit. This can prevent table operations from working properly.
• Write to Other Table constraints: There's a maximum of 10 tables that can be connected via Write to Other Table across workbooks. If you've hit this limit, it could affect lookup functionality.
Try checking your workspace usage from the home page to see if you're approaching the row limit. If so, you'll need to delete unused tables from the Trash folder to free up space.
Clay Support
APP
·
·
Did that answer your question?
Angus M.
·
·
No
Clay Support
APP
·
·
I'm connecting you to one of our human agents who can assist you further with this issue.
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon! We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
image.png(93 kB)
Abdul S.
·
·
Hey Angus M. OpportunityId is the unique id for each opportunity. to get all gong call transcripts for each opportunity, you match rows in the gong calls table using OpportunityId. then you can combine all transcripts for that opportunity in your main table.
Angus M.
·
·
The issue is when looking up from the Opp table to the Calls table, theres no option for me to select a table from the dropdown

Clay Support
APP
·
·
The Lookup Multiple Rows action requires you to specify the Table to Search as the first input. If you can't select any tables, this typically means:
• The tables aren't in the same workspace
• There's a connection issue with your workspace
• The target table with Gong transcripts hasn't been properly created
Make sure both your Opportunities table and Gong calls table are in the same Clay workspace. The lookup will search your Gong calls table using OpportunityId as the Target Column to match and return multiple transcript rows.
Clay Support
APP
·
·
Is that what you were looking for?
Angus M.
·
·
The table does exist, and the transcripts exist, so I am not sure why I cannot select a table at all
Clay Support
APP
·
·
That's frustrating—let me help troubleshoot this. If you can't select any tables in Lookup Multiple Rows, check these potential causes:
• Workspace row limit: You might be at or near your workspace's total row limit. This can prevent table operations from working properly.
• Write to Other Table constraints: There's a maximum of 10 tables that can be connected via Write to Other Table across workbooks. If you've hit this limit, it could affect lookup functionality.
Try checking your workspace usage from the home page to see if you're approaching the row limit. If so, you'll need to delete unused tables from the Trash folder to free up space.
Clay Support
APP
·
·
Did that answer your question?
Angus M.
·
·
No
Clay Support
APP
·
·
I'm connecting you to one of our human agents who can assist you further with this issue.
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon! We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
image.png(93 kB)
Abdul S.
·
·
Hey Angus M. OpportunityId is the unique id for each opportunity. to get all gong call transcripts for each opportunity, you match rows in the gong calls table using OpportunityId. then you can combine all transcripts for that opportunity in your main table.
Angus M.
·
·
The issue is when looking up from the Opp table to the Calls table, theres no option for me to select a table from the dropdown