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
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?