Zapier – Action – Find User By Email

In some instances, you may need to determine if an email address is already in use before you can take different additional actions.

Zapier has a function that will allow you to search a record before proceeding with an action.

Step 1

After creating a trigger in Zapier (Example: Adding a new contact to your CRM of choice or to a Google Spreadsheet), you will need to create an action.

Look for LightSpeed VT and choose as your app

For Action Event, scroll down to the Search section and choose Find Email and click Continue after selecting.

On the resulting screen, choose your connected LightSpeed VT account and click Continue. (If you do not have an account already, follow the instructions here).

Step 2

You can now set up your search action.

Choose the matching email field from the trigger you set up earlier, by clicking the Email field.

If an email address doesn’t exist in our database, the search result will indicate that nothing is found.

Should this step be considered a “success” when nothing is found? This setting allows you to control additional actions/filters/paths based on the finding.

The default is set to False, but you will need to consider the rest of your flow before selecting False or True.

You would only need to specify if you intend to use additional actions. (For example, you may want to send an email using Gmail to a manager if an email was not found.)

False: If an email address is not in use in our system (Nothing found), choosing False in this case will stop the zap and no actions will be taken.

True: Choose this option to allow the zap to continue with additional actions/filters/paths that you will add later if nothing is found (Email address is not used in our system).

Click Continue to test your action.

Step 3

Zapier will provide you with 2 different messages which will also be depending on the chosen False/True settings from the earlier step.

False
If an email address is not found, the False option will consider the operation unsuccessful and return this error message:

This will stop further actions from happening.

If an email address is found, it will return this message:

There will be additional data that can be used in further actions.

• available: false (Email address is in use in one or more accounts)
• userId: 123445 (UserId of last registered account with the specified email address)
• email: email@website.com (Email address of last registered account with the specified email address)
• locationId: 12345 (Location ID of last registered account with the specified email address)
• vendorId: xyz123 (Vendor reference ID of last registered account with the specified email address)
• _zap_search_was_found_status: true (The submitted email address was found in our DB)

True
If an email address is not found, the True option will assert the operation as successful and return this message:

There will be 1 additional piece of data that can be used in further actions.

• _zap_search_was_found_status: false (The submitted email address was not found in our DB)

If an email address is found, it will return this message:

There will be additional data that can be used in further actions.

• available: false (Email address is in use in one or more accounts)
• userId: 123445 (UserId of last registered account with the specified email address)
• email: email@website.com (Email address of last registered account with the specified email address)
• locationId: 12345 (Location ID of last registered account with the specified email address)
• vendorId: xyz123 (Vendor reference ID of last registered account with the specified email address)
• _zap_search_was_found_status: true (The submitted email address was found in our DB)

Because True was selected, even though the proposed email address is in use, the zap will be allowed to continue and will not be marked as an error.