Skip to main content
Solved

Is there a way to create a report for accounts that don't sync in Salesforce?


ryanne.perry

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?

Best answer by DannyPancratz

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

View original
Did you find this topic helpful?

8 replies

Alistair FIeld
Forum|alt.badge.img+2
  • Helper ⭐️⭐️⭐️
  • 250 replies
  • June 27, 2022

Hi @ryanne.perry 

Thanks for the question.

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

Happy Monday!! 


Alistair FIeld
Forum|alt.badge.img+2
  • Helper ⭐️⭐️⭐️
  • 250 replies
  • June 28, 2022

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


ryanne.perry
  • Author
  • Helper ⭐️
  • 82 replies
  • June 28, 2022

Thanks @Alistair FIeld 

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


DannyPancratz
Forum|alt.badge.img+7
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 962 replies
  • June 28, 2022

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. 


ryanne.perry
  • Author
  • Helper ⭐️
  • 82 replies
  • June 29, 2022

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


DannyPancratz
Forum|alt.badge.img+7
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 962 replies
  • June 30, 2022

@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. [some 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. 

 


DannyPancratz
Forum|alt.badge.img+7
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 962 replies
  • Answer
  • June 30, 2022

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


bas
Forum|alt.badge.img+1
  • Helper ⭐️⭐️⭐️
  • 87 replies
  • July 1, 2022

@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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings