Get predictive scores of all your leads directly in Google Sheets

Rafikah Halim
  • Updated

    Ever wished you could score a list of leads before loading them into your CRM? Or wanted to figure out based on the list of attendees of an event if it was worth sending more reps? This article is for you!

    This article will walk you through the steps to get predictive scores of all your leads directly within Google Sheets. The predictions are based on MadKudu’s customer fit models.

    Scoring leads is as simple as clicking on a button with MadKudu’s Google Sheet add-on.

    You can score both people (with email addresses) or companies (with the domain name).

    Click here to watch a quick demo.

    Customer Fit Prediction

    MadKudu predicts whom you should talk to by scoring leads based on email addresses or domains through customer fit scores.

    Scoring Email Addresses

    1. Select the email addresses that you would like to score
    2. Select Persons
    3. Click on Predict
    4. Predictions will appear next to the email addresses

    Scoring Domains

    1. Select the domains that you would like to score
    2. Select Companies
    3. Click on Predict
    4. Predictions will appear next to the domains

    Note

    Selecting “Insert Headers” will add “customer_fit”, “customer_fit_score”, and "customer_fit_signals" as new column headers on your spreadsheet.

     

    Installing the Add-On

    1. Go to the Google Spreadsheet that you want to use
    2. Click on Add-ons > Get add-ons > Search for and install MadKudu Sheets
    3. Click on Add-ons > MadKudu > Open
      mceclip1.png

    Signing in to the Add-On

    If you don't already have a MadKudu account:

    1. Click on "Create an account"
    2. Go through the signup process
    3. Copy your API key
    4. Return to your sheet, and paste your API key

    If you do already have a MadKudu account, but aren't logged in:

    1. Click on "I have an account"
    2. Log in to your account
    3. Copy your API key
    4. Return to your sheet, and paste your API key

    If you do already have a MadKudu account, and are currently logged in:

    1. Click on "I have an account"
    2. Go to the MadKudu App
    3. Go to Integrations
    4. Click on API
      mceclip0.png
    5. Copy your API key
    6. Return to your sheet, and paste your API key

     

    F.A.Q

    How many emails / domains can I score?

    You can score as many as you’d like. Please pay attention to your API usage to avoid going over your current plan.

    Related articles

    Table of contents