Zoho Creator

Zoho Creator to Google Sheets: Query from Zoho Creator into Google Sheets

What is Sheet Director?

Sheet Director is a G Suite add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho etc.

It is available in the G Suite Marketplace and Chrome Web Store. Please check Installation instructions to install the add-on.


What is Zoho Creator?

Zoho Creator is a cloud software to create custom applications on your own without any prior coding experience or IT expertise. Zoho Creator's drag-and-drop interface enables you to create custom business applications in days rather than weeks.

Zoho Creator to Google Sheets: Use Case(s)

> Pull all data from Zoho Creator objects and store it into a spreadsheet.

Zoho Creator

Sheet Director

Google Sheets

Setting Up Zoho Creator in Sheet Director

Choose App and Service :

  • Select Zoho Creator from the list of applications.

  • Select Service.

Zoho Creator Configuration

  • Click on connect to Zoho Creator to connect to Zoho Creator so that you can pull data.

Zoho Creator to Google Sheet - Query

  • If Zoho Creator is connected successfully the following screen appears.

  • Select the owner from owners list.

  • Select the Application name from which you want to query.

  • Select your report from report list.

  • Finally, Select your form name from the list.

Note:

  1. Before selecting fields make sure you have given all the information above.

  • Select the required fields.

  • Select the maximum result that is required.

  • Select the destination sheet to save the data or create a new sheet by clicking the Add new icon.

Sample Output