Clay Icon

Issues with Google Sheets After Excessive Lookups

Β·
Β·

Does this happen with gSheets over-usage? I did over a thousand gsheet lookups then this started happening... and the configuration has gone all weird now, all fields have disappeared and don't refresh in edit column.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    While over-usage of Google Sheets lookups can potentially cause performance issues, it's not directly linked to disappearing fields or configuration errors in Clay. Our Google Sheets integration allows for multiple actions, including lookups, but there are no specific limits mentioned for these operations. If you're experiencing issues with disappearing fields or configuration errors, it's more likely a separate problem. To troubleshoot: 1. Check your Google Sheets connection in Clay's Settings > Connections. 2. Ensure your Google account has proper access to the sheet. 3. Verify the correct Sheet ID and lookup columns are specified in your Clay setup. If the problem persists, it might be a technical issue unrelated to Google Sheets usage. In this case, you should request human assistance by clicking on "Talk to a person" for more in-depth troubleshooting.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    While performing many Google Sheets lookups isn't directly linked to disappearing fields or configuration errors, it's possible you're experiencing a technical issue. Here are some steps to resolve this: 1. Clear your browser cache and refresh the view. This often resolves persistent error messages in Clay. 2. Check your Google Sheets connection in Clay's Settings > Connections. Ensure your Google account has proper access to the sheet. 3. Verify that the correct Sheet ID and lookup columns are specified in your Clay setup. If these steps don't resolve the issue, it might be a more complex technical problem. In that case, request human assistance by clicking on "Talk to a person" for more in-depth troubleshooting.

  • Avatar of Mark L.
    Mark L.
    Β·
    Β·

    Thanks for raising this. Our engineers spotted this, and have a fix in place. Please let me know if you still have issues later on.

  • Avatar of Mark L.
    Mark L.
    Β·
    Β·

    I think we might have everything needed here, given the fix for the Google Sheets issue that was put in place yesterday. I'll tentatively mark this closed for the moment, but please keep in touch if you hit other roadblocks. Thanks again for letting us know about this.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·
  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Thank you so much for sharing your feedback ​Daniel B.​!