Import any type of data from Kommo into Google Sheets

Create the lead filter you need using Kommo standard functionality.
For example, all successful leads, all leads with a certain tag, sales value, responsible manager, source, etc. Only leads matching this filter will be imported into tables.

You can set up several uploads to different tables with various lead parameters. For example, you can download anonymous data on leads, lead sources, UTM tags for a marketer; quarterly reports on leads with their sales values, responsible employees and other data for a department manager.

All uploads are synchronized in real time. Any change in Kommo will change the data in the table. Leads that meet the filter are added to the table and vice versa, leads that no longer match the filter are automatically deleted from the table.

You don't need to do complex manipulations and collect summary data of different entities across multiple tables. Just add the required fields from any of the related entities to a spreadsheet, and the widget will load the data itself. For example: together with contacts you can upload associated calls and tasks, and together with leads you can upload the list of sold products.

We've made comprehensive support for AppSheets. Upload the data you need directly to your iOS or Android mobile app by customizing the dashboard view by yourself. By plugging in the Triggers widget, it's possible to set up table fields and change synchronization with Kommo. Suitable for field workers who are not added to the CRM, but need to change data while outside the traditional office.