Summary

“Alarm Investigations” is a twice-weekly meeting of the Conversion team in which we investigate recent alerts (that didn’t require immediate investigation when they happened). In the meeting we go through this spreadsheet of alerts which is filled by this Google AppsScript script based on our automated alert emails (e.g. from AWS). Usually for each alert we aim to categorise it and link to an existing trello card (if it’s a bug we already know about) or create a new trello card to look into it further (if it’s a new bug or it’s unclear).

AppsScript

The AppsScript project is currently running on Emily Bourke’s gmail account: in the timers section there is a timer that runs a specific deployment (version) of the script every two hours. To move to a new person’s account, she will need to delete that timer and the new person will need to create their own.

When the script runs, it searches for emails from AWS which it hasn’t already processed, adds a line to the spreadsheet for each one, and then applies a label to the email to mark that it has been processed.

Editing the script

If you’ve made changes to the script, you should create a new deployment version by clicking on Deploy > Manage Deployments > Edit (pencil icon) > Version (drop-down) > New Version, entering a description and clicking Deploy. It’s also worth looking at the timers to make sure that they’re running against the new version.