List Pair Joiner & Cleaner
Whenever a fresh pair of list-building CSVs lands in your Drive folder, this agent matches them by date prefix, joins on the property address, drops deceased records, blank phones, opt-outs, and duplicates, and produces a single REIReply-formatted CSV. It logs every batch in an agent database for dedupe across runs and emails the cleaned link plus attachment to your ops inbox, flagging batches under the row threshold instead of shipping bad data.
Agent snapshot
Built for real estate work, not a generic template.
1
runs observed
1
community clones
3
integrations used
2
labels matched
Sample input
Build an agent to list Pair Joiner & Cleaner. Use Google Drive, Google Sheets, and Gmail. Focus on operations. Return a ready-to-review result after each run.
Sample output
Watches your Drive folder, pairs same-date property and skip-trace CSVs, joins on address, filters deceased/blank/opt-out rows, and emails you a campaign-ready REIReply file.
What this agent automates
This run includes 8 concrete steps from the published agent data.
List the source folder, group files by date prefix, and pick the newest unprocessed pair
Open both CSVs with Sheets, normalize headers, and align on the configured join key
Inner-join the two files; record left-only and right-only counts for the run summary
Apply each configured exclusion filter in order and deduplicate against prior batches in the agent database
Reshape columns to match the selected output platform's expected CSV header
Validate the joined row count against the minimum threshold; halt and notify if below
Integrations used
List Pair Joiner & Cleaner connects Google Drive, Google Sheets, and Gmail.
Google Drive
Connected in this agent
Google Sheets
Connected in this agent
Gmail
Connected in this agent
Clone List Pair Joiner & Cleaner
Start from the exact agent behind this page, then adapt the prompt, apps, and review steps to your real estate workflow.
Plans start at €20/mo