Google Sheets lead enrichment with Leadsets

Leadsets connects to Google Sheets through free GTM skills. An AI agent connected to the Leadsets MCP server (https://mcp.leadsets.ai) runs skills such as Build an outbound prospect list or Enrich companies from domains. It writes results, with verification labels, to a Google Sheet. CSV import and export is the fallback. Leadsets publishes no Sheets-specific setup steps beyond its MCP, REST and skills docs.

Google Sheets is a spreadsheet application from Google. This page covers what Leadsets can do with it, how the connection works, and where its limits are.

The Leadsets integrations page lists Google Sheets under data and alerts, and describes the connection as skills. Skills are free, open-source SKILL.md playbooks that tell an AI agent which Leadsets tools to call, in what order, and how to check the result. According to the skills library, 13 of the 50 skills use Google Sheets as a connection. CSV and Excel import and export are listed alongside it.

What you can do with Leadsets in Google Sheets

These skills list Google Sheets as a destination or source:

Build an outbound prospect list. Defines your ICP, finds matching people, enriches and verifies them, and exports a send-ready list. It uses search_companies, search_people, enrich_person and verify_email.
Contacts at target accounts. Turns an account list into ranked contacts per account, with optional enrichment.
Find and enrich by name. Goes from name plus company to contact data, with no LinkedIn URL needed.
Bulk enrich a CSV. Enriches a whole file as an async job and checks your limits before each batch with get_usage.
Enrich companies from domains. Adds industry, headcount band, location and stack to a list of domains with enrich_company.
Account research brief. Reads a company's site and returns a one-page brief. This one needs scrape units, which are a paid add-on.

Every record carries match reasons, a verification status for emails, a confidence score and the date each field was last checked. That metadata can travel into the sheet, so you can see why each row is there and how fresh it is.

How to connect it

Leadsets does not publish setup steps specific to Google Sheets, and its site does not describe a Google Sheets add-on. The documented route is the generic one: connect your agent to Leadsets, add a skill, and ask for the output in a sheet.

Get a key. Create a free account. Free gives 1,000 records one time, with no card. API keys start with ls_live_ and should be kept server-side.
Connect the MCP server.
- In Claude (web or desktop), open Customize, Connectors, + Add, then Add custom connector.
- Name it Leadsets and enter https://mcp.leadsets.ai as the MCP server URL.
- Click Continue, choose Sign in now, click Add and sign in. This uses OAuth, so there is no key to paste.
- In a chat, turn it on with +, Connectors.
- In Claude Code, run claude mcp add --transport http leadsets https://mcp.leadsets.ai.
- In Cursor, add a server with that URL and an Authorization: Bearer ls_live_… header.
- The MCP docs cover each client.
Check the connection. Ask "What's my Leadsets usage?" The agent should call get_usage and reply with your remaining balance.
Add a skill. Download the skill folder and upload it in Claude, Settings, Skills, or clone the library with git clone github.com/leadsets/leadsets-skills. Browse them in the skills library.
Ask in plain language, and name a Google Sheet as the destination.

If you work in code or an automation tool instead, call the REST API at https://api.leadsets.ai/v1 with your key as a bearer token, for example POST /v1/people/enrich. You can then write results to a sheet with your own tooling. For anything else, export CSV and import it, as described on the CSV and Excel integration page.

Example: a RevOps list in a sheet

Maya Chen runs revenue operations at Northwind Analytics (northwind.co). She wants a list of heads of RevOps at similar companies. With Leadsets connected in Claude and the Build an outbound prospect list skill installed, she asks:

"Build a list of 100 heads of RevOps at US B2B SaaS companies with 50 to 200 people. Put it in a Google Sheet."

The skill runs these steps in order:

Confirms the ICP.
Checks remaining limits with get_usage.
Probes the filters with a 1-record search_companies call.
Finds people with search_people.
Runs enrich_person and verify_email on each person.

The illustrative output on the skill page reads:

132 matching people, 118 enriched
96 verified, 14 catch-all on a separate tab, 8 with no email
A new sheet with three tabs

Maya sends to the verified tab first. She warms the catch-all tab at lower volume and leaves the no-email rows for later research.

What to watch for

Records and limits.

A record counts only when data comes back, so empty searches use none. Every call still counts as a request.
Free is 1,000 records one time, shared across search and enrichment. They do not refill.
Paid plans are flat monthly prices: Solo $29, Pro $99, Team $399 and Max $999. Each has fair-use limits per rolling five hours and per week. For example, Solo allows 1,000 enrichments and 500 search records per five hours.
A large sheet can cross a window. When it does, Leadsets returns a 429 with a Retry-After time, and the blocked call counts against nothing. The Bulk enrich a CSV skill checks get_usage before each batch to avoid stalling. See limits and costs.

Verification statuses. Every email is labelled verified, catch-all, unknown or invalid, with a confidence score.

Catch-all means the domain accepts everything, so no one can confirm the mailbox.
Unknown means the server gave no clear answer.
Neither is reported as valid, and invalid emails are never served as contact emails.
Keep the status column in your sheet, and segment before sending.

Scraping. Skills that call scrape_company or scrape_jobs need scrape units. These are an add-on on paid plans from $9 for 1,000 units and are not available on Free.

What it does not do

No phone numbers. Leadsets returns work emails, US personal emails on paid plans, roles and company data.
Not a sending tool or a CRM. It feeds them, for example through CSV or skills for Instantly, Smartlead, HubSpot and others.
Business contacts only. No consumer data, no sensitive categories and no home addresses.
No Sheets-specific guarantees. The site does not document Google Sheets menus, add-ons or settings. Anything beyond the skills and CSV route described here is not covered by Leadsets documentation.

Questions and answers

Can I enrich leads in Google Sheets with Leadsets?

Yes, through Leadsets skills. An agent connected to the Leadsets MCP server can run skills such as Bulk enrich a CSV, Find and enrich by name or Enrich companies from domains, which list Google Sheets as a connection. CSV import and export works as a fallback.

Is there a Leadsets add-on for Google Sheets?

The Leadsets site does not describe a Google Sheets add-on. The integrations page lists the Google Sheets connection as skills, and CSV and Excel import and export are also supported.

How do I connect Leadsets to my AI agent before using Google Sheets?

Add https://mcp.leadsets.ai as an MCP server. In Claude, open Customize, Connectors, + Add, Add custom connector, then sign in with OAuth. In Claude Code, run claude mcp add --transport http leadsets https://mcp.leadsets.ai. Ask "What's my Leadsets usage?" to confirm it works.

How many rows can I enrich into a sheet on the free plan?

The free plan gives 1,000 records one time, shared across search and enrichment, with no card. A record only counts when data comes back, so empty results use none. The records do not refill or expire.

What do the email statuses in my sheet mean?

Verified means the mailbox accepts mail. Catch-all means the domain accepts everything, so the mailbox cannot be confirmed. Unknown means the server gave no clear answer, and invalid addresses bounce and are never served as contact emails.

Can Leadsets add phone numbers to my Google Sheet?

No. Leadsets does not offer phone numbers yet. It returns work emails, US personal emails on paid plans, roles and company data.

Go deeper

More integrations