Critical Issue: Google Sheets Integration Not Adding Unique Entries Correctly | Clay

02 Bugs

Critical Issue: Google Sheets Integration Not Adding Unique Entries Correctly

Maximilian J.

I have a very critical issue with the Google Sheets Integration:

I have 2 sheets, one for logging all entries and another one to only show unique entries in the sheet.
The log sheet works perfectly and every submission is added as a new row.
However, both the combined Lookup&Update AND the manual combination of Lookup first and if false, then add a new row BOTH do not work.
In both cases, new rows for that sheet are simply inserted in the first row, even though there is data in this row already

2 comments

Channeled
APP
·
·
When using the Google Sheets integration, the expected behavior for adding new rows—whether through the "Add Row" action or as part of a "Lookup, Add, or Update Row" workflow—is to append data to the end of the sheet, preserving existing data and structure . If new rows are being inserted at the first row and overwriting existing data, this typically indicates an issue with how the sheet or the integration is configured. Common causes include: ** The sheet may have filters, frozen rows, or formatting that interferes with row placement. ** The integration may be targeting the wrong sheet or range, or the Sheet ID/URL mapping may be misconfigured. ** If the "Lookup" step is not finding a match due to column mismatch or data formatting, the "Add" step might default to the top row if the sheet structure is not standard. To resolve this, double-check: ** The Sheet ID and column mappings in your integration setup. ** That the sheet does not have hidden rows, filters, or merged cells at the top. ** That the lookup column and value are correctly specified and match the sheet's data format , . If the issue persists after verifying these settings, it may require further troubleshooting with a human agent.
Sources: Add Row with Google Sheets Google Sheets integration overview | Documentation | Clay University Lookup, Add, or Update Row with Google Sheets
Maximilian J.
·
·
I think I just solved it 😄 the issue was probably the first cell of the row always being empty