Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

CapsuleCRM - Find or create new contact

Z

Hi Community, 

I have a question regarding Capsule CRM and Zapier posibilities. I have a google form where input will be added to CapsuleCRM. But some organisations I work with have one email address used by the whole team (but different first and last names in google form). 

So now, Zapier only checks on email in my case (most safe usually). How to overcome that a new contact with same email address will not be seen as an already existing contact?

I have attached the action. 

Hope some of you recognize my issue! 

Thanks in advance for your support!

David

 

Best answer by Troy Tessalone

@zappedavid

Might be best to start by listing out your different use cases that Zaps will need to handle with conditional logic.

For example

  1. Email = Exists AND Name = Exists
    1. Update Contact (?)
  2. Email = Exists AND Name = New
    1. Create Contact
  3. Email = New
    1. Create Contact

 

You can try structuring this via nested Paths.

  1. Email = Exists
    1. Name = Exists
      1. Update Contact (?)
    2. Name = New
      1. Create Contact
  2. Email = New
    1. Create Contact
View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @zappedavid 

You may have to add some conditional logic to your Zap such as this…

If Find Contact = TRUE, then compare the First Name and Last Name

If Name does not match, then Create Contact in Capsule.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Z
  • zappedavidBeginner
  • Author
  • Beginner
  • 8 replies
  • April 26, 2021

Hi Troy, 

Thank you for your quick reply. Where can I find conditional logic? and where would I need to add it (within the action?).

Thanks again! much appreciated!

David

Troy Tessalone
Forum|alt.badge.img+14

@zappedavid 

You’d have to define the conditional logic then structure your Zap in a way to handles the different use cases.

 

Some Zap app options include…

Filters

Paths

Formatter > Math > Perform Spreadsheet Style Formula

Code (JavaScript or Python)

 

NOTE: It may take a few of these apps to achieve these desired conditional logic within your Zap(s).

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Z
  • zappedavidBeginner
  • Author
  • Beginner
  • 8 replies
  • April 26, 2021

Thank you for your options. 

Since Im a beginner with Zapier I would like to ask what conditions would suit my case?

 

Google form retrieves email address and first and last name into row of spreadsheet. Then within Capsule I check if email already exists → then no new contact. But in this case the team of the organisation uses one e-mail address for all team members. So I need to let capsule know that when email address exists, but when with a name in row of spreadsheet which does not exist, then new contact. 

...well...if you have some ideas how to tackle this one, I have tried filter/paths/formatter (coding will not be a succes!) but I dont see an option to make the condition to check on email address AND name. 

 

Regards,

David

Troy Tessalone
Forum|alt.badge.img+14
  • Troy TessaloneZapier Expert
  • Zapier Expert
  • 31068 replies
  • Answer
  • April 26, 2021

@zappedavid

Might be best to start by listing out your different use cases that Zaps will need to handle with conditional logic.

For example

  1. Email = Exists AND Name = Exists
    1. Update Contact (?)
  2. Email = Exists AND Name = New
    1. Create Contact
  3. Email = New
    1. Create Contact

 

You can try structuring this via nested Paths.

  1. Email = Exists
    1. Name = Exists
      1. Update Contact (?)
    2. Name = New
      1. Create Contact
  2. Email = New
    1. Create Contact
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Z
1 person likes this
  • Z
    zappedavid
Z
  • zappedavidBeginner
  • Author
  • Beginner
  • 8 replies
  • April 26, 2021

PS, I found an addendum :)

Choose false if you want subsequent steps to always be skipped when nothing is found. This is the most common case. The true option is used for greater control with filters and paths. If true, we will consider a "not found" result from this search step as a "success" and will always run subsequent Filter or Paths steps, allowing them to branch on whether or not the search returned a result.

 

So is my thinking correct: so first find emailaddress, then (path step) check again for name and if not true then add contact…?

Z
  • zappedavidBeginner
  • Author
  • Beginner
  • 8 replies
  • April 26, 2021

I'll spend another day at soon! Thanks Troy. Much appreciated! 
Hope I'll get the hang of this Zapier zapping :) its brilliant...once you get it ;)

 

 

Terms & Conditions