--- title: 'Google Sheets + Kite' description: 'Kite writes complete, sourced prospect rows into your Google Sheets, updates them by a key column so the list stays current, reads a spreadsheet you already keep, and organizes it with sorting, filters, and charts.' slug: '/integrations/google-sheets.md' page_type: 'integration' primary_question: 'What can Kite do with Google Sheets?' entity: 'Kite' category: 'AI marketing agent' author: 'Devon Wells and Kite' date_published: '2026-08-31' date_modified: '2026-08-31' integration: name: 'Google Sheets' categories: - 'spreadsheet' connection_types: - 'OAuth' customer_account_requirement: 'required' capabilities_verified: '2026-08-26' vendor_url: 'https://www.google.com/sheets/about/' related_use_cases: - '/use-cases/build-b2b-lead-lists.md' related_playbooks: - '/playbooks/add-apollo-prospects-to-google-sheets-with-kite.md' - '/playbooks/add-clay-prospects-to-google-sheets-with-kite.md' - '/playbooks/save-a-crustdata-prospect-list-to-google-sheets-with-kite.md' - '/playbooks/save-a-qualified-lead-list-to-google-sheets-with-kite.md' --- # Google Sheets + Kite 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. ## Google Sheets + Kite at a glance - **Connection:** Your own Google account, connected through OAuth. - **Customer account required:** Yes, a Google account with edit access to the spreadsheets you want Kite to work in. - **Access:** Read and write. - **Works with:** Spreadsheets and their individual tabs, rows and columns, cell ranges, and the sheet's filters, formatting, and charts. - **Capabilities verified:** August 26, 2026. ## 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 Slack 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 ranges.** Kite 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 summary.** Kite 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 structure.** Kite 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 tabs.** Kite creates a spreadsheet or adds a tab so a new list has its own home. - **Rows and cell values.** Kite 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 presentation.** Kite sorts, filters, sets dropdown validation, formats cells, adds conditional formatting, resizes columns, and builds a chart. ## How Kite connects to Google Sheets Kite is your AI marketer in Slack. It researches your business, builds a growth strategy, and ships the work that brings you new customers. 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 Kite](/playbooks/add-apollo-prospects-to-google-sheets-with-kite.md) Kite 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. - [How to add Clay prospects to Google Sheets with Kite](/playbooks/add-clay-prospects-to-google-sheets-with-kite.md) Kite 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. - [How to save a Crustdata prospect list to Google Sheets with Kite](/playbooks/save-a-crustdata-prospect-list-to-google-sheets-with-kite.md) Kite turns a company and people search from Crustdata into rows in your sheet, so a research pull becomes a working list in one step. - [How to save a qualified lead list to Google Sheets with Kite](/playbooks/save-a-qualified-lead-list-to-google-sheets-with-kite.md) Kite 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. ## Where Google Sheets fits in Kite's marketing work ### [Build qualified B2B lead lists](/use-cases/build-b2b-lead-lists.md) Google Sheets is the destination that makes a finished lead list usable. Kite does the sourcing, scoring, and grouping, then writes the approved records into the spreadsheet your team already runs outreach from, so the work lands where sales will see it instead of scrolling back through a Slack thread. ## Review and approval Kite proposes work by default. A team approves it with a reply in the Slack thread or the Approve button on a proposed plan. Teams that want Kite to act first can turn that on. For Google Sheets, Kite shows the rows it is about to write and names the spreadsheet and tab they land in. By default, it writes them once you approve, so a change to a shared, live sheet happens on your say-so. ## 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.