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:
- Schedule by Zapier (triggers once a week)
- Webhooks by Zapier (gets the information from the pipedrive filter view. This information includes names, dates, products, product quantities, phone numbers, etc).
- Clear spreadsheet rows (clears a spreadsheet of previous information)
- Create multiple spreadsheet rows (updates the same spreadsheet with the current information, as acquired from the filter).
Most works well, except for two things.
- 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).
- 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!
