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
Query service setup :
Setup
If the app is connected successfully the following screen appears.
Select the required entity.
Fields Selection :
Select Fields
You can select the required fields.
Pick up the fields you need under the Fields sections.
Filters set up :
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 set up :
Sort
You can Sort the records that you need in order.
Select the Field.
Select the Order.
Max Results :
Max Results
You can fetch as many as records you want.
Select the maximum result that is required.
Destination set up :
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:
