有没有一种方法可以同步Google表格和MySQL，以便在Google表格中进行编辑将更新MySQL中的表格? [英] 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?

问题描述

我想使用Google Apps脚本来同步MySQL和Google表格，以便某人可以编辑Google表格并更新相应的MySQL表格.

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.

我已连接MySQL和Google表格，以便可以在返回MySQL表的Google Apps脚本中运行查询(包括更新查询).只是没有相反的方式.

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.

推荐答案

我遇到了与您类似的问题，并且得到了答案

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

它提供了一些解决方案:Google Apps脚本，Zapier，Kloud，Blockspring和Actiondesk.

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

这篇关于有没有一种方法可以同步Google表格和MySQL，以便在Google表格中进行编辑将更新MySQL中的表格?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！