What Google Sheets is and how Kite works with it
Google Sheets is a cloud spreadsheet where many teams keep their prospect lists, campaign trackers, and working data. Kite treats it as a real destination for finished marketing work. It can create a new spreadsheet, add a tab, and write complete rows into a sheet you already keep, then read those rows back, update them, and organize the list so it is ready to use. For a team that runs prospecting from a spreadsheet, that means the sourced lead list arrives already filled in, in the exact file the team works from. Kite connects through your own Google account, so it acts on the spreadsheets that account can open.
Marketing jobs Kite can do with Google Sheets
The actions below let Kite treat a spreadsheet as both a place to deliver finished work and a source to read from. The jobs move from writing a list, to keeping it current, to reading one you already have, to making it easy to work.
Write a finished lead list into a sheet
Kite can create a new Google spreadsheet or write into one you already keep. It appends complete prospect rows to the end of an existing table, inserts a row at a chosen position, or adds a fresh tab so a new list sits beside your current ones. Each row carries the fields Kite gathered during research: the company, the contact's name and title, their LinkedIn profile, a professional email when the source has one, the fit score Kite assigned, and the public source behind the record.
The point is that the list you would have assembled by hand shows up already built, in the spreadsheet your outreach already reads from. No copy and paste from a chat into a sheet.
Keep an existing list current
When the same prospects come back with new information, Kite can update the rows in place instead of starting a second copy. It matches on a key column you choose, such as company or email, updates the cells that changed, and adds anyone genuinely new in the same pass. It can also overwrite a specific range, find and replace a value across the sheet, or clear a range that no longer applies. One working list stays authoritative rather than splintering into near-duplicates.
Read a spreadsheet you already keep
Kite can use a Sheet as an input as readily as a destination. It reads a single range, several ranges at once, or a whole tab to pull your existing list into its work. It can look up one row by matching a cell, and total or average a column across the rows that meet a condition. Because it can also search your Drive for a spreadsheet by name and list the tabs inside it, you can point Kite at the Q3 target accounts sheet by describing it rather than pasting a link.
Organize the sheet so the list is usable
A raw block of rows is harder to work than a sorted, labeled one. Kite can sort a range, apply a filter, and set a dropdown so a status column only accepts the values your team uses. It can format cells, add conditional formatting to flag rows by score, resize columns to fit their contents, and build a chart from a range so a prospect list doubles as a quick status view.
What Kite reads and changes in Google Sheets
Kite both reads from and writes to a connected spreadsheet. The breakdown below separates the two so it is clear what Kite pulls in and what it puts back.
Information Kite can read
- Cell values and rangesKite reads a single range, several ranges at once, or an entire tab to bring your existing list into its work.
- A matched row or a column summaryKite finds the row where a cell matches a value, and totals or averages a column across the rows that meet a condition.
- Spreadsheet and tab structureKite searches your Drive for a spreadsheet by name, lists its tabs, and reads its title and layout so it targets the right place before it writes.
Information Kite can create or change
- New spreadsheets and tabsKite creates a spreadsheet or adds a tab so a new list has its own home.
- Rows and cell valuesKite adds rows to the end of a table, inserts a row at a chosen spot, updates cells in place, matches on a key column to update existing rows while adding new ones, and clears a range that is no longer needed.
- Layout and presentationKite sorts, filters, sets dropdown validation, formats cells, adds conditional formatting, resizes columns, and builds a chart.
How Kite connects to Google Sheets
Connect your Google account through OAuth. Kite then works with the spreadsheets that account can open and writes with the same edit rights you have. Point it at a specific spreadsheet, or describe the file by name and Kite finds it in your Drive and confirms the tab before it writes. If the list is new, Kite can create the spreadsheet itself and return where the finished list lives.
Playbooks using Google Sheets
- How to add Apollo prospects to Google Sheets with KiteKite pulls the people who match your criteria from Apollo, enriches each one, and writes them as complete rows in your sheet with the company, contact, email, and source in place.Coming soon
- How to add Clay prospects to Google Sheets with KiteKite takes an enriched prospect set from Clay and lands it in a spreadsheet, mapping each field to a column so the list is ready for outreach.Coming soon
- How to save a Crustdata prospect list to Google Sheets with KiteKite turns a company and people search from Crustdata into rows in your sheet, so a research pull becomes a working list in one step.Coming soon
Show 1 more playbook
- How to save a qualified lead list to Google Sheets with KiteKite scores each prospect against your criteria, groups the list into primary and secondary tiers, and writes the approved records with their scores into the spreadsheet.Coming soon
Where Google Sheets fits in Kite's marketing work
Review and approval
Kite proposes work by default. A team approves it with a reply in the conversation or the Approve button on a proposed plan. Teams that want Kite to act first can turn that on.
For Google Sheets, Kite names the spreadsheet and tab it writes to.
Limits and product-specific details
- Write access follows your connected account. Kite can open and change only the spreadsheets your Google account can reach, and it writes with the same edit permissions you hold.
- This page covers Google Sheets, not the wider Google Workspace. Docs, Slides, and Gmail are separate products with their own connections.
- Kite writes to a named spreadsheet and tab. It targets the file and tab you point it at or that it created, so a value lands in a known cell rather than a guessed one.
Common questions
Does Kite create a new spreadsheet, or write into one I already keep?
Both. Kite can spin up a new Google spreadsheet for a fresh list, or append to and update a sheet you already run outreach from. When you describe the file by name, it locates it in your Drive and confirms the tab before writing anything.
Can Kite turn the list into a summary or chart inside the sheet?
Yes. Kite can total or average a column, build a chart from a range, and apply conditional formatting so high-scoring rows stand out. That lets a working prospect list serve as a simple status view without moving the data into another tool.