How to Deduplicate WordPress Form Leads in Google Sheets Automatically

Duplicate leads are not just a tidy-data problem. They corrupt the three numbers your team trusts most: total leads, cost per lead, and conversion rate. If a single person submits the same form twice, your reported conversion rate doubles on paper, but your real pipeline does not move.

The waste compounds in three places. First, sales reps call the same person twice, which is the kind of thing that gets your domain marked as spam by an annoyed prospect. Second, your ad platforms optimize against inflated conversion counts, so your bid strategy drifts toward the wrong audience. Third, your CRM enrichment costs scale with rows, not with unique humans, so duplicates literally show up on the invoice.

One mid-market team we worked with audited a year of form data and found 11.4 percent of rows were exact-email duplicates submitted within 24 hours. That is roughly one in nine leads a rep should never have touched. The fix is not exotic, but it does require a deliberate strategy, not a one-time cleanup.

There are three workable patterns for handling duplicates in a Google Sheet. Each has a clear failure mode, so pick based on how your sales team actually consumes the data, not on what looks cleanest in a spreadsheet.

Strategy 1: Flag and keep

Add a duplicate_of column. When a new row matches an existing email within your detection window, write the row anyway and populate duplicate_of with the original row number. Pros: zero data loss, full audit trail, easy to filter out. Cons: your row count keeps growing, and reps must remember to filter.

Strategy 2: Overwrite in place

When a duplicate arrives, update the existing row with the new values instead of appending. Pros: one row per person, always current. Cons: you lose the history of what changed, and concurrent submissions can race. Best for forms where the latest answer is the only one that matters, like a profile-update form.

Strategy 3: Separate dedup tab

Keep the raw Submissions tab append-only and write a clean Unique Leads tab driven by a QUERY or UNIQUE formula. Pros: full raw history plus a sales-ready view. Cons: two tabs to maintain, formula tab can break with schema changes.

For most teams, strategy 3 wins. It separates the system of record from the working view, and that distinction tends to age well.

SheetLink Forms ships with duplicate detection on every submission. It does not require the AI Analytics add-on for the basic case. The mechanism is intentionally simple so it stays fast and predictable.

On submit, SheetLink takes the email field, lowercases it, trims whitespace, and computes a SHA-256 hash. It then checks the analytics log for a matching hash within the configured window. The window is controlled by the sheetlink_analytics_dup_window WordPress option, in seconds, and defaults to 86400, which is 24 hours.

If a match is found, the submission is still written to your sheet, but it is tagged as a duplicate in the analytics dashboard so your reported conversion rate is not inflated. This is the flag-and-keep pattern from the previous section, and it preserves the audit trail without making sales reps reconcile two systems.

To change the window, you can drop a one-liner in your theme's functions.php:

update_option( 'sheetlink_analytics_dup_window', 3600 );

That sets the window to 1 hour. Set it to 0 to disable detection entirely if you have a use case where every submission is a fresh event, like a daily check-in form. Hashing the email instead of storing it raw also keeps the analytics log GDPR-friendlier, since the hash is one-way.

Yes, and for small volumes it is the right call. If you are getting under 200 submissions a month, a formula-driven dedup tab is simpler than any plugin setting and easier to hand off to a non-technical operator. Here are the four formulas that cover 95 percent of cases.

Count duplicates per email

=COUNTIF(B:B, B2) in a helper column flags how many times each email appears. Anything greater than 1 is a duplicate. Filter the column for >1 to see your dupes.

Get a unique-emails list

=UNIQUE(B2:B) in a fresh tab returns one row per distinct email. Combine with ARRAYFORMULA for joining other columns.

Build a clean leads tab with QUERY

=QUERY(Submissions!A:H, "SELECT A, MIN(B), MAX(C) WHERE B IS NOT NULL GROUP BY A", 1) collapses to one row per email, taking the earliest first-seen and latest last-seen timestamp. This is the workhorse for a sales-ready unique-leads view.

Conditional formatting for visual dedup

Format > Conditional formatting > Custom formula =COUNTIF($B$2:$B2, $B2)>1. Highlights the second-and-later occurrence of each email in red, leaving the original clean. Handy for manual review tabs.

The downside of pure formulas is that they recompute on every change, which gets slow past a few thousand rows. If your sheet feels sluggish, that is your cue to move to plugin-side dedup.

Single-form dedup is the easy case. The harder, more valuable case is when the same person fills three different forms - a contact form, a webinar signup, and a pricing-page lead magnet - and you want one row per human in a master Contacts tab.

The pattern is a fan-in: each form writes to its own raw tab, and a single Contacts tab is built by QUERY-ing across all three with a UNION-like construction. Something like =QUERY({Contact!A:D; Webinar!A:D; Pricing!A:D}, "SELECT Col1, MIN(Col2), MAX(Col3) WHERE Col1 IS NOT NULL GROUP BY Col1", 0) collapses by email across all three sources. The first-seen timestamp tells you the original entry point, which is gold for attribution.

For agencies running the plugin across many client sites, cross-site dedup is harder because each WordPress install is a separate database. The Multi-Node Routing add-on lets a central node receive submissions from many client sites and write to a shared agency sheet, where you can dedup once across the whole portfolio. Pair it with the CRM Fan-Out add-on if you want the deduped record pushed onward to HubSpot or Salesforce in a single create-or-update call rather than three separate creates.