Troubleshooting Google Sheets Lookup, Add, or Update Integration Issues

·

I'm trying to use the Google Sheets integration "Lookup, Add, or Update" and my table is saying that I am missing inputs - I believe this is because when I edit the column in my Clay Table, I don't have any option for Lookup Fields. First picture is how the column edit should look, and the second picture is how my screen looks

2 comments

Channeled
APP
·
·
To properly set up the "Lookup, Add, or Update" action in Google Sheets integration, you need to follow these specific steps: 1. Select your Google Sheets account (make sure it has read/write access) 2. Paste your Google Spreadsheet URL 3. Specify the Sheet ID 4. Configure the Lookup Column and Value: • The Lookup Column is where you want to search for matches in your Google Sheet • The Lookup Value is what you want to find from your Clay tableIf you're not seeing the Lookup Fields options, make sure you've completed the first three steps above, as the Lookup Fields configuration options will only appear after you've properly connected to your sheet and specified the Sheet ID. Source: Google Sheets integration overview | Documentation | Clay University
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.