Clay Icon

Troubleshooting Slow Google Sheets Lookup Row Performance

Β·
Β·

Why is Google Sheet's Lookup row so slow? It has been over 24 hours, but the Clay table hasn't processed more than a few hundred rows.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    The slow processing of Google Sheets Lookup rows in Clay is likely due to the data being too large or complex to process quickly. This can cause delays or timeouts, especially for sheets with a large number of rows or complex data. To address this issue, you can try: 1. Reducing the number of rows you're processing at once 2. Simplifying the data in your sheet 3. Breaking the data into smaller batches for processing If these steps don't help and you need further assistance, please request human support by clicking on "Talk to a person" in this chat.

  • Avatar of Daniel K.
    Daniel K.
    Β·
    Β·

    Hey Siddhant, thanks for reaching out! The Google Sheets lookup row function can be slow due to strict rate limits imposed by Google on their API, which affects processing speed. This is a common issue, especially when dealing with large datasets. Unfortunately, there isn't much that can be done to speed up the process, as it is constrained by Google's restrictions. The best approach is to be patient while the data processes. You can request an increase to these quotas through the Google Cloud Console, but it's not guaranteed and may take time to process. If there's anything else I can assist you with, please let me know! Have a great Wednesday, Daniel

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·