Selecting a row from a google sheet using Apps Script in app Inventor

How to select a row from a big google sheet using Apps Script in App Inventor? So that the searching process is fast in the App.

These should help:!searchin/mitappinventortest/select$20cell|sort:date/mitappinventortest/tatdg8aVXDY/oI_6VRndDAAJ

or read through:

AI2 and Google Drive/Docs/Sheets
HOWTO: Query Any Google Sheet with a Web App.
UPDATED! HOWTO - Upload Any File to Google Drive !
HOWTO: Use AI2 to directly submit Google Form Data
HOWTO: Google Drive - Multiple Files Download (file by file)
HOWTO: Download Google sheet as CSV
HOWTO: Send Data to Google Sheet with Web App
HOWTO: Show Image from Google Drive
HOWTO: Upload Image to Google Drive using base64 and Google Apps Script Web App
HOWTO: Upload Image to Google Drive using base64 using Camera Image
HOWTO: Get Data from Private Google Sheet with A Google WebApp
HOWTO: Get the ID of Image after uploading using base64
HOWTO: Upload CSV or List to Google Sheet
HOWTO: AI2 - Google Sheets - Web App - Create/Read/Update/Delete
HOWTO: OCR Images and Camera Pictures with Google Docs
HOWTO: OCR pdf and image files using Google Docs OCR function
HOWTO: Upload "Any" File to Google Drive
HOWTO: Use google web app and google query to download filtered output as pdf from Google Sheet
HOWTO: Use Ai2 to Delete Images (or other files) on Google Drive
HOWTO: Take Photo, get GPS Location and Address, upload Image to Google Drive, and save Location data to spreadsheet 
HOWTO: Select a Single Row from a Spreadsheet, and howto EDIT that data

Thank you so much for your help. All I want to do is to search from a big google sheet using a value that the user will enter and it will return the other column values for that row. I did it by downloading the whole sheet in the app and it works perfectly for small sheets. But for large sheets(size around 50 mb), it takes a lot of time to download the whole file and this makes the app very slow. Can you please help me by showing an example like this. I mean, I want to see what script I need to write and also the blocks for the App Inventor.

That is a massive spreadsheet!

There are examples provided in the links I put up. Let us know when you get stuck.

In this situation, you should look for options to use SQL-like query syntax to filter the sheet at the upstream server and send back only the requested row.

From the links earlier in this thread, I would follow

Thank you so much for your support. It really means a lot. I will be able to do it now I guess. :blush: