Google Sheets overview

January 6, 2026

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.
  • Customer submits a Google Form:

  • Google Form appear in Google Sheets:

  • The client who responds in Google Forms becomes a new lead in Kommo:

  1. 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.
  2. 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.
  3. 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 and use the integration.

If you need more help with setup or troubleshooting, feel free to reach out to our support chat or contact us via WhatsApp. You can also hire a Kommo partner to do all the hard work for you.

Not a user yet? Sign up for our 14-day free trial or book a free live demo.

Try Kommo free

Discover how Kommo can transform your client management now