Hi,
I have an automation set to trigger on any updates, adds, or deletes for a table connected to a Google Sheets data source.
I’m currently facing an issue with at least one specific row: even when I modify it via the application, the automation fails to trigger. However, it works perfectly for all other rows. I can’t figure out why this particular row isn’t triggering the automation, as there are no conditions or security filters applied to it.
The only potential cause I can think of is that I regularly delete empty rows directly within the spreadsheet itself. Could this be impacting how the app recognizes that specific row?
I believe you will obviously need to share more specific details about applicable filters expressions etc. you may be using in the automation.
Could be possible if there is something row number specific in the expressions and after deleting the rows, if the records are changing their row numbers.
Definitely consider @Suvrutt_Gurjar’s post.
Make absolutely sure you have NO duplicate keys. A duplicate key could produce the problem behavior you’re seeing.
Thank you @Suvrutt_Gurjar and @Steve for your replies! I’ve checked, and it isn’t an issue with duplicate keys.
I apologize—I should have checked that first, but your comments definitely pointed me in the right direction: I looked at the logs (Manage > Monitor > Automation Monitor > Launch automation monitor > Runs), and I found that when the automation is adding a new row, a data point is missing.
If you don’t mind, I have a follow-up question. I am getting this error:
Missing value in column: column_name | Expected data type: Text
The automation acts as a data log. Whenever data is modified or updated, it adds a new row to the log table with the updated values. The columns values are mapped as column_name = [column_name]. The issue seems to happen only when the source value is empty. I tried using an IF condition to handle the blanks, like IF([column_name]="", "", [column_name]), but the error persists. Any ideas on how to resolve this?
Wherever it is showing missing value, is it a required column or is there any valid_if expression in those columns? If so please try an expression something like CONTEXT(“Host”)<>“Server” in the “Required_if” or “valid_if” of those columns. Please refer the following post in this regard.
Row 404 not found?