0

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 ?

Billal Begueradj
  • 17,880
  • 38
  • 105
  • 123
jchirschy
  • 1
  • 1
  • 2

1 Answers1

2

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.

Community
  • 1
  • 1
KENdi
  • 7,670
  • 2
  • 15
  • 27
  • Very interesting. I've never used Apps script yet. Is there a way to get a push notification or something similar through an Apps script function to use it outside of Google ? – jchirschy Oct 28 '16 at 12:25
  • is there any way to know one row is completely edited ? onedit or onchange not working. –  Jul 03 '19 at 11:28