How to link Google Sheets to MySQL in real time?

[Igor_do_palido_ponto]

How can I have a sheet that when I update any data there, MySQL updates to and when MySQL change, the sheets change too?

[whitbym]

You could try this:

Create a new row in my MYSQLTable when i add a new row to my GoogleSheet

Hi, im an intern in need i need to create a workflow where when added new data in the googlesheet it gets added to my table in my mysqldatabase. I got to add te first row, then when i added the second it says that the id is duplicated, because the first rows already existis in my table. How to add only the new ones and ignore existing data in the Sheet?

A lot of the time it’s trial and error to see what works for you.

I followed all the n8n tutorials before trying to do anything useful for the tasks I need to do:

Level one: Introduction - n8n Documentation

Level two: Introduction - n8n Documentation

Good luck

[Igor_do_palido_ponto]

Thanks!!

Hello. I have a question for the first link.
If I have 3 rows and change one of them in sheets, this row will show as “A only” but it is a update, not a now row. So, this schema will try to insert it in the MySQL instead of updating. How can I manage that?