How to save a Crustdata prospect list to Google Sheets

You save a Crustdata prospect list to Google Sheets by getting the search results out of Crustdata as a file and importing that file into a sheet. Crustdata is a B2B data provider with a company database and a person database of more than a billion professional profiles, built largely from public LinkedIn data. It delivers that data mainly through its API. A person search returns each match with their name, current title, headline, location, current employer and its website domain, how long they've been in the role, and a flag that says whether Crustdata holds a business email for them. The email address itself comes from a separate lookup.

In Google Sheets, open File, choose Import, and upload the CSV. Sheets lets you create a new spreadsheet from the file, add it as a new tab, replace the current sheet, or append the rows to a sheet you already have. Crustdata and Google Sheets have no switch you can turn on to send one into the other. Teams who want the sheet to stay current usually write a Google Apps Script or an automation that calls Crustdata's API and writes the results into the sheet.

Both routes get rows into a sheet, but the rows need work before anyone can use them. Crustdata returns each person as a nested record, with past jobs, education, and skills as lists inside it, so someone has to decide which pieces become columns. The search matches what the database held at its last refresh, so some titles are already out of date. Nothing in the export knows who your customers or competitors are. A second export of an overlapping search adds the same people again, because a spreadsheet has no idea that two rows describe one person.

A good result is a sheet where every row is a person who fits your audience today, still holds the role, and comes with a reason they're worth contacting. Each row also says where its facts came from and how confident you can be in them. That matters most when the sheet goes to a teammate, a client, or a contractor who never saw the search behind it.

Kite does that work for you. It runs the search, checks each person, and writes a sourced, scored row for each prospect into the sheet your team already uses.

Start by telling Kite who you want on the list and which sheet it belongs in. You can describe the search the way you'd set it up in Crustdata:

"Use Crustdata to find heads of marketing at US fintech companies with 50 to 500 employees whose headcount grew this year, and put them in our Outbound Prospects sheet."

Or you can start from a goal and let Kite work out the audience:

"Build a list of people worth contacting about our new payments product and save it to a new Google Sheet for the sales team."

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 growth rate to target without a long brief. Confirm the profile or adjust it, and Kite starts. You can work with Kite in the Kite web app or in Slack.

Connect your Google account through OAuth so Kite can find your spreadsheets, read them, and write to them. When you name a sheet, Kite searches your Drive for it. Crustdata is built into Kite, so you can ask for a Crustdata search without an account of your own. If you already pay for Crustdata, you can connect your account with its API key, and Kite can then also read Crustdata's deeper company data, such as headcount history, funding milestones, and job listings.

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

Kite turns your audience into a Crustdata search, putting every trait Crustdata can filter on into the search itself. When the company is the reason to call, Kite searches Crustdata's company database first. It filters by headcount, headcount growth, funding, and the company's category, then looks for the right people at the companies that match. Headcount growth is often why someone reaches for Crustdata in the first place, since a team that grew by a third this year usually has new budget and new problems.

Kite then searches Crustdata's person database by title, seniority, company, and location. Each match comes back with the person's name, current title, headline, location, employer, time in the role, LinkedIn profile URL, and whether Crustdata holds a business email for them. If you already have a Crustdata export, share the CSV file in the conversation, and Kite starts from those people instead.

Kite checks each person before they get a row, because a database record is only as current as its last refresh. For every promising match, it reads the person's current LinkedIn profile, including their current and past employers, title, headline, and location. It drops anyone who has moved to a role or company outside your audience. It also notes anyone who started a new role recently, since a new leader is often reviewing the tools they inherited.

Next, Kite removes your existing customers, your competitors, and anyone who has asked not to hear from you. Every prospect who passes gets a fit score from one to five, with a one-line reason, such as "Head of growth at a 140-person payments company that grew headcount 30 percent this year." When the 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 and which filters limited the count. A short list of the right people is worth more than a long one someone has to clean up.

Kite looks up a work email only for people who passed every check, so it doesn't spend lookups on prospects nobody will contact. Crustdata's person search shows whether it holds a business email, and its profile lookup returns the address along with the person's full employment history, education, and skills. When Crustdata has no address for someone, Kite tries its other built-in email sources.

Each address keeps the source it came from and any verification status that source returned. A person with no address found stays on the list, marked as not found, rather than given a guessed address. Kite includes only business details, which means it leaves out personal email addresses and phone numbers.

Kite gives every row a source and a confidence note, so anyone reading the sheet can tell a checked fact from an assumption. The Source column links to the LinkedIn profile or company page behind the row. The email cell shows where the address came from and its verification status. The Confidence column states how sure Kite is that the person holds the role today and why, such as "Title confirmed on current LinkedIn profile" or "Title from the Crustdata record; profile could not be reread." When the fit reason mentions a recent event, such as a funding round or a hiring jump, the row includes its date and a link to where Kite found it.

A row also carries the date Kite last checked it. That tells your team at a glance which rows are fresh and which are worth checking again before an email goes out.

Kite reads your sheet's layout before it writes a single cell, because every team sets up its prospect sheet differently. It lists the tabs in the spreadsheet, reads the header row of the tab you named, and checks which columns have dropdown rules and which options they allow. Each value then goes under the header your team already uses, whatever the column order. When a column is a dropdown, such as Status, Kite picks one of the existing options instead of typing a new one that breaks your filters.

If your sheet has no column for something the list needs, such as the fit score, the source, or the confidence note, Kite proposes adding it and creates the column once you agree. If you asked for a new sheet, Kite creates the spreadsheet in the Drive folder you choose and writes a header row. It bolds and freezes the header, sizes the columns to fit, and turns on filters. It can also add a Status dropdown so your team can track who has been contacted.

Kite uses each person's LinkedIn profile URL as the key that decides whether they already have a row. The URL stays the same when someone changes jobs or email addresses, and every Crustdata person record has one, even when no email exists. Google Sheets has no rule against duplicate rows, so Kite looks up each URL in the sheet before it writes.

When a person is already there, Kite updates only the cells it owns that have changed, such as a new title, a newly found email, or a fresh confidence note. Your team's notes, status changes, and owner assignments stay exactly as they were. When a person isn't there yet, Kite adds them as a new row.

Kite writes the new and updated rows together once every prospect has been checked. A new person's row gets the following:

• First and last name
• Current title and seniority
• Company name, website domain, headcount, and headcount growth
• LinkedIn profile URL
• Work email, its source, and its status
• Fit score and the reason for it
• Source link and confidence note
• The date Kite last checked the row

A spreadsheet is flat, so the company details sit on each person's row, which makes the list easy to sort by company size or filter by growth. If your team prefers companies on their own tab, Kite can keep a separate Companies tab with one row per company. After writing, Kite can sort the list by fit score so the strongest prospects sit at the top, or highlight the primary group so a teammate can see where to start.

When the work is done, Kite posts a summary in the conversation where you asked. It says how many rows it added and updated, who it dropped at each check and why, and how many people have a work email. It links straight to the sheet.

From there, Kite can draft a personalized email for each primary prospect who has a work email, drawing on their role and their company's recent news, and send it from your team's Kite address once you approve. If you want new prospects regularly, ask Kite to run the same search every week. It checks each new batch against the LinkedIn URLs already in the sheet and adds only the people who aren't there yet.

When Kite finishes, your Google Sheet holds a checked list of prospects that anyone on your team can sort, filter, and trust, and your conversation with Kite holds the record of what changed.