每当使用Cloud Function添加新记录时，是否可以将数据从Firestore填充到Google表格中? [英] Can I populate the data from Firestore to Google Sheet whenever a new record is added using a Cloud Function?

问题描述

我正在尝试构建此应用程序，并计划将其数据存储在Firestore数据库中.我的客户需要Google表格中的数据.

I am trying to build this app where I am planning to store my data in a Firestore database. My client needs the data in a Google Sheet.

我是否可以使用Cloud Function将记录从Firestore直接填充到Google表格中，并且每当有新记录添加到Firestore中时，Google表格就会自动更新?

Can I use Cloud Function to directly populate the records from Firestore to a Google Sheet and whenever a new record will be added to the Firestore, Google Sheet will be updated automatically?

任何人都可以建议任何有关此主题的资源吗?

Can anybody suggest any resource that can help on this topic?

推荐答案

是的，您可以将Cloud函数与Firestore触发器一起使用，在更改Firestore文档时收到通知，在该函数中，您将调用google API来更新google工作表.

Yes, you can use cloud function with Firestore trigger that is notified when your firestore document is changed, in the function you would call google API to update google sheets.

您可以找到端到端的示例经过测试的具有Firestore触发器的云功能应用程序.

You can find an example of end to end tested cloud function app with firestore triggers.

这篇关于每当使用Cloud Function添加新记录时，是否可以将数据从Firestore填充到Google表格中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！