EN
See the demo

Looker Studio + Krokul CRM

Yes. Krokul CRM has a community connector for Looker Studio. You add Krokul as a data source, paste a Krokul API key, pick a report or a register, and Looker Studio reads the fields straight from Krokul each time a chart needs data. Google Sheets and CSV exports remain for one-off analysis.

  • Via API and webhooksYou connect it with the Krokul app in an automation platform, the public API and signed webhooks. The page lists the steps for this service.

What your team gets

A sales funnel that is always current

The Krokul data source in the funnel mode returns stage-to-stage conversion from the Krokul report engine. A Looker Studio funnel or bar chart shows it by month and pipeline, and the numbers match the Krokul dashboard because the same server calculates them.

Deals and payments as two tables

One data source reads the deals register, another reads payments. Looker Studio blends them by the deal ID, so a chart compares signed amounts with money received per manager and per month.

Custom fields as dimensions

The connector asks Krokul for the available fields through its schema step, and custom fields of deals and client companies arrive as their own dimensions. A segment or a region you track in Krokul becomes a filter control in the report without extra modelling.

Reports for a client without access to Krokul

An agency or an owner shares a Looker Studio report built on the Krokul data source. The viewers see the charts, the Krokul key stays in the data source credentials, and the key scope decides which records the report may read.

What moves between Looker Studio and Krokul

Looker StudioDirectionKrokulWhen
Data source, report mode (getSchema, getData)Krokul → Looker StudioReport engine: report/api-sources, report/api-runEach time a chart requests data
Data source, funnel and DSO modeKrokul → Looker Studioreport/api-conversion, report/api-stageDuration, report/api-dsoEach time a chart requests data
Data source, register modeKrokul → Looker StudioDeals, client companies, contacts, documents, payments, tasks (*/api-readList)Each time a chart requests data
Data source fieldsKrokul → Looker StudioStandard and custom fields of the chosen objectWhen you create or refresh the data source fields
Connector credentials (AuthType KEY)Looker Studio → KrokulKrokul API key with read scopeOn every data request
Google Sheets connectorKrokul → Sheets → Looker StudioDashboard widget exported to Google SheetsWhen someone exports the widget again

How to connect today

Add the Krokul connector

  1. In Krokul, create an API key with read scope for the objects you report on.
  2. In Looker Studio, create a data source, search the connector gallery for Krokul and authorize the connector for your Google account.
  3. Paste the Krokul key when the connector asks for it.
  4. Choose the mode (report, funnel or register), the object and the period, then click Connect. Looker Studio lists the fields, including custom ones.
  5. Build the charts. Each view of the report asks Krokul for fresh data within the data freshness setting of the data source.

Sheets and files

  1. For a single analysis, export a dashboard widget to Google Sheets or a register to CSV in Krokul and connect it with the Google Sheets or file upload connector of Looker Studio.

Questions and answers

Is there a Krokul connector in Looker Studio?

Yes. Search for Krokul in the Looker Studio connector gallery, paste a Krokul API key and choose a report or a register.

Do I need to export data from Krokul for my dashboards?

No. The connector reads Krokul directly. Exports to Google Sheets and CSV stay useful for one-off work and for sharing a fixed snapshot.

Can people who view the report see data they cannot see in Krokul?

The report shows what the Krokul key in the data source can read. Use a key with the role and scope that match the audience of the report, for example a viewer key for a client.

Are custom fields available in Looker Studio?

Yes. Custom fields of deals, client companies and contacts appear as dimensions or metrics, depending on their type in Krokul.

Limits

The connector reads data and never writes to Krokul. Rows that a Krokul key may not see stay out of the data source, so a report built on an agent key shows that agent only.

Missing something?

Tell us which service you use and what should move between it and Krokul. We reply with the way to do it and when it will be ready.

Request received. We reply to your email.

Looker Studio and Google Sheets are trademarks of Google LLC. Krokul is not affiliated with Google.

See the demo