This issue might be occurring due to inconsistencies in how company names are formatted between your sheets. Company names often contain variations with legal suffixes, prefixes, or different formatting that can prevent exact matches. Here are two steps to resolve this: 1. First, try using the "Normalize Company Names" tool in Clay:
• Go to the enrichment panel's "Tools" section
• Select "Normalize Company Names"
• Apply it to your company name columns
• This will remove suffixes like "Inc." and standardize the formatting
2. When setting up the Lookup Row action:
• Make sure you've selected the correct Sheet ID
• Verify that the Lookup Column name exactly matches your Google Sheet's column header
• Confirm that the Lookup Value from your Clay table matches the format in your Google SheetIf the issue persists after normalizing the company names and verifying the setup, you may want to manually check a few examples to identify any remaining formatting differences between the two sources.
Sources:Google Sheets integration overview | Documentation | Clay UniversityData Cleaning + Normalization [Clay 101] - Clay University
Looks like you're still looking for help. 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!
.png){kind=logo}
