Is there a way to sync google sheets and MySQL so that an edit in the google sheets table will update the table in MySQL?

Question

I'd like to use google apps script to sync MySQL and google sheets so that someone can edit a google sheets table and it will update a corresponding MySQL table.

I have connected MySQL and google sheets so that I can run queries (including update queries) in google apps script that return a MySQL table. Just not the other way around.

Answer 1

I've had a problem similar to yours and I got an answer to it here on stackoverflow, hopefully it can also help you.

It presents a few solutions: Google Apps Script, Zapier, Kloud, Blockspring and Actiondesk.