Connect Kommo to Google Sheets

Bring your Kommo data into Google Sheets with Windsor.ai, so your sheets read live CRM pipeline data.

Pick the Kommo fields you need, and Windsor.ai keeps them flowing without a CSV export in between.

Forget CSVs. Stop copy/paste. Connect in minutes. No code required.

Try It Free

Free forever plan

No credit card needed

Windsor.ai is your proven Kommo to Google Sheets connector

Get your Kommo data into Google Sheets

Kommo is connected once in Windsor.ai, and these are the use cases the fields support:

See deal value by stage

Lead Price comes with the Lead Stage ID and Lead Pipeline ID of every lead, and the Stages report gives each Stage Name, so the value in each stage of each pipeline sits in one table.

Compare lead origins

Lead Origin shows where each lead came from, so you can count leads and add up Lead Price per origin.

Review lost deals

Lead Loss Reason and Lead Closed At show why and when leads were lost, by month or by pipeline.

Using Windsor.ai to connect data from Kommo to Google Sheets

Supported fields: 5 metrics74 dimensions

Windsor.ai moves your Kommo fields into Google Sheets on a connection you set up once, so the sheets stay on live records rather than a CSV someone exported last week.

Pick the fields you need and Windsor.ai handles the rest.

With Windsor.ai, your spreadsheet can:

Show the total Lead Price by Stage Name for each Pipeline Name.
Count leads created in the last 30 days by Lead Origin and add up their Lead Price.
List the Lead Loss Reasons for leads closed last quarter, with the number of leads for each.
Compare the number of leads and total Lead Price per User Name for leads created this month.
List the companies with the most Company Leads, with their Company Tags.

Join over 25,000+ businesses that trust Windsor.ai to streamline Kommo to Google Sheets integration

How to connect Kommo to Google Sheets with Windsor.ai

Explore a step-by-step guide to integrate your Kommo data into Google Sheets with the Windsor.ai connector.

Register and log in to Windsor.ai

Create a new Windsor.ai account or log in if you already have one.

Select your data source

Choose Kommo as your data source and enter your Kommo subdomain and an API token from your Kommo account.

Select your destination

Set Google Sheets as the destination for your data.

Select the reporting fields

Choose the Kommo fields you want to show in your spreadsheet.

Follow the setup instructions to complete the integration

Depending on the integration method you choose, set up the connection by following the prescribed steps, whether through an extension or directly via an in-app destination task.

FAQs

What is Kommo?

Kommo is a CRM for sales teams that sell through messaging apps such as WhatsApp, Instagram and TikTok. Leads move through the stages of a pipeline, and each lead links to contacts and companies.

What Kommo data can I load into Google Sheets?

Windsor.ai gives access to 79 Kommo fields. These are the groups; the Kommo field reference lists all of them:

Leads: Lead Deal Name, Lead Price, Lead Origin, Lead Stage ID, Lead Pipeline ID, Lead Loss Reason, Lead Tags, Lead Created At, Lead Closed At.
Pipelines and stages: Pipeline Name, Pipeline Is Main, Stage Name, Stage ID, Stage Type, Stage Pipeline ID.
Contacts and companies: Contact Name, Contact Tags, Contact Leads, Company Name, Company Tags, Company Contacts, Company Leads.
Users: User Name, User Email, User Is Active, User Is Admin, and the Responsible User ID on leads, contacts and companies.
Time and account: Date, Account ID (your Kommo subdomain), Account Name.

How does Windsor.ai load Kommo data into Google Sheets?

Windsor.ai sends your chosen Kommo fields straight into a sheet, either through the Google Sheets add-on or through an in-app destination task. You can set it to refresh on a schedule.

Does the Kommo connector include contact details?

Yes, names only. Contacts come with Contact Name, Contact First Name and Contact Last Name, and the Users report includes the User Email of each Kommo user on your account. The connector has no fields for the phone numbers or email addresses of your contacts.

Can I combine Kommo data with other sources in my sheets?

Yes. Windsor.ai supports 350+ data sources, so Kommo data can sit next to other connected sources in the same sheets. For example, put Kommo leads by Lead Origin and week next to Meta Ads and Google Ads spend for the same weeks, so ad spend and new leads sit in one table.

Do I need to code to connect Kommo to Google Sheets?

No. You connect Kommo in the Windsor.ai dashboard, pick the fields you want, and Windsor.ai handles the transfer.

How much does it cost to integrate Kommo with Google Sheets using Windsor.ai?

The free forever plan covers 1 data source, so connecting Kommo on its own costs nothing and needs no credit card. Combining Kommo with other sources needs a paid plan: $19/month for 3 sources or $99/month for 7. See the pricing page.

Do you have helpful links to get started with Kommo and Google Sheets?

Yes. These are the resources to start with for the Kommo to Google Sheets integration:

Tired of manual Kommo data exports? Try Windsor.ai today to work on live data

Access all your data from various sources in one place. Get started for free.

Start for Free Book a Demo