Integrations

Uploading to a Google spreadsheet from Kommo

Automatically upload data from Kommo to Google Sheets based on triggers. All key data is synchronized in real time for accurate analytics.

Features

Flexible table structure customization
Two-way synchronization — together with the “Import from Google Sheets” widget
Scheduled export of events with filters
Working with multiple sheets
Automatic data update
Using Google Formulas
Setting by triggers

Installation and setup guide

Detailed guide for working with widget "Uploading to a Google spreadsheet from Kommo"

Authorization in Google account

  1. Go to the widget settings
  2. Click on Log in
  3. Log in to Google

Trigger setup

  1. Go to the Configure section in the appropriate pipeline.
  2. Click Add Trigger.
  3. In the search, find the Upload to Google Spreadsheet and add the widget.

Export parameters

Specify the parameters:

1. Unloading condition — under what conditions the lead should be unloaded (for example, during the transition to the stage).
2. Select a file — select the document to which the upload will take place.
3. Fields to upload — select the fields that will be transferred to the table.

⚠ It is important to add fields in the same order as the columns in the table.

👉 Recommendation: upload data to a blank sheet without filters, and use the importrange function on another sheet to work. This will prevent crashes.

Actions with rows when uploading again:

  • update rows
  • upload to a new row

How to format the spreadsheet for export

In the first row of the table, specify the column headers.
Header format: Entity + field name (for example, "Lead.Date of creation").
A detailed list of supported fields can be found in the help.

Column headers in the spreadsheet

Automatic lead sync

To turn on auto-update:
Enable the checkbox “Automatically update the lead when it changes”.
Be sure to add the Lead: ID field to the export.
Move the lead to the stage with this trigger.

⚠ Auto-update works only for the spreadsheet selected in the last trigger that ran for the lead. With the option on, the lead is still updated:

  • if it is outside the stage with the trigger,
  • or even if that trigger has been deleted.
Automatic lead sync

Two-way sync

You can use this widget together with Import from Google Sheets to sync data both ways (Kommo ↔ Google Sheets).

How to set it up:

  1. Install both widgets.
  2. Create one shared spreadsheet.

Two-way sync
  1. Open the pipeline and click Configure
  2. On the stage you need, click Add trigger
  3. In the search box, type export and click Add
  1. Paste the Google Sheets link
  2. Add the fields to export

⚠ Required export field: Lead: ID

  1. Click Done
  2. Save the pipeline settings
  • After a lead enters the trigger stage, it is exported to the spreadsheet

Using formulas

To use Google formulas:
Add an “Empty” field to the trigger.
Export at least one lead.
In the “Empty” column of the spreadsheet, paste a formula instead of the exported value.
Example:
=ARRAYFORMULA(IFERROR(A:A+1,""))

  • Here the formula adds 1 to the value in column A for every row.
Using formulas

With large amounts of data, keep Google Apps Script limits and the overall load on the spreadsheet in mind.

Periodic export

This feature is designed for users who need to automate data export from Kommo based on specific events. It allows you to flexibly configure which data to export and under what conditions — for example, export paid invoices together with contact and lead data, or record changes in leads when specified triggers occur.

Key features

The following options are available in event-based export settings:

  • Trigger event selection. Export starts automatically when a specific event occurs — for example, when a tag is added, a task is completed, an invoice is paid, or leads are merged.
  • Event field configuration. You can choose which fields of the event itself should be included in the export (date, status, comment, etc.).
  • Related entity export. In addition to event data, you can include information about related objects — for example, contact details, lead parameters, or invoice details.
  • Flexible filtering and composition. You define which fields from which entities to export, forming the final dataset for a specific use case.

Export setup steps

Go to widget settings

1. Go to settings

Add export block button

2. Click "Add export block"

Enter export block name

3. Enter the block name

Select spreadsheet and sheet

4. Select a document and sheet (if required)

Configure export filters

5. Select filters

Select fields for export

6. Select fields for export

Save export block

7. Save the block

Typical use cases and setup examples

Export leads when a task is completed.
The trigger is the "completed" status of a task linked to a lead. The export includes lead fields, task parameters (name, due date, result), and assignee data. This helps track task completion and assess their impact on leads.

Export leads when a tag is added.
The event is adding a specific tag to a lead. The export includes lead fields and the tag itself, and optionally additional data (for example, responsible manager, pipeline stage). This approach is useful for lead segmentation and quick response to changes.

Export merged leads.
The trigger is the "lead merge" event. The export includes key fields from both original leads and the final parameters of the merged lead. This allows you to track change history, verify merge correctness, and analyze lead dynamics.

Export paid invoices with contact and lead data.
The selected event is "invoice payment". Event fields include invoice details and payment date. Related entities add contact fields (name, phone, email) and lead fields (number, amount, status). This export is convenient for payment reports and customer base analysis.

Information about data transfer

ℹ️The servers of this service (Google Sheets) are located outside the Russian Federation. If you process personal data of Russian citizens, make sure the cross-border transfer complies with Federal Law No. 152-FZ “On Personal Data”. If other data-protection rules apply to you, follow those as well.