Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Clay Cup

Powered by Tightknit

Using Claygent to Fill Incomplete Address Data Efficiently | Clay

Using Claygent to Fill Incomplete Address Data Efficiently

·Apr 22, 2025 07:18 PM·

If I have a column that has incomplete data, say an address column where coverage is 50%. Question: Can I run claygent to find the address and add the result to the ORIGINAL address column if the field was blank? I dont want to overwrite good data, so can use a only run when original field is blank.

4 comments

· Sorted by Oldest

Channeled
APP
·
·
Yes, you can use Claygent to find and add addresses to your original address column without overwriting existing data. Here's how: 1. Set up a Claygent prompt to search for addresses. 2. Define column outputs in the Claygent pop-out modal. 3. In your prompt, instruct Claygent to output the found address to the 'Address' field. 4. Use a formula to combine the original and Claygent-found addresses: =IF(ISBLANK([Original Address]), [Claygent Address], [Original Address]) This approach will keep existing data and only fill in blank fields. If you need more assistance, you can request human help by clicking on "Talk to a person" in this chat.
Source: Claygent: AI Web Scraper [Clay 101] - Clay University
Edmund C.
·
·
It said I'm creating an infinite loop
Channeled
APP
·
·
To use Claygent to fill in blank address fields without creating an infinite loop, follow these steps: 1. Set up a Claygent prompt specifically for finding addresses. 2. In the Claygent pop-out modal, define the column outputs. 3. Create a new column for the Claygent results, separate from your original address column. 4. In your spreadsheet, use a formula to combine the original and Claygent addresses: =IF(ISBLANK([Original Address]), [Claygent Address], [Original Address]) This approach keeps existing data, only fills blank fields, and avoids infinite loops. If you need more help, you can request human assistance by clicking "Talk to a person" in this chat.
Sources: Claygent: AI Web Scraper [Clay 101] - Clay University Claybooks: Turn Google Maps listings into a target account list with contacts and emails | Clay.com
Channeled
APP
·
·