Request for Help: AI Column to Compare Buyer Profiles in Spreadsheets

Alexandre M. · 2025-11-01 15:03:24.336466+00

Hello @Clay S. I am trying to build an AI column to achieve the below: “On my spreadsheet “target_accounts”, I have a column /Top Buyer Profiles, which lists the most qualified contacts for a given /domain. I’d like to make a comparison with the contacts on the spreadsheet “target_contacts_clay_new” to see if these are present.” I generated a prompt out of this description, but then it doesn’t work well. Can you please help me solve this case?

Request for Help: AI Column to Compare Buyer Profiles in Spreadsheets | Clay

Clay Support
APP
·
·
To compare contacts between your spreadsheets, use the Use AI column: [1]
1.
In your "target_accounts" table, click Add column → Use AI
2.
Select Content creation, manipulation as your use case
3.
Click Help me and describe: "Compare the contacts in /Top Buyer Profiles with contacts in target_contacts_clay_new spreadsheet to identify matches" [2]
4.
Reference your /Top Buyer Profiles column using "/" in the prompt
5.
Set up output fields to show match results
Alternatively, use Write to Other Table to map data between tables for easier comparison. [3] This allows you to copy columns from one table and match them to appropriate columns in your destination table. [4]
The AI will generate a tailored prompt to help achieve your comparison task.
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you still need help refining your AI column or comparing contacts between your spreadsheets, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific issues you’re encountering?
Alexandre M.
·
·
I don’t have a use case “Content creation, manipulation”
Clay Support
APP
·
·
I'd like to help you set up the comparison between your spreadsheets. Could you describe what you're trying to accomplish with this comparison and what specific issues you're encountering with your current AI column setup? For example, what results are you getting versus what you expected?
Alexandre M.
·
·
I am getting result like this.
Loading attachments
Clay Support
APP
·
·
The "target_contacts_source_unavailable" error indicates your AI column can't access the "target_contacts_clay_new" table for comparison. [1]
This typically happens when the AI column doesn't have proper access to reference the other table. To fix this:
1.
Verify table access: Ensure both tables are in the same workbook
2.
Check table name: Confirm "target_contacts_clay_new" is the exact table name
3.
Use proper referencing: In your AI prompt, reference the table using the correct format
You can click into the specific error cell to see more details about what's causing the access issue.
Alternatively, consider using our "write to table" feature to copy data between tables first, then perform the comparison within a single table for more reliable results. [2]
Clay Support
APP
·
·
Did that answer your question?
Alexandre M.
·
·
Can you please help me create a correct prompt? I am really stuck.
Clay Support
APP
·
·
Here's a prompt structure for your AI column to compare contacts between tables:
#VARIABLES#
{TopBuyerProfiles} = /Top Buyer Profiles
#PROMPT#
Compare the contacts in {TopBuyerProfiles} with contacts from the "target_contacts_clay_new" table. For each contact in the Top Buyer Profiles, check if they exist in the target_contacts_clay_new table by matching on name, email, or company domain. Return "Match Found" if the contact exists in both tables, or "No Match" if not found. [1]
Setup steps:
1.
Add column → Use AI [2]
2.
Select "Content creation, manipulation" as use case [3]
3.
Use the prompt above, referencing your /Top Buyer Profiles column with "/" [4]
4.
Add output field: "Match_Status" (text type)
If you still get the "target_contacts_source_unavailable" error, click into the specific error cell to see more details about what's causing the access issue.
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help creating the correct prompt or resolving the access issue, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific problems you’re facing?
Alexandre M.
·
·
Amazing. I am trying it right now.
Clay Support
APP
·
·
Great to hear that you're trying it now. Please take your time, and if you run into any issues or have more questions, just let me know. I'm here to help.
Alexandre M.
·
·
I am still getting “The data for the target_contacts_clay_new table was not provided, making a comparison impossible, resulting in a 0% match.”

21 comments