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.

Question

Zapier to Pipedrive Error: Expected 'number' as value

  • 9 February 2024
  • 9 replies
  • 59 views
M

TRYING TO ACCOMPLISH: Add a new Lead to Pipedrive when a new row is added to my google sheet.

WHAT IS HAPPENING?:
It seems that the person and organization mapped fields (to Pipedrive) require a numeric value but of course, a person’s name is an alpha value.

Error message reads: "Failed to create a lead in Pipedrive provided dataset is not valid Custom field validation failed. Error: Expected 'number' as value of singleOption field. ApiKey: f3b6d5128b3481383e98a9f07ed7d7c66a35172b"

ADDITIONAL DETAIL: When I leave the "Person" field empty, Zapier tells me it's required. So I fill it in using the only options it accepts which are in the dropdown. These are all alpha values. For some reason, the Person field only accepts numeric values.

See attached image.

 

9 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @mkoptmzcrbn 

Try adding another Zap step to Find Person (enable checkbox to create if not found), then map the returned Person ID.

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
M

Thx Troy!

Not sure if I did this correctly.  The step to Find and/or Create a Person is testing successfully but I’m getting the same error on the step to add to pipedrive.

 

 

M

 

M

Quick video walk through:

https://www.awesomescreenshot.com/video/24820416?key=507522ce1e91f9384c356d02a35796ec

Troy Tessalone
Userlevel 7
Badge +14

@mkoptmzcrbn 

These fields expect IDs from Pipedrive, rather than a GSheet Row ID.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
M

Any idea how I might get a pipedrive ID into this field.

I know in your original comment you said, “then map the returned person’s ID” but I don’t know how to do that.

Troy Tessalone
Userlevel 7
Badge +14

@mkoptmzcrbn

In step 2 you would need to search by a column value from GSheets that a Pipedrive person has. (e.g. email)

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
M

these are new leads so no pipedrive person exists…  or are you saying that the “person” represents like an existing employee?  
If so, I don’t understand since we checked the option to “create if not found”
Sorry, I’m confused...

Troy Tessalone
Userlevel 7
Badge +14

@mkoptmzcrbn 

Try adding another Zap step to Find Person (enable checkbox to create if not found), then map the returned Person ID.

 

You probably want to search by email address.

 

You probably want to select an option from the dropdown list.

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor

Reply


Terms & Conditions