---
title: "Google Sheets overview"
slug: "google-sheets"
description: "Get a quick overview of how Google Sheets works with Kommo and how new spreadsheet entries can turn into leads automatically. "
updated: 2026-03-09T08:58:43Z
published: 2026-03-09T08:58:43Z
canonical: "support.kommo.com/google-sheets"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://support.kommo.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets overview

> [!NOTE]
> What you'll need:
> 
> - An active Kommo account (or a 14-day trial).
> - A Google account.
> - Permission to edit the Google Sheet you’ll connect.
> 
> Keep in mind:
> 
> - Avoid changing column names after setup – it may break the integration.
> - The import process stops at the first empty row in the sheet, so data from rows below it will not be imported.
> - Only one sheet can be connected per integration.

Google Sheets is a cloud-based spreadsheet tool from Google that lets you create, edit, and share spreadsheets in real time. With this integration, you can automatically turn new entries into leads. It's a simple way to collect form data, survey results, or prospect lists and send them directly into your pipeline – no manual copy-pasting needed.

## Use cases

1. **Turn form submissions into leads –** If you collect contact details through a Google Form, the linked sheet can push those responses into Kommo as new leads, letting your team act on them right away.
  1. *Customer submits a Google Form:* ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/google-sheets-hub--spokes-image-fruegoey.png)
  2. *Google Form appear in Google Sheets:* ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/google-sheets-hub--spokes-image-slk2vzo0.png)
  3. *The client who responds in Google Forms becomes a new lead in Kommo:* ![](https://cdn.document360.io/56933ead-06fc-4574-95de-8fa458a5db1d/Images/Documentation/google-sheets-hub--spokes-image-darjz8c0.png)
2. **Manage prospect lists from marketing campaigns –** When running email or ad campaigns, you can log interested contacts in a shared Google Sheet. The integration will create a lead in Kommo for every new row added, so your sales team can start follow-ups instantly.
3. **Sync partner or reseller referrals –** If external partners or resellers submit leads through a shared sheet, Kommo can automatically pull those entries into your pipeline without needing manual input.
4. **Collect offline leads –** At events or trade shows, your team can add leads to a shared sheet. As long as the integration is active, those leads will appear in Kommo and can be distributed or qualified right away.

[Learn how to connect](/v1/docs/connect-google-sheets-to-kommo-2) and [use the integration](/v1/docs/use-google-sheets-in-kommo).

If you need more help with setup or troubleshooting, feel free to reach out to our support chat or contact us via [WhatsApp](https://api.whatsapp.com/send/?phone=14159141403&text&type=phone_number&app_absent=0). You can also [hire a Kommo partner](https://www.kommo.com/partners/) to do all the hard work for you.

Not a user yet? [Sign up for our 14-day free trial](https://www.kommo.com/product-overview/) or book a [free live demo](https://calendly.com/kommo-sales/demo?month=2022-10).

## Related

- [Connect Google Sheets to Kommo](/connect-google-sheets.md)
- [Use Google Sheets in Kommo](/use-google-sheets-in-kommo.md)