Analytics

KPI output from Google spreadsheet

Widget for displaying KPI indicators of managers from Google Sheets directly to the Kommo desktop

Features

Displaying KPI indicators from Google Sheets
Individual settings for each manager
Dragging card on screen
Setting up table cells for metrics

Installation and setup guide

Detailed guide for working with widget "KPI output from Google spreadsheet"

CONTENTS

  1. Widget settings
  2. Autoloading fields

Widget settings

First you need to create a table or generate it in Reports

Next you need to go to the widget settings

1. Insert link to Google Sheet

And insert the value into the Metric cell field

Next you can add all indicators by clicking on the Add field button

To view the metrics, click on - in the block.

The user will see their configured metrics from the table.

Autoloading fields

After preparing the table with the data:

1. Go to "Extensions" -> "Apps Script"