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
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.
I think I just solved it 😄 the issue was probably the first cell of the row always being empty