CONTACT DATA QUALITY · Workflow idea
For a records owner with authority over both sources, compare contact rows using a verified email address and prepare an update when a matching record exists or a new record when it does not. Contact data is personal information, and an email match can still be ambiguous or outdated. Confirm the purpose and permissions for both systems, preserve existing preferences, flag conflicts instead of overwriting them, and require the data owner to approve changes before they are applied.
01 / The starting point
An authorized source sheet, an approved destination table, and a documented matching rule
“Identify likely matches and proposed changes while preserving contact preferences and record history.”
02 / The work
Compares contact rows by email, updates a matching destination record, or prepares a new record when no match is found.
Check that the requester may read and update each selected contact record.
Check normalized addresses and flag shared, blank, or conflicting email values.
Show exactly which values are new, changed, or missing before any write.
Do not replace unsubscribe, contact, or correction choices with stale sheet data.
Require the data owner to confirm each match, destination, and field change.
03 / The result
A duplicate-checked change list with source references and owner approval status.
Reviews & approvals · Example outcome
A duplicate-checked change list with source references and owner approval status.
A stale or shared email address can match the wrong person, and an update may replace valid preferences. Review ambiguous matches, preserve history, and require approval for live writes.
04 / Make it yours
A few choices shape the work around your team.
Limit connected accounts to the approved fields and destination table.
Prefer a stable unique key and stop when records cannot be distinguished safely.
Record source row, target record, changed fields, and reviewer.
Use a copy first and require an owner to approve each production update.
Keep exploring
Check authorized business contact addresses against defined validity signals and prepare a review list of uncertain or invalid records. Keep source details accurate, information appropriately private, and consequential next steps under human review.
A task-framed guide to general business email address checks, with checks for privacy, source accuracy, and approval before consequential steps.
A task-framed guide to business details proposed for new contact records, with checks for privacy, source accuracy, and approval before consequential steps.