Google Sheets Data Overpopulation Issue: Help Required

Team, For some reason my GoogleSheets enrichment pushing data from my table to GS, is over populating and duplicating data. For example my clay table has 5260 rows in total, and my GS has 10,000. I completely reset the data in the GS to match what's in Clay last night, but 12 hours later, we're back to over populated data.

5 comments

Clay
APP
·
·
This duplication issue is likely caused by your Google Sheets enrichment's auto-update settings. By default, new rows in your Clay table automatically trigger the Google Sheets action, which can cause duplicates. Check your Google Sheets enrichment configuration: • Row Behavior Settings: If you have "Add a row if no existing rows are found" enabled, it may be adding duplicate rows instead of updating existing ones. • Auto-Update: The enrichment runs automatically on new Clay rows by default. Consider using conditional formulas to control when the enrichment triggers. Solution: Switch to the "Lookup, Add, or Update Row" action instead of "Add Row". This lets you specify a lookup column/value to find existing rows and update them rather than creating duplicates. If you need further help troubleshooting the specific configuration, request human assistance by clicking "Talk to a person".
Sources: Google Sheets integration overview | Documentation | Clay University Google Sheets integration overview | Documentation | Clay University Google Sheets integration overview | Documentation | Clay University
Tim C.
·
·
My desired action is to simply add the row of data for each new row that's coming in. There's no "lookup" being performed and no duplication to check. The Clay table itself isn't duplicating row data so I don't understand why data being pushed to GS would be duplicating.
Clay
APP
·
·
The duplication is likely caused by auto-update running multiple times on the same rows. By default, new rows in your Clay table automatically trigger the Google Sheets action, but this can also re-run on existing rows under certain conditions. To prevent this, turn off auto-update for your Google Sheets enrichment: 1. Click the Auto-update icon at the bottom right of your table 2. Click Turn Off Table This will stop the enrichment from automatically running on new or existing rows, preventing duplicates while still allowing you to manually run it on new rows only.
Source: Auto-update and Auto-dedupe Table
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.
Tim C.
·
·
Hari responded but has been out for last 3 hours. Need a resolution to this please.

Google Sheets Data Overpopulation Issue: Help Required | Clay