About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

  • Home
  • Get Help
  • Troubleshooting
  • Error: Failed to create a contact in Salesforce Could not create record of the "Contact" object: Primary Affiliation: id value of incorrect type: None
Question

Error: Failed to create a contact in Salesforce Could not create record of the "Contact" object: Primary Affiliation: id value of incorrect type: None

  • 19 October 2022
  • 2 replies
  • 105 views
B

Hi there,

 

I’m flummoxed and hoping someone can help. I’m trying to connect a Google Sheet that collects newsletter sign up information to Salesforce, however I get this message:

 

Failed to create a contact in Salesforce

Could not create record of the "Contact" object: Primary Affiliation: id value of incorrect type: None

Troubleshoot error

 

In our Salesforce, Primary affiliation field is required. I have set up an extra Zap step to search for the primary affiliation given in the Google sheet  in Salesforce , and if it doesn’t find one, to create a new account (i.e. primary affiliation for the person who has just signed up to the newsletter). 

 

I’m really stuck - any advise? 

 

Much appreciated,

Becky

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @BeckyT 

Good question.

Please post detailed screenshots with how your Zap steps are configured in order for us to have more context, thanks.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
jesse
Userlevel 7
Badge +9

Hey @BeckyT! Just checking in here. As Troy mentioned, having some screenshots of your Zap steps would be helpful in navigating some troubleshooting around this.

Alternatively, something to consider is that if you’re testing the Zap when getting that error, you might be navigating some outdated/incomplete test data within your Zap. If you skip all tests, turn the Zap on, and trigger your Zap with brand new data, does the error still persist? If so, seeing those screenshots will be necessary for us to continue troubleshooting this one.

Keep us posted - we want to make sure you’re able to get up and running here!

Terms & Conditions