Skip to content

CRM and sales

Connect ZohoCRM to DataxLand

The Zoho CRM connector reads CRM modules such as Leads, Deals, Contacts and Accounts. Si maps Deals to sales opportunities and Leads to leads in the standard model, so you can see won amount, win rate, pipeline value and lead-to-customer rate by owner and by month, then ask Si about those numbers in plain language.

Free plan with no time limit · No card required · Sample workspace ready in minutes

What you can do with ZohoCRM

  • Track pipeline and win rate for a sales team on Zoho CRM.
  • Measure lead-to-customer rate by lead source once ad spend is joined in.
  • Set an alert when open pipeline value drops sharply from the previous week.

What data you get

Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.

Stream (table)Contents
DealsDeals with value, stage, expected close date and owner.
LeadsLeads with lead source, status and created date; names, emails and phone numbers are hashed on load.
ContactsCustomer contacts; personal data is hashed.
AccountsCustomer companies, used as an analysis dimension.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
Fields to fill inClient ID, Client Secret, Data Center Location, Environment, Refresh Token
DeveloperAirbyte (community), run inside DataxLand
LicenseELv2
Technical docsConnector documentation ↗

Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.

Metrics computed from this source

Real definitions from the analytics packs; dashboards and Si share them.

MetricDefinitionUnit
Won amountTotal value of won opportunities, by close date.Currency
Won opportunitiesNumber of opportunities won, by close date.Count
Win rateWon opportunities divided by all closed opportunities (won plus lost) in the period. Open opportunities are excluded.= Won opportunities / (Won opportunities + Lost opportunities)Ratio (%)
Open pipeline valueTotal value of opportunities created in the period that are still open (neither won nor lost).Currency
Average deal sizeWon amount divided by the number of won opportunities.= Won amount / Won opportunitiesCurrency
New opportunitiesSales opportunities created in the period (by creation date), including open, won and lost ones.Count
LeadsNumber of leads (prospects) created in the period, by creation date.Count
Lead-to-customer rateLeads created in the period that have become customers divided by leads created in the period.= mkt_converted_leads / LeadsRatio (%)

Connect ZohoCRM in 4 steps

  1. 1

    Create a Zoho app

    In the Zoho API Console, create a client (Self Client), get the Client ID and Client Secret, and generate a refresh token that can read the modules you need.

  2. 2

    Add the Zoho CRM source

    In the workspace choose Add source, find Zoho CRM, and enter the Client ID, Client Secret, Refresh Token, data region (Data Center Location) and environment; keys are encrypted when saved.

  3. 3

    Test and choose streams

    Click Test connection, then select the Deals, Leads, Contacts and Accounts modules.

  4. 4

    Review and build

    Si proposes a mapping from modules to opportunities and leads; you approve, then build the sales dashboard.

Limits and caveats

  • DataxLand does not run the Zoho OAuth sign-in; you create the client and refresh token yourself in the Zoho API Console.
  • Stream names are the module names in your CRM; custom modules also appear if the account can read them.
  • Requires the Starter plan or above; Zoho limits API calls per day according to your CRM plan.
  • A community Airbyte connector (ELv2 license) run inside DataxLand.

Frequently asked questions

Which data region should I choose?

The region where your Zoho account was created, for example US, EU, IN or AU; with the wrong region, the connection test reports an error.

Do I need Zoho admin rights?

Not necessarily, but the refresh token can only read the modules its creator is allowed to see.

Does customer personal data reach Si?

No. Name, email and phone number columns are hashed on load and masked before they reach Si.

Dashboard templates that use this source

Ask Si about your ZohoCRM data →All data sources →

Connect ZohoCRM and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes