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.

Possible. You're probably sending `SELECT...WHERE...` query. You should send `INSERT...` query on each edit — TheMaster, Jul 31 '19 at 16:24

score 3 · Answer 1 · edited Jan 02 '20 at 20:34

3

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.

edited Jan 02 '20 at 20:34

Greg Schmidt

5,010
2
14
35

answered Aug 06 '19 at 04:53

stefets

344
2
8

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?

1 Answers1