---
title: "Use Google Sheets in Kommo"
slug: "use-google-sheets-in-kommo"
description: "Step-by-step guidance on using the Google Sheets integration in Kommo, from adding new rows to keeping your sheet structured correctly. "
updated: 2026-03-09T09:02:19Z
published: 2026-03-09T09:02:19Z
canonical: "support.kommo.com/use-google-sheets-in-kommo"
---

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

# Use Google Sheets in Kommo

> [!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.

After connecting your Google Sheet to Kommo, follow these practices to keep the integration working correctly:

1. **Add new entries (rows) to create leads** You can add new entries after integrating Google Sheets. **Steps:**
  - Open the connected Google Sheet.
  - Add a new row of data (e.g., name, email, phone).
  - Each complete row will be processed as a new lead.
2. **Don’t edit column headers after setup**

> [!WARNING]
> **Important:** Changing column headers can break the integration.

**Steps:**
  - Avoid renaming, removing, or moving any columns.
  - If changes are needed, delete the integration and set it up again.
3. **Avoid empty rows** An empty row will stop Kommo from processing any data below it. **Steps:**
  - Scroll through the sheet and remove any empty rows.
  - To delete, right-click the row number and select **Delete row**.
4. **Use the integration settings to organize leads** You can assign tags, select a pipeline stage, and set a responsible user. **Steps:**
  - In Kommo, go to **Leads → Automate**, and open your Google Sheets source.
  - Adjust settings, including adding tags (optional), choosing the pipeline stage, and assigning a responsible user.
  - Click **Save**.
5. **Share the sheet carefully** The sheet can be shared with others, but changes to the structure can affect the integration. **Steps:**
  - Click **Share** in the Google Sheet.
  - Grant **Editor** access only to trusted users.
  - Remind them not to change column headers or add blank rows.
6. **Check if leads are being added correctly** If no leads appear, check for common issues, like blank rows or header changes in the sheet. **Steps:**
  - Go to the pipeline stage in Kommo that you selected.
  - Check if the new data was added **after** the integration setup.
  - Reconnect the integration if needed.

[Learn more about the integration](/v1/docs/google-sheets-hub-spokes) and [how to connect it](/v1/docs/connect-google-sheets-to-kommo-2).

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

- [Google Sheets overview](/google-sheets.md)
- [Connect Google Sheets to Kommo](/connect-google-sheets-to-kommo-2.md)