Hook Sheet For Notification

starcraftman / cogBot

A discord bot for federals!

BSD 3-Clause "New" or "Revised" License

0 stars 0 forks source link

Hook Sheet For Notification #29

Closed starcraftman closed 7 years ago

starcraftman commented 7 years ago

Rather complicated setup for simple problem.

[ ] Get notification of sheet change to gearbot email.
[ ] Setup forwarding rule for notifications to new email address on server.
[ ] Host new email on server. This step makes me weary, self hosting is an annoying admin task...
[ ] On receive email, use hook to invoke python socket to send message to bot.
[ ] Add receive socket to bot. On receive, execute !admin scan.

starcraftman commented 7 years ago

Possible Sites of interest, use first two to make custom javascript notification.

https://developers.google.com/apps-script/articles/ https://stackoverflow.com/questions/15336907/email-notification-if-cell-is-changed

https://github.com/modoboa/modoboa https://github.com/sovereign/sovereign http://www.iredmail.org/

starcraftman commented 7 years ago

Plan has changed. Mail server idea is out, now using a post to my server to transport data and notify bot of sheet change.

Prototype is on branch web.

Essentially: Sheet javascript posts -> nginx proxy to -> gunicorn/flask handles post -> notify bot via ZMQ pair socket to a background task.

Still needs testing, looking good.

starcraftman commented 7 years ago

Work completed. Main issue remaining is I believe I must be owner of the sheet in question to install a trigger that knows what user edits what line. This step allows me to differentiate bot edits from humans touching sheet.

Work is on test_notify branch ready for merge.

starcraftman commented 7 years ago

Working branch with scheduler using job systems is now on new_notify. Additional testing required, but otherwise I just need to rebase and merge.