Get predictive score of all your leads directly in Google Sheets

  • Updated on Feb 20, 2025
  • Published on Oct 9, 2024
  • 1 minute(s) read
Prev Next

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.
To check you API limits and usage, go to Settings > API Usage


Related articles