Search API Connector Documentation

Print

Import Zoho CRM Data to Google Sheets

premium

In this guide, we will pull data from the Zoho CRM API directly into Google Sheets, using the API Connector add-on for Sheets.

Contents

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Connect to the Zoho CRM API

If you haven’t connected API Connector to Zoho before, you’ll first need to initiate the connection as follows:

  1. Open up Google Sheets and click Extensions > API Connector > Manage Connections.
  2. In the list of available connections, find Zoho CRM and click Connect.
    zoho-crm-img1
  3. You will be directed to Zoho and asked to authorize the connection. Click Accept.
    zoho-crm-img2
  4. You’ll now be returned to your Google Sheet, and can verify that your Zoho CRM API connection is active in the Connections screen.

Part 2: Create a Zoho CRM API Request URL

For our first request, we’ll keep it simple and get some basic information about your own Zoho account.

  • API root: https://www.zohoapis.com
  • Endpoint: /crm/v2/org

Putting it together, we get the full API Request URL.

https://www.zohoapis.com/crm/v2/org

Part 3: Pull Zoho CRM API Data into Sheets

Now let’s enter that URL into API Connecto.

  1. In the Create Request interface, enter the Request URL we just created.
    zoho-crm-img4
  2. Under OAuth, choose Zoho CRM from the Connections dropdown.
  3. We don’t need any headers for this API, so just leave that section blank.
  4. Create a new tab and click Set current to use that tab as your data destination.
  5. Name your request and click Run. A moment later you’ll see some information about your account populate your sheet.
    zoho-crm-img6

Part 4: More Example API URLs

Now that we’ve validated the connection and shown how to connect, we can start pulling some more data. You can access the full list of metrics available in the Zoho CRM API here, but if you just want to get started, you can try the following URLs.

Note that by default, only 10 records will be returned. Add ?per_page=200 to the end of your URL to fetch up to 200 records (read more about this in the pagination section).

  • List of Accounts
    https://www.zohoapis.com/crm/v2/Accounts
    zoho-crm-img7
  • List of Leads
    https://www.zohoapis.com/crm/v2/Leads
    zoho-crm-img8
  • List of Contacts
    https://www.zohoapis.com/crm/v2/Contacts
  • List of Deals
    https://www.zohoapis.com/crm/v2/Deals
  • List of Campaigns
    https://www.zohoapis.com/crm/v2/Campaigns
  • List of modules
    https://www.zohoapis.com/crm/v2/settings/modules
  • List of CRM users
    https://www.zohoapis.com/crm/v2/users
  • Roles in your organization
    https://www.zohoapis.com/crm/v2/settings/roles
  • Metadata about the Leads module:
    https://www.zohoapis.com/crm/v2/settings/modules/Leads

Part 5: Handle Pagination

Zoho limits the number of records returned in each request. By default, only 10 records will be returned unless you use the ‘page’ and ‘per_page’ parameters as described in their documentation.
zoho-crm-img9

In API Connector you can loop through these pages automatically with the pagination handling feature, like this:

  • API Request URL: enter your request URL, including the per_page=200 parameter, e.g. https://www.zohoapis.com/crm/v2/Leads?per_page=200
  • Pagination type: page parameter
  • Page parameter: page
  • Number of pages: enter the number of pages you’d like to fetch
    pagination-page-parameter

Part 6: Technical Notes

This integration pulls data from the Zoho CRM API into Google Sheets. It enables the following scopes

ZohoCRM.modules.READ –> Read all the resources in a module
ZohoCRM.org.READ –> Get org data
ZohoCRM.settings.READ –> Get metadata
ZohoCRM.users.READ –> Retrieve user data

Part 7: API Documentation

Official API documentation: https://www.zoho.com/crm/developer/docs/api/v2/modules-api.html

Previous Import Zendesk Data to Google Sheets
Next Import Polar Flow Data into Sheets

Leave a Comment

Table of Contents