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

  • You can filter the records that you need
  • Select the Field
  • Select the Operator
  • Select the value for field
  • You can add more filter by clicking the plus button below

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

  • Select the destination sheet to save the data or create a new sheet by clicking the Add new icon.
  • Give Start Cell Value
  • You can exclude the header by switching off the include header toggle
  • If you need to clear the existing records in spreadsheet on the "Clear sheet before execution" toggle
  • Click on execute to pull the data into sheet
  • Click save to save the service

Sample output: