如何通过api检测Google表格中的新行或更新行? [英] How can I detect new row or updated row in Google Sheets through the api?

问题描述

有人可以帮助我弄清楚如何通过api检测Google表格中的新行或更新行吗?像网络挂钩吗?

Can anyone help me figure out how to detect new row or updated row in a Google sheets through the api ? Something like a webhook ?

推荐答案

我认为您只能在Apps Script的帮助下完成此操作.您可以在此处使用触发器来检测电子表格中是否有更改. 触发允许Apps脚本在某些事件(例如打开文档，发生.简单触发器是Apps脚本中内置的一组保留函数，例如onOpen(e)函数，该函数在用户打开Goog​​le文档，表格或表单文件时执行.有关更多信息，请查看此相关的 SO问题.

I think you can only do it with the help of Apps Script. You can use a trigger here to detect if something is change in your spreadsheet. The triggers let Apps Script run a function automatically when a certain event, like opening a document, occurs. Simple triggers are a set of reserved functions built into Apps Script, like the function onOpen(e), which executes when a user opens a Google Docs, Sheets, or Forms file. For more information, check this related SO question.

这篇关于如何通过api检测Google表格中的新行或更新行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！