I have a database on google sheets of around 100,000 record lines. Is there a way for me to do a search on them without brining them into glide? note: my app is completely based on glide sheets. So i need to do some sort of api call

You can use a lookup formula if you don’t want to pay. The workbook that has the data you need you just have it equal the data you need to lookup and run the lookup on that workbook and the sheet you need the data returned to equals the cells with the results. Quite simple actually.

hi thanks for your reply. my glide app has no connection with googlesheets, it operated directly on glide tables. I need a use a API to lookup googlesheet database and pull the results into glide. I have no idea how to use sheets API inside glide

Hola! How long would you like to wait for an API answer using your GS with 100k rows: 2, 5, 8 or 10 sec? GS is not a real database and has its limitation to find a value (row) quickly no matter your data has a kind of order or not. There are some tricks to improve the API answer but all depends…

Thanks for replying back. I dont mind waiting 10 sec for the data to come back. Can you please let me know how i can do this? im new to api with glide

check this one out: [image] English Dictionary with 163,819 rows! Project Showcase this is example how to use big numbers of rows in free or paid App… enjoy! (in this app i’m using 163,819 rows but i can easy add up to 2 millions) [Screen Shot 2021-07-03 at 12.04.07 …

So there’s a work around I built quite some time back. Create a table. Add 10 blank rows in it. Add a single value column that brings in your searched value here. Add a coloumn for rowNo. Do your api call and limit the results to 10 rows. For each row get a json depending on rowNo. In another colo…

This sounds good. I just need to know how to use API for GSheets. any steps i can follow along with?

Hey @Amal So a short process on how to use API calls. In your google sheet, go to tools → App Script or Extension → Appscript. So the page that opens up is the a code block where you can write typescript/javascript code. The following script is already linked to your google sheet. [image] So …

Hola de nuevo @Amal I have a demo APP for what you want. I turned a GS into a REST API and works fine so far, with 45k rows and 8 columns the API calls reply around 4-6 secs. Let me find some free time to make some modifications to my APP (e.g. translate it to english) to help you when you test it…

Pull data from a large source

Ask for Help

SantiagoPerez December 6, 2021, 8:34pm 2

Hola @Amal

Take a look at this thread.

Topic		Replies	Views
Import your Glide Table into any Google Sheet, with 1 formula! Project Showcase	19	1064	July 16, 2023
A Google Sheet working as a REST API: good or bad idea? 💣 Project Showcase	9	1965	August 28, 2023
Use API to Get All Rows from Glide Table to Google Sheet Ask for Help	9	1196	November 23, 2022
AppScript Ask for Help	11	277	December 28, 2023
Glide Big Tables API! Get your big table to your google sheet! Community Resources tutorial	5	873	November 1, 2023

Pull data from a large source

Related topics