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.
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.
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.