Google Sheets Guide

Overview

Score leads directly in Google Sheets without leaving your spreadsheet. The Conturs Google Sheets integration lets you add a lead scoring column to any sheet with company data.

Status: Coming Soon — Join the waitlist to get early access.

How It Will Work

Install the Add-on

The Conturs add-on will be available in the Google Workspace Marketplace. Install it once, and it works across all your Google Sheets.

Add Your API Key

Open any Google Sheet, go to Extensions → Conturs Lead Scoring → Settings, and paste your API key from Dashboard → API.

Score with a Formula

Use the custom formula in any cell:

=CONTURS_SCORE(A2)

Where A2 contains a company domain (e.g., "acme.com"). The formula returns the similarity score (0–100).

Advanced Formulas

=CONTURS_SCORE(A2)           → Score only (number)
=CONTURS_GRADE(A2)           → Grade (A/B/C/D/F)
=CONTURS_EXPLAIN(A2)         → Explanation (text)
=CONTURS_DETAIL(A2, "industry") → Specific factor score

Use Cases

Score an Event Attendee List

Export your webinar or conference attendees to a Google Sheet. Add a "Domain" column if not present. Use =CONTURS_SCORE() to instantly score all attendees. Sort by score to find the best follow-up targets.

Score an Imported Lead List

Got a CSV from a partner, a purchased list, or a LinkedIn export? Import it into Google Sheets, add the scoring formula, and prioritize the highest-fit leads before importing them into your CRM.

Quick Pipeline Audit

Export your open deals from your CRM to Google Sheets. Score each one and compare Conturs scores to deal stages. Identify mismatches — high-score deals stuck in early stages (accelerate) or low-score deals in late stages (risk).

Pricing

Google Sheets scoring uses your regular Conturs API quota. Each =CONTURS_SCORE() call = 1 API request.

• Free plan: 100 scores/month

• Pro plan: 5,000 scores/month

• Business plan: 25,000 scores/month

Limitations

• Requires an internet connection (scores are calculated via API)

• Formulas recalculate when the sheet opens or when you manually refresh

• Maximum 500 rows per batch scoring operation

• Domain column is required — email-only scoring extracts the domain automatically

Alternative: Manual API Approach

While waiting for the native add-on, you can use Conturs with Google Sheets today via Apps Script:

function contursScore(domain) {
  var options = {
    method: 'post',
    contentType: 'application/json',
    headers: { 'Authorization': 'Bearer YOUR_API_KEY' },
    payload: JSON.stringify({ domain: domain })
  };
  var response = UrlFetchApp.fetch('https://api.conturs.com/v1/score', options);
  return JSON.parse(response.getContentText()).score;
}

Add this script via Extensions → Apps Script, then use =contursScore(A2) in your sheet.

Get Early Access

The Google Sheets add-on is currently in development. To join the waitlist and get early access, email support@conturs.com with subject line "Sheets Beta".