Is there a way to sync google sheets and MySQL so

问题:

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.

回答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.