How it works?

How to Install?

  • Create new or open any sheet in Google Sheets.
  • Go to menu "Add-on" and search for "Jivrus Integra for Zoho" .
  • Install the Application .



Jivrus Integra for Zoho is an application that integrates Zoho with Google Sheets and helps users to get data from several objects and reports into Google Sheet.

Jivrus Integra for Zoho is an application that integrates Zoho with Google Sheets and helps users to get data from several objects and reports into Google Sheet.

  • Zoho objects like Customers, Invoices, Payments etc can be queried to bring the results into Google Sheet.



The Add-on can be reached at Jivrus Integra for Zoho Google Sheet Add-On


How to Setup?

  • Click on "Add-on" > "Jivrus Integra for Zoho" >"Start".

You get the following screen.


  • In "Pick the Apps" field , select the required Applications needed.
  • Click on " GO FOR AUTHORIZATION " .
  • Click on " Connect with Zoho".

You are now successfully connected to Zoho.


  • The Queries Segment Consists of the List of queries that you have executed. If you are Using the sheet for the first time the queries will be empty.
  • Click on "CREATE NEW QUERY" to create new queries.



  • CREATING NEW QUERY
  • Create new Query contains 3 Sections
  1. Query
  2. Source
  3. Destination

1. Query

Give a name to query in the "Query Name" Field.



2. Source

The Source Field Contains 2 Fields

  1. Select Application
  2. Select Object


1. Select Application

Applications are the entity such as "ZohoBooks" , "ZohoInvoice" , "ZohoExpense" , "ZohoSubscriptions".

Select the entity that you want in the "Select Application" dropdown.



2. Select Object

Objects are the entity such as "Expenses" , "Invoices" , "Bills" , etc..

Select the Object that you want in the "Select Object" dropdown.


3 . Destination


  • You can save the data in the New Sheet by selecting the "New" button.
  • Else You can save on an Existing sheet by clicking on "Existing Sheet" button.
  • The New Sheet name Displays the sheet name based on the object type.
  • The Sheet displays the names of the existing sheets. Select the Sheet in which you want to save data


4. GETTING DATA


  • Once you entered the above details you can save your configuration by clicking on the "SAVE" button.
  • If you want to execute the query, you can click on "EXECUTE" button .
  • If you want to go back to the query page click on " BACK " button .


  • Retrieved Data



This is how the data will be displayed in the Spreadsheet.