.png){kind=logo}
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.
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.
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
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!
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 :)
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
Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1732876200&signature=7c7af5f3d0c8103240b8ed76bbdb73e17bb345d0978f379e535b3e46e80708c8&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSn0AZEU2BKsam%2FhVPuMEQ%3D%3D%0A
t_zfRMgFbDvudr
Thanks, can you try saving it as a Google Sheets file like so and retry? https://downloads.intercomcdn.com/i/o/w28k1kwz/1270232194/ca6c7870c64ee80c6fdf05902266/Arc_xwNEUG4iOf.png?expires=1732877100&signature=a62c983325b1e7dc1b17b19212c072d5317b8e945726782391dc7ae2003d981f&req=dSIgFst9n4BWXfMW1HO4zdXeIRxpOHuskfwFFGvVTrK0nc%2BZ1zDBK1CNPo2K%0Affcr%0A
Thanks Daniel, That got it working 🙂
Appreciate the support!
Awesome, you're welcome! :)