Connect Kommo to AI, Sheets, Databases & BI Tools
Windsor.ai's Kommo connector extracts your Kommo data and syncs it to AI assistants like ChatGPT, Claude and Gemini, spreadsheets like Google Sheets and Excel, data warehouses like BigQuery, Snowflake and PostgreSQL, and BI tools like Looker Studio, Power BI and Tableau. Setup takes a few minutes in the browser, no coding required, and you can start for free, no credit card required.
How to connect Kommo to Windsor.ai
- Create your free Windsor.ai account or log in.
- Select Kommo and grant Windsor.ai access to your Kommo data.
- Pick the fields and date range you need and preview the data.
- Choose a destination and start syncing your Kommo data.
Kommo fields
Windsor.ai's Kommo connector offers 79 fields, organized in 7 tables such as General, Companies, Contacts, Leads, Pipelines, Stages, Users. Here are 30 of them:
-
Pipeline Name (
pipeline_name): The name of the pipeline. -
Date (
date): The date of the record. -
Account Name (
account_name): The name of the Kommo account. -
Account ID (
account_id): The Kommo subdomain the data was pulled from. -
Company Closest Task At (
company_closest_task_at): When the closest open task on the company is due. -
Contact Closest Task At (
contact_closest_task_at): When the closest open task on the contact is due. -
Data fetched at (
data_fetched_at): UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that... -
Lead Closed At (
lead_closed_at): When the lead was closed as won or lost. -
Pipeline ID (
pipeline_id): The unique identifier for the pipeline. -
Stage Color (
stage_color): The color of the stage in the Kommo interface. -
User Email (
user_email): The email address of the user. -
Company Contacts (
company_contacts_count): The number of contacts linked to the company. -
Contact Company ID (
contact_company_id): The unique identifier of the company the contact belongs to. -
Data Source (
datasource): The name of the Windsor connector returning the row -
Lead Closest Task At (
lead_closest_task_at): When the closest open task on the lead is due. -
Pipeline Is Archive (
pipeline_is_archive): Whether the pipeline is archived. -
Stage ID (
stage_id): The unique identifier for the pipeline stage. -
User ID (
user_id): The unique identifier for the user. -
Company Created At (
company_created_at): When the company was created. -
Contact Created At (
contact_created_at): When the contact was created. -
Day of month (
day_of_month): Day of the month -
Lead Company ID (
lead_company_id): The unique identifier of the company linked to the lead. -
Pipeline Is Main (
pipeline_is_main): Whether the pipeline is the main one of the account. -
Stage Is Editable (
stage_is_editable): Whether the stage can be edited. -
User Is Active (
user_is_active): Whether the user is active in the account. -
Company Group ID (
company_group_id): The group of the user responsible for the company. -
Contact First Name (
contact_first_name): The first name of the contact. -
Month (
month): Number of the month -
Lead Contacts (
lead_contacts_count): The number of contacts linked to the lead. -
Pipeline Incoming Leads Enabled (
pipeline_is_unsorted_on): Whether Incoming Leads are enabled for the pipeline.
Use Kommo data in ChatGPT and Claude
Windsor.ai is available as a plugin in ChatGPT and as a connector in Claude. Once Kommo is connected to Windsor.ai, you can ask questions about your Kommo data in plain language. Other MCP clients can add the Windsor MCP server at https://mcp.windsor.ai/.
- How to connect your data to ChatGPT
- How to connect your data to Claude
- How to connect Windsor MCP to any MCP client
Available destinations for your Kommo data
AI assistants
ChatGPT, Claude, Copilot, Manus, Gemini, Gemini Enterprise, Perplexity, Cursor, Grok, Google Antigravity, Lovable, n8n, Base44, Mistral, Kimi, DeepSeek, AI Insights (any MCP client)
Spreadsheets
Google Sheets, Excel, Airtable
Databases & warehouses
BigQuery, Snowflake, MySQL, PostgreSQL, Supabase, Azure SQL, Redshift, Databricks, Microsoft Fabric, Windsor.ai Cloud Database, Cache Data Store
BI & dashboards
Data Studio, Power BI Desktop: Native, Power BI Desktop: Web, Tableau
File storage
Amazon S3 Storage, Azure Blob Storage
Code
Python/R Code