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?
To compare contacts between your spreadsheets, use the Use AI column: [1]
In your "target_accounts" table, click Add column → Use AI
Select Content creation, manipulation as your use case
Click Help me and describe: "Compare the contacts in /Top Buyer Profiles with contacts in target_contacts_clay_new spreadsheet to identify matches" [2]
Reference your /Top Buyer Profiles column using "/" in the prompt
Set up output fields to show match results
The AI will generate a tailored prompt to help achieve your comparison task.
Was that helpful?
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?
I don’t have a use case “Content creation, manipulation”
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?
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:
Verify table access: Ensure both tables are in the same workbook
Check table name: Confirm "target_contacts_clay_new" is the exact table name
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]
Did that answer your question?
Can you please help me create a correct prompt? I am really stuck.
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:
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.
Is that what you were looking for?
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?
Amazing. I am trying it right now.
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.
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.”
