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 the 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 the 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 many as records you want.

  • Select the maximum result that is required.


Destination

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

  • Click on execute to pull the data into the sheet.

  • Click save to save the service.

Sample output: