Search API Connector Documentation


Import Zoho CRM Data to Google Sheets


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


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.
  3. You will be directed to Zoho and asked to authorize the connection. Click Accept.
  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:
  • Endpoint: /crm/v2/org

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

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.
  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.

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
  • List of Leads
  • List of Contacts
  • List of Deals
  • List of Campaigns
  • List of modules
  • List of CRM users
  • Roles in your organization
  • Metadata about the Leads module:

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.

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.
  • Pagination type: page parameter
  • Page parameter: page
  • Number of pages: enter the number of pages you’d like to fetch

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 –> Get org data
ZohoCRM.settings.READ –> Get metadata
ZohoCRM.users.READ –> Retrieve user data

Part 7: API Documentation

Official API documentation:

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

Leave a Comment

Table of Contents