Issues Updating Google Sheet in Lesson 4 of Latest Cohort

Hello support. I'm in the latest cohort. Lesson 4. I *thought* I did everything right. But the final step...updating the google sheet didn't work. this is the link to https://app.clay.com/workspaces/275217/workbooks/wb_0syktleugg7xqv6nyPo/tables/t_0syqvpssN5PBVFf7btc/views/gv_0syqvpsXHmX5sAa3Ps my workspace. any ideas?

12 comments

Clay
APP
·
·
The "Lookup, Add, or Update Row" action requires specific configuration to work properly. Check these key settings: • Lookup Column and Value: Ensure you've specified the correct column in your Google Sheet to search and the matching value from Clay • Row Behavior: Toggle "Update row(s) if existing rows are found" to modify existing rows that match your lookup value • Account Access: Verify your Google Sheets account has write access to the sheet If it's still not working, Google Sheets has rate limits of 300 requests per minute - try waiting a minute and running again. Without seeing your specific sheet setup, these are the most common issues that prevent updates from working.
Sources: Google Sheets [Clay 101] - Clay University Google Sheets [Clay 101] - Clay University Google Sheets integration overview | Documentation | Clay University
Kathleen F.
·
·
nope. those fields were entered correctly.
Kathleen F.
·
·
https://app.clay.com/workspaces/275217/workbooks/wb_0syktleugg7xqv6nyPo/tables/t_0syqvpssN5PBVFf7btc/views/gv_0syqvpsXHmX5sAa3Ps
Kathleen F.
·
·
\]\\
Gabe E.
·
·
Hi Kathleen, I'm looking now and the Sheet appears to have loaded and pulled responses correctly. Is there a particular row or cell that was giving you trouble? Please let me know if I'm missing the problem here! Gabe
Kathleen F.
·
·
Hi Gabriel, So sorry I got distracted by finishing lesson 5. And the 4th of july, etc. i posted insufficiently It's the sync back to my google sheet that isn't working. here's a link to the google sheet https://docs.google.com/spreadsheets/d/1IMgCup6IR2GDXF82B4nNwwQF7Vcx_lb0sEuBFSR6IM8/edit?usp=sharing
Kathleen F.
·
·
the emails didn't populate back.
Bo (.
·
·
Hey, no worries at all. If the emails were already in the Google Sheet, you’d need to use Update Leads to sync changes back—otherwise it won’t push anything. If you’re sending data for the first time, make sure you’re not using Update but instead sending fresh data. Also, the Google Sheet link you shared is private, so just double-check the access permissions on your end. You can either: ** Use Update Leads if the row already exists and you’re updating values ** Or delete the row and re-send it from Clay if it’s a fresh sync Let me know if you have more questions.
Kathleen F.
·
·
Hi Bo, I'm circling back to this -- where is the "Update Leads" capability? And how do I change my 'share
Kathleen F.
·
·
settings.
Bo (.
·
·
Hey, thanks for circling back. To use “Update Leads,” head to your table in Clay and click the “Action” block and add the Update by Google Sheet. As for your sharing settings—open the Google Sheet, click “Share” in the top right, and make sure the link is set to “Anyone with the link can view” (or edit, if needed). Let me know if you have more questions.
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.

Issues Updating Google Sheet in Lesson 4 of Latest Cohort | Clay