如何查询我的数据库并将其输出到Google表格上，以便某人可以编辑此数据，然后将其反映回MySQL? [英] how to query my database and have it be outputted on a Google Sheet so that someone can edit this data and then have it reflected back in MySQL?

问题描述

我想将一些数据从MySQL推送到Google表格中.在Google表格中编辑数据后，我想将编辑后的数据推回到MySQL中.理想情况下，我什至希望安排它每小时更新一次，因此我的数据始终是实时的，并且与MySQL中的数据匹配.

I’d like to push some data from MySQL into Google Sheets. Once I’ve edited my data in Google Sheets, I’d like to push my edited data back into MySQL. Ideally, I’d even like to schedule it to update it every hour, so my data is always live and matches what's in my MySQL.

我研究了Google Sheets脚本，它似乎使您可以在Google Sheets的单元格中输入SQL查询并检索您查询的数据.但是，主要问题是，即使我找到了将数据导出到sql的正确方法，也是我在多个电子表格中拥有数百个标签，并且我想找到一种避免为每个标签手动重复执行此作业的方法.

I’ve looked into Google Sheets Script and it seems that it enables you to type in a SQL query into a cell in Google Sheets and retrieve your queried data. However, the main issue, even though I find a proper way to export my data to sql, is that I have hundreds of tabs across multiple spreadsheets and I’d like to find a way to avoid to manually repeat this job for every tab.

请记住，这是针对我们团队中无法弄清楚用SQL查询，难以使用MySQL进行导航并且我不想接受SQL训练的人.我只想让这个人编辑Google表格，并将这些编辑反映在MySQL中，而不必让这个人进入我的SQL数据库.

Please have in mind that it is for someone on my team who can’t figure out querying with SQL, has a hard time navigating MySQL, and that I don’t want to train in SQL. I would just like this person to edit Google Sheets and these edits to be reflected back in MySQL, without this person ever having to go into my SQL database.

推荐答案

我认为您也可以使用Google Apps脚本来回推mySQL中的数据.但是，我不知道该解决方案的可扩展性.

I think you can also use Google Apps Script to push back the data in mySQL. However, I don't know how scalable this solution would be.

有些工具可以将数据从SQL导出到Google表格，例如Zapier以及诸如Kloud和Blockspring之类的附加组件. Blockspring的好处是，它面向的是熟悉SQL查询的人.这些解决方案都不允许您将编辑数据推回到数据库中(至少，据我所知...否则将非常有兴趣).

Some tools exist to export data from SQL to Google sheets, like Zapier and add-ons such as Kloud and Blockspring. The thing with Blockspring is that it's targeted to people that are familiar with SQL queries. And none of those solutions allow you to push the edit data back to your database (at least, that I know of... would be very interested if it is otherwise).

因此，一种选择是使用Actiondesk将SQL数据库与Google表格同步.您可以每小时安排一次同步(实际上甚至是每十分钟安排一次)，并且可以随时随地轻松地添加新的工作表/标签(只需单击几下即可).

So an option would be to use Actiondesk to sync your SQL database with your Google Sheets. You can schedule the synchronisation every hour (even every ten minutes actually), and it would be easy to add new sheets/tab anytime you need to (it's just a matter of few clicks).

希望这会有所帮助！

免责声明:我是Actiondesk的后端工程师，并且亲自实现了Googlesheets集成，因此我可能会有偏见(但与此同时，我可能是回答有关这方面最棘手问题的最佳人选，因此请随意射击)！

Disclaimer: I am a back-end engineer at Actiondesk and personally implemented the Googlesheets integration, so I might be kind of biased (but at the same time, I might be the best person to answer your wildest questions on that regard so feel free to shoot them)!

这篇关于如何查询我的数据库并将其输出到Google表格上，以便某人可以编辑此数据，然后将其反映回MySQL?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！