Comprehensive Query Features

Query data from the applications and presents into Google Sheets

Query service :

  • Query data from the applications and presents into Google Sheets

  • Filter by field name to query the data

  • Can sort the data by ascending or descending

  • Select the needed fields and query data

Use case

> Pull all data from your App objects and store it into a spreadsheet.

Your App

Sheet Director

Google Sheets

Sample query data

Setup

  • If app is connected successfully the following screen appears.

  • Select the required entity.

Select Fields

  • You can select the required fields.

  • Pick up the fields you need under the Fields sections.

Filters

  • Select the Filters as required.

  • Filters include fields, matches, value.

  • Click on Change value picker to change the filter value as value or Cell value.

  • Mention the required cell value.

(or)

  • Click on the edit icon to select the current cell value.

  • Select the maximum result that is required.


Sort

  • You can Sort the records that you need in order

  • Select the Field

  • Select the Order

Max Results

  • You can fetch as much as records you want

  • Select the maximum result that is required.


Destination

  • Destination settings allows users to configure the destination file where the executed data needs to be saved.

  • Click on execute to pull the data into sheet

  • Click save to save the service

Sample output: