How to MySQL just update changed row?

I’m using Google Sheets > MySQL update workflow, but when updating, MySQL check all rows, not just what I changed. How can I manage that?

n8n doesn’t do this for you automatically I am afraid. You could manually build a workflow for such a scenario though. For each of your Google Sheet Items, you could fetch the corresponding rows from MySQL. You could then check if any of the relevant values has changed (for example in an IF node). Only if there is a discrepancy, perform an update.

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.