Skip to main content
Question

Pipedrive to Sheets, problems with phone numbers & multiple options fields

  • March 26, 2025
  • 1 reply
  • 9 views

Hi! Beginner zappier user here. I’m trying to setup a weekly conversion from pipedrive to google sheets. In pipedrive i have setup a filter showing a select group of deals, that i want displayed in sheets.

 

I have made a zap that does the following:

  1. Schedule by Zapier (triggers once a week)
  2. Webhooks by Zapier (gets the information from the pipedrive filter view. This information includes names, dates, products, product quantities, phone numbers, etc).
  3. Clear spreadsheet rows (clears a spreadsheet of previous information)
  4. Create multiple spreadsheet rows (updates the same spreadsheet with the current information, as acquired from the filter).

Most works well, except for two things.

  1. One column should include a clients phone number. These don’t get split over the column properly, resulting in each row having all of the phone numbers in its cell (still seperated by commas. So +-50 phone numbers per cell in each row).
  2. Some of my pipedrive filtered results are text fields, and some are multiple option fields. The latter fields return a number (some form of option ID?) rather than the text thats in the option itself.

Looking forward to any suggestions for either of my problems! 

Did this topic help you find an answer to your question?

1 reply

JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 2754 replies
  • March 27, 2025

Hi ​@RLG,

 

Welcome to the Zapier community.

 

For your phone number issue, use 'Formatter by Zapier' to split the text using the 'Split Text' transform with a comma as the separator. This will separate numbers into individual fields for mapping in Google Sheets.

 

For the option ID issue in Pipedrive, use a 'Lookup Table' in 'Formatter by Zapier' to map IDs to their corresponding text values. This ensures the correct data is displayed. Let us know if you need further clarification.

 

I hope this helps. If you have any more questions or need further clarification, don't hesitate to ask.


Reply