.png){kind=logo}
Concerns About Google Sheets Lookup Row Function Performance
Hey guys, it’s me or the “Google Sheets lookup row” function is slow af ? it’s like 10 minutes to watch 260 rows
The provided sources don't specifically address performance issues with the Google Sheets Lookup Row function. However, I can explain how the function works: it performs targeted data lookups by searching for specific matches in your Google Sheet using the Google Sheets API, checking row by row based on a column and value match. To potentially improve performance, you could try these approaches: 1. Use specific lookup columns and values to narrow down the search 2. Consider using formulas to trigger the lookup only when needed, rather than running it automatically for all rows 3. Break down larger sheets into smaller batches If you continue experiencing significant performance issues, please ask for human support to investigate your specific case.
Not really ^^
Do I have to share publicly ?
Bo (.··Hey Pierre
Yes, the "Google Sheets lookup row" function can be quite slow. Google imposes very strict rate limits on their API, which is why it's taking this time to process.
Unfortunately, there's not much we can do to speed this up - we're limited by Google's restrictions. The best approach is to be patient while it processes.