Best practices for comparing outbound list (sent outside Pipedrive) with Pipedrive 

pipedrive_questions
pipedrive_questions Member Posts: 9 VERIFIED MEMBER
Photogenic Name Dropper First Comment
edited May 17 in Sales CRM #1

Hi everyone, we have ca. 100K companies in our CRM and would like to check from an outbound list which leads might already be customers or prospects. We have several ideas, but they don’t seem like best practices yet - maybe you can advise a better workflow:

  1. Exporting Pipedrive deals through Coupler to Google Sheet and then running different index match formulas to spot overlaps. This often crashes for the 100,000 records.
  2. Calling a Zapier Zap (e.g. from Google Sheet) to look up the value with a custom API call from Zapier. This is tedious and costs a lot of Zap tasks.
  3. Using Google Sheet app scripts. Here it is a challenge, how we can build a scalable workflow that does not hit Pipedrive’s usage limits. Manually dragging down formulas for many cells and waiting is one approach, but not efficient and can fail due to several reasons.
  4. Using Clay and lookup person / deal, but I currently face some difficulties with that approach as the matched results do not make sense and I sometimes seem to hit the Pipedrive API rate limit.

Thus, I would be very curious if you can help point to a more effective workflow for checking a list of leads against our existing Pipedrive data.

Thanks a lot in advance!

Tagged:

Answers

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,618 VERIFIED MEMBER
    1000 Comments 250 Likes Fourth Anniversary 25 Answers
    1. Coupler is a good option but will work if it is only a one-time process.
    2. The cost for using Make/Integromat or Zapier or Relay will be based on how many leads you need to check in your outbound process. A 'search' step will remove the existing number of contacts inside Pipedrive as a factor.
    3. Pretty much a combination of 1 and 2 without the use of Make/Integromat or Zapier or Relay.
    4. Clay now has OAuth based connection with Pipedrive that allows for higher rate limits.

  • pipedrive_questions
    pipedrive_questions Member Posts: 9 VERIFIED MEMBER
    Photogenic Name Dropper First Comment

    Thanks @Amit Sarda (AmitSarda.xyz)!

    I am still looking for the most effective set-up, do you possibly have another idea?

    Also, have you ever set up a custom HTTP action in Clay to search Pipedrive deals? I was struggling to do so.

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,618 VERIFIED MEMBER
    1000 Comments 250 Likes Fourth Anniversary 25 Answers

    Send me a screen recording of where you're struggling.

  • pipedrive_questions
    pipedrive_questions Member Posts: 9 VERIFIED MEMBER
    Photogenic Name Dropper First Comment

    I believe that the endpoint URL might be incorrect? Currently, it seems that any entry returns a 200 return code with such a list of items / deals as you can see on the screenshots attached:

  • Josh Monifi
    Josh Monifi Member Posts: 133 VERIFIED MEMBER
    250 Up Votes Fourth Anniversary 25 Likes 10 Comments

    Also came here looking for a tool to easily compare an external list with what we already have in Pipedrive.

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,618 VERIFIED MEMBER
    1000 Comments 250 Likes Fourth Anniversary 25 Answers

    Orchestrating the campaign in Clay may be your best bet. You can have direct integrations with Pipedrive, or via API calls to see if a particular email already exists in Pipedrive.