NOVA Widget

Output KPIs(indicators) from
Google Sheets in Kommo

The widget allows you to output data from Google Tables to a special block in the Kommo interface. In this way, it is possible to display managers' indicators for motivation and information. The widget works very effectively together with the Reports widget in Google Tables and can dynamically show the current achievements of the sales department.

If this widget does not solve all the tasks and requires improvement, we can refine it for you.

CONFIGURING THE WIDGET


1. First you need to create a table from which the indicators will be taken

2. Next, go to the widget settings and paste the link to the Google Spreadsheet in the field

3. Next, you need to select a manager, a block with the selected managers will appear, when you click on it, two fields will appear for entering the indicator name and the indicator cell, in the Indicator Name field you need to enter a name, for example, the number of successful transactions.

4. Next, we go to the table and find the cell with the indicators of this manager and copy the cell number and paste the value into the Indicator Cell field

5. Next, you can add all the indicators by clicking on the Add Field button


To view the indicators, click on - in the block

The administrator will see all the indicators of all managers, and the manager will only see his own

Made on
Tilda