---
title: "Get predictive score of all your leads directly in Google Sheets"
slug: "get-predictive-score-of-all-your-leads-directly-in-google-sheets"
updated: 2025-02-20T13:27:16Z
published: 2025-02-20T13:27:16Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.madkudu.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Get predictive score of all your leads directly in Google Sheets

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](/v1/docs/customer-fit-scoring).

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](https://www.youtube.com/watch?v=EX41gK_pkes) 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.

[![](https://downloads.intercomcdn.com/i/o/139471109/000f01d9c98eb36a6919aa29/Screenshot+2019-08-07+at+11.19.14.png)](https://downloads.intercomcdn.com/i/o/139471109/000f01d9c98eb36a6919aa29/Screenshot+2019-08-07+at+11.19.14.png)

## 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](https://support.madkudu.com/hc/article_attachments/4404149046797/mceclip1.png)**

# **Signing in to the Add-On**

[![](https://downloads.intercomcdn.com/i/o/139471545/970aa86264e8d5612d8c484d/Screenshot+2019-08-07+at+11.21.37.png)](https://downloads.intercomcdn.com/i/o/139471545/970aa86264e8d5612d8c484d/Screenshot+2019-08-07+at+11.21.37.png)

**If you don't already have a MadKudu account:**

1. Click on "Create an account"
2. [Go through the signup process](https://app.madkudu.com/signup?ref=googlesheet)
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](https://app.madkudu.com/login?redirect=%2Fget-started%2Fgooglesheet)
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](https://app.madkudu.com/)
3. Go to **Integrations**
4. Click on **API**

**![mceclip0.png](https://support.madkudu.com/hc/article_attachments/4404148940173/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

![](https://cdn.document360.io/a55e7ea5-b8ac-4456-874d-10cc92097370/Images/Documentation/image(748).png)