How to save a qualified lead list to Google Sheets

To save a qualified lead list to Google Sheets, put one lead on each row and give every row the details someone needs to contact that person and to trust that they belong on the list. For outreach, that means the person's name, job title, company, company website, LinkedIn profile, and work email. For trust, it means the email's verification status, a fit score with a short reason, and a link to the page where the role was confirmed.

Google Sheets gives you the container but none of the leads. Most teams get the rows from a prospecting database such as Apollo or ZoomInfo by exporting a CSV file, then bring it in with File, then Import. Sheets can create a new spreadsheet from the file, add it as a new tab, replace the current sheet, or append the rows to the list you already have. Sheets also gives you tools to keep the list tidy afterward. Data cleanup includes a Remove duplicates tool, Data validation turns a column into a dropdown, and filters let you sort by any column.

The import moves rows well, but it can't tell you which rows are any good. A database export lists whoever matched your search filters, including the person who changed jobs last quarter and the address that will bounce. When the list is passed to a teammate, a client, or the outreach tool that sends the emails, the reasons behind each choice have usually been lost along the way. The reader sees a name and an email and has no way to tell a checked lead from a guess.

That's the part of this job that takes judgment. A good lead list in Google Sheets holds only people who fit your ideal customer profile and still hold the role. Each person appears once, every value sits under the right header, and each row shows its evidence. A reader should be able to click the source link, see the email status, and read why the person was chosen without asking you.

Kite does that work for you. It finds and qualifies the leads, records the evidence for each one, and writes the list into the sheet your team already uses or a new one it sets up.

Start by telling Kite who you want on the list and where it should go. You can work with Kite in your browser or in Slack, and you can ask in a sentence:

"Find 40 marketing leaders at B2B software companies in the US with 50 to 300 employees, and save the qualified ones to our Outbound Leads sheet."

You can also hand Kite a list you already have and ask it to check it:

"Here's the attendee list from last month's webinar. Keep the people who fit our profile and add them to the Q4 Leads sheet with work emails."

For an event, the same job builds an invite list:

"Build an invite list of 60 heads of revenue in Chicago for our November dinner and put it in a new sheet."

Kite is an AI marketer. It researches your business, builds a growth strategy, and ships the work that brings you new customers. By the time you ask, it already knows your ideal customer profile, your current customers, and your competitors from that research. That lets it propose the titles, seniority, company size, and locations to target without a long brief. Confirm the profile or adjust it, and Kite starts.

You'll need to connect your Google account through OAuth so Kite can find your spreadsheets, read them, and write to them. Name the sheet, and Kite searches your Drive for it. You don't need an account with a prospecting database, because Kite comes with built-in research sources, including Apollo, Crustdata, and PredictLeads. If you're starting from your own list, attach the file to the conversation or point Kite at the sheet where the names already live.

Saving leads to a sheet is routine work, so Kite writes the rows and then tells you what it did. If you'd like to review the list before anything reaches the sheet, say so in your request, and Kite shows you the table first.

Kite builds the list from your profile or starts from the names you gave it, depending on what you asked for. When it builds the list, it finds companies first. It searches by industry, headcount, location, funding, and the technology a company uses, and it can filter by hiring activity or recent growth. Kite puts every part of your profile that a search can filter on into the search itself, so it isn't sorting through companies that were never a fit.

Kite can also start from something that just happened, such as a funding round, a new marketing leader, or a burst of hiring. Kite drops events older than about three months, because they're no longer a reason to reach out today. It keeps each company's event, its date, and its source link, so the row can show why this company is worth contacting now.

Next, Kite finds the right people at each company by title, function, and seniority. It reads each title against your profile as you wrote it, because a title can contain the right words without the right job. When you supplied your own list, Kite treats those names as candidates and runs them through the same checks.

Kite decides who stays by checking each candidate against your profile before it spends anything on enrichment. First it confirms that the person still holds the role at that company, using a public profile or the company's own pages, and it drops anyone who has moved on. Then it removes your existing customers and your competitors. If the list feeds an email send or an invitation, it also removes anyone your team has recorded as opted out.

Every lead who passes gets a fit score from one to five with a one-line reason, such as "VP of marketing at a 140-person payroll software company that's hiring two demand-generation managers." When a list runs past about fifteen people, Kite splits it into primary and secondary groups so your team knows where to start.

If fewer people qualify than you asked for, Kite tells you how many it found, which filters it used, and where the rest fell short. A short list of real leads is worth more than a long one somebody has to clean up.

Kite gives every row the link to the public page that confirms the person's role, because that link is what lets a reader check the lead without redoing the research. The source might be the person's LinkedIn profile, the company's team page, or an announcement of their new role. When the lead came from a company event, the row also carries what happened, when it happened, and a link to where it was reported.

Each work email comes with its verification status exactly as the provider returned it. That status might be verified, catch-all, risky, or unverified, and Kite records every flag the provider returned, so a verified address that also sits on a catch-all domain shows both. Kite also records where the email came from. When no address turns up, the cell says not found rather than holding a guess at the company's email pattern, because a guessed address isn't a found one.

You can set your own rule for any column, such as "leave the email blank unless it's verified." Kite follows that rule in every row, and the status column still records what the provider said, so nobody loses track of why a cell is empty. Kite includes only professional details, which means it leaves out personal email addresses, phone numbers, and home addresses.

Kite reads your spreadsheet's layout before it writes a single cell, because every team sets up its lead sheet differently. It lists the tabs, reads the header row of the tab you named, and checks which columns have dropdown rules and which options those dropdowns allow.

That lets Kite put each value under the header your team already uses, whatever order the columns are in. When a column is a dropdown, such as Status or Owner, Kite picks one of the options already on the list, so your filters keep working. If the sheet has no column for something a reader needs, such as the source link or the email status, Kite proposes adding it and creates the column once you agree.

If you asked for a new sheet, Kite creates the spreadsheet with a header row built for outreach. It bolds and freezes the header, sizes the columns to fit, and turns on filters. It can also add a Status dropdown with options such as "Not contacted," "Contacted," and "Replied," so your team can track the list as they work it.

Kite saves only the list itself in the sheet. Its notes on how it checked the work, such as how many candidates failed each check, go in its reply to you, so the cells stay clean enough to import straight into an outreach tool.

Kite matches each lead on their work email, and on their LinkedIn profile link when no email was found, before it writes anything. Google Sheets allows duplicate rows, so Kite looks up each lead in your sheet first.

When a person is already there, Kite updates only the cells that changed, such as a new title or a newly verified email. It leaves the rest of the row alone, so your team's notes, status changes, and owner assignments stay as they were. When a person is new, Kite adds them as a row at the end of the list.

Kite writes the new and updated rows together once every lead has been checked. A new row gets the following:

• Full name
• Job title
• Company name and website
• LinkedIn profile
• Work email, its verification status, and where it came from
• Fit score and the reason for it
• Source link for the role
• The recent company event and its date, when the list was built from one

After writing, Kite can sort the list by fit score so the strongest leads sit at the top, or highlight the primary group so a teammate can see where to start.

When the work is done, Kite replies in the conversation where you asked, with a link to the sheet. It says how many rows it added and updated, who it left out and why, and how many leads it delivered against how many you asked for. It also reports how many rows have a work email, and for the rows without one, which sources came back empty.

If the connected Google account can only view the sheet, Kite tells you it needs edit access to that file, and you can share it with edit rights and ask again. From there, Kite can draft a personalized email for each primary lead, built on the reason and the recent event in that lead's row. It sends them from your Kite team address or a connected email product once you approve. If you want the list to grow every week, ask Kite to run the same job on a schedule, and it checks the sheet for people already there before adding each new batch.

When Kite finishes, your Google Sheet holds a list of qualified leads that anyone on your team can check, filter, and use for outreach, and your conversation with Kite holds the record of what changed.