Automation Answers

Why Is My Zapier Search Not Finding the Record?

A Zapier search step misses a record when the lookup value differs in case, spacing, or format, the wrong field is searched, or the record is not indexed yet.

By Automation Ace Editorial Team · Reviewed for technical accuracy by Troy Tessalone · Published · Updated

Short answer

Why Is My Zapier Search Not Finding the Record?

A Zapier search (Find) step usually misses a record that exists for one of four reasons. The value it searches for differs slightly from the stored value. It searches the wrong field or a different account. The app needs an exact match. Or the record was created moments ago and isn't searchable yet. Compare the exact value sent in the run history with the stored value, normalize both, and search on a stable ID or email instead of a name.

Common causes

  • The mapped value has extra spaces, different capitalization, or a different format, such as a phone number with dashes or a date in a different style.
  • The step searches a different field, sheet, table, pipeline, or connected account from the one that holds the record.
  • The app only supports exact matches, so a partial value like a first name never matches the full name.
  • The record was created seconds earlier and the app's search index hasn't caught up.
  • The mapped search value is blank in this run, so the step searches for nothing.

Diagnostic steps

  1. Open the run in Zap history and copy the exact value the search step sent.
  2. Search for that value by hand in the app, using the same account and the same field.
  3. Add a Formatter step before the search to trim spaces, change case, or format phone numbers and dates the same way they are stored.
  4. Search on a stable unique key, such as an email address or record ID, rather than a name.
  5. If records are created right before the search, add a short delay so the app can index them.

Example

A Zap searches a CRM for Jane.Doe@Example.com with a trailing space, but the CRM stores jane.doe@example.com. Adding a Formatter step that trims and lowercases the email lets the search find the contact, which also stops a duplicate from being created.

Caveats

Decide what should happen when nothing is found. You can let the Zap continue, stop it, or use the step's option to create the record if it doesn't exist. When a search could match several records, most apps return only the first one, so search on a unique value.