Skip to main content

Hi all -

It appears some of our users accounts are not syncing with Salesforce. I am thinking it is because of one of the following reasons - 

  1. They aren’t using the email associated with SF
  2. They aren’t a contact in Salesforce
  3. They have an updated email address and we should update in Salesforce

For whatever the reason we’d like to be able to run a report that captures who is not syncing to Salesforce so we can use that data to update records, etc.

Is this possible?

Hi @ryanne.perry 

Thanks for the question.

I am asking around internally if there is anything we can suggest.

Happy Monday!! 


Hi @ryanne.perry 

Speaking with our engineers, I am sorry to say this is currently NOT feasible.

I encourage you to create an idea as I am sure this would be a good addition to the capability.

 

Alistair


Thanks @Alistair FIeld 

I put this Idea in - did I enter in the right area, Analytics and Reporting? Or should it be integrations?


Hi, @ryanne.perry we setup a Zapier automation to create a new Salesforce contact when it doesn’t exist.

That way, we get very close to 100% match and the SFDC data is accurate for us to build reports and dashboards off of. 

But I like your idea and voted for it. Hopefully the suggestion above helps you get to a long term fix, but I’m not quite sure how to address those that have previously not synced. 


Thanks @DannyPancratz! Is there a ‘how-to’ instructions for the Zapier automation to create a new Salesforce contact when it doesn’t exist?


@ryanne.perry I have a question out to my team for more details on how we did this, but I’m pretty sure we leverage this Zapier action for Salesforce

https://zapier.com/apps/salesforce/integrations

 

I’m not 100% positive, but I believe our trigger is the New Contact zapier trigger from Insided

https://zapier.com/apps/insided/integrations

 

The tricky part is the in between, but the overall Zap is probably something like: 

  1. New User (Insided Trigger)
  2. Find Record (Salesforce Action)
  3. lsome type of filtering for only go forward if record is not found / blank]
  4. Create Contact (Salesforce Action) based on data provided from step 1

As I type that out, I see that there’s a Salesforce App that might consolidate steps 2-4. But I haven’t used it personally and I’m waiting to hear back from our team on our actual setup. 

 


Confirmed

That’s exactly what we ended up doing - we basically have a zap that checks to see if a contact record exists in SFDC with the same email address.  If it exists, we do nothing - if it doesn’t exist we create the contact using the details from the insided user record


@DannyPancratz is 100% correct :-)
 

We always link to this post that answers these questions: https://community.insided.com/got%2Da%2Dquestion%2D38/create%2Da%2Dzap%2Dto%2Dfind%2Dadd%2Dsfdc%2Dcontacts%2Dwhen%2Dnew%2Dmembers%2Djoin%2D3851?postid=18551#post18551

 

I’ll see if I can take some time in the near future to turn it into a cleaner article, which also explains what additional steps you could take inbetween.

Cheers,
Bas


Reply