Clay Icon

Issues with Google Sheets Lookup Function: Need Assistance

·
·

Hey team, trying to use the lookup for google sheets but its not letting me add the rest of the info once i've added the URL.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    This issue might be related to Google Sheets' API rate limits. There's a limit of 300 read requests per minute per project, and if you exceed this limit, Google temporarily blocks further requests.To resolve this, you can try:1. Wait briefly and retry the operation 2. Ensure you have proper access permissions to the sheet 3. Verify your configuration settings: • Check that you've selected the correct Sheet ID • Confirm your Lookup Column and Value are properly specified • Make sure you've enabled the appropriate row behavior options (Add/Update) for your needsIf you're trying to update existing rows, make sure you've toggled on "Update row(s) if existing rows are found" in your configuration settings.If you need further assistance, please request human support by clicking on "Talk to a person". Source: Google Sheets - Clay University

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!

  • Avatar of Daniel K.
    Daniel K.
    ·
    ·

    Hi Aaron! Thanks for reaching out! If you're encountering issues with the Lookup, Add, or Update Row action in Google Sheets, ensure that you have edit access to the Google Spreadsheet you're trying to interact with. The URL you provide must be a Google Spreadsheet where you have the necessary permissions. Additionally, when setting up the action, you need to specify the Sheet ID, the Lookup Column, and the Lookup Value you want to find. Make sure that the Lookup Column and Value you're using to search for a match in Google Sheets are correctly specified and that they match exactly with the corresponding column in Google Sheets. If no matching row is found, a new row can be added; if a match is found, the existing row can be updated with new information. For more detailed guidance, you can refer to the API documentation provided by Clay for Google Sheets integrations. Here are some steps to troubleshoot: * Confirm that the Google Spreadsheet URL is correct and that you have edit access. * Verify that the Sheet ID, Lookup Column, and Lookup Value are correctly set up in Clay. * Ensure that the values you're looking up match exactly with the corresponding entries in your Google Sheet. If these steps are correctly followed and you're still facing issues, it could be due to a mismatch in the lookup criteria or other settings within the Clay action. For a step-by-step tutorial on how to use the Lookup Row action, you can follow the Clay University Google Sheets Tutorial. Of course, let me know how this goes and if the issue persists, happy to dive deeper here :)

  • Avatar of Aaron B.
    Aaron B.
    ·
    ·

    Hey, I don't actually get the option to add a sheet ID, lookup column and value in the UI. Is this due to the URL I have provided? The spreadsheet has full editor access

  • Avatar of Aaron B.
    Aaron B.
    ·
    ·

    t_zfRMgFbDvudr

  • Avatar of Aaron B.
    Aaron B.
    ·
    ·

    Thanks Daniel, That got it working 🙂

  • Avatar of Aaron B.
    Aaron B.
    ·
    ·

    Appreciate the support!

  • Avatar of Daniel K.
    Daniel K.
    ·
    ·

    Awesome, you're welcome! :)

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Aaron B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thank you so much for sharing your feedback Aaron B.!