Trigger webhook when Google Sheet edited

google-docs webhooks google-docs-api
sungyong picture sungyong · Dec 7, 2017 · Viewed 7.5k times · Source

I made a google sheet for sharing todo list with co-workers.

My hope is when that sheet is modified, send message to slack channel.

Even if tried to find api related with this, I failed to suitable one.

Is there a appropriate API or webhook?

Answer

noogui picture noogui · Dec 8, 2017

There's Drive API's Push Notifications which lets you watch for changes to resources. You can also use Apps Scripts' onEdit trigger which acts more like a real-time checker.

function onEdit(e){
  // Set a comment on the edited cell to indicate when it was changed.
  var range = e.range;
  range.setNote('Last modified: ' + new Date());
}

This forum might also offer additional insight.

Related questions

wget/curl large file from google drive

I'm trying to download a file from google drive in a script, and I'm having a little trouble doing so. The files I'm trying to download are here. I've looked online extensively and I finally managed to get one of …

Read More
How to turn off page breaks in Google Docs?

How do I turn off page breaks in Google Docs so I just have a single continuous scrolling document? I don't think this method applies anymore. I never want to print out my Google Docs. The page breaks are distracting …

Read More
How To Format A Block of Code Within a Presentation?

I am preparing a presentation using Google Slides, though I can also work on the presentation within Open Office that will include code snippets. Is there any easy way to perform basic syntax highlighting on the code snippets with either …

Read More