1

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
  • 20,717
  • 43
  • 112
  • 130
jchirschy
  • 11
  • 1
  • 3

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,576
  • 2
  • 16
  • 31
  • 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