Comparing data between Google Sheet and MySQL table

Questions
1

Currently I’m working with N8N to help me keep track of things in my environment and update data points that I use in my personal tools and applications. I have a Google Sheet and am trying to compare it to an SQL table that I have, and if there is any difference in the Sheet, update it within the table. I have both data sets being read, but when I put them into a Compare Datasets node, it returns the data as matching, regardless of what I update and change on the Sheet side.

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 1.11.1
  • Database (default: SQLite): MySQL
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Cloud VPS
  • Operating system: Alma 8
2

You could also try a merge by fields, something like this:

match
match592×645 25.3 KB

2 Likes
3

I see, that does seem like a good idea, but I only want it to do it if the data doesn’t match, There’s only a handful of fields that change in that sheet.

4

you can do this with the above option :slight_smile:

1 Like
5

I see, I did actually give it a shot and it actually did exactly what I was looking for! I appreciate your input!

2 Likes
6

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