I feel like this happens all the time but can’t figure out why it won’t let me edit the field mapping on a google sheet enrichment, It was working and then I went to edit later and now it stopped.
This issue is likely related to your Google account connection. Check if you're using the correct Google account for the integration. If you're using the wrong account, you'll need to remove the current connection and reconnect with the correct Google account that has proper access to the sheet. When this happens, you won't be able to see or edit the fields to map columns properly.
thats not it, I tried switching users and same thing. I even changed to different tabs in the same workbook and it worked.
This usually happens when the table you’re connecting to has no header or duplicate headers — that can block field mapping from loading properly.
In your case it's because of duplicates!
Double-check that each column in your Google Sheet has a unique header in the first row. Once that’s cleaned up, you should be able to edit the mapping again. Let me know if it’s still not working after that.
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.