Get a Message When Something Important Happens
a) Destroying your productivity by stopping every 5 minutes to check a dashboard
b) Finding out 6 hours too late that an important customer was getting error after error on a critical task
It's a tough choice, and there should be another option. Well, a SeekWell alert can be that option! You can automatically send messages to your team or to customers when there are important changes in the data.
Right now SeekWell is set up to send alerts to Slack, but if there are other platforms you'd like to use (e.g., Sendgrid, Twilio, etc.) we'd love to hear about them and work with you to get them implemented.
In the meantime, here's a step by step process for setting up a SeekWell Alert using Slack:
0. If you don't yet have a SeekWell account, get started at seekwell.io.
1. Send a query or script result to Sheets
While this is necessary to create the schedule, the content of this query is not important. However, we recommend making it a historical record of the alert you're planning to create. For example, if the alert is "new account created" make the query return all accounts that have been recently created. Check here for a quick video on sending a query to a Sheet.
2. Write the code that will trigger your alert
In a second code cell, write a query or script that will only return rows if the event you care about has happened since the last check. For the "new account created" example, this might look like this:
SELECT email, plan_id FROM analytics.payments as p WHERE date_trunc('hour', p.created_on) = date_trunc('hour', (CURRENT_TIMESTAMP - INTERVAL '1 hours'));
This query will look for payment details set up in the previous hour. If I set the schedule to run a few minutes after each hour, I'll get a result for each account created in the prior hour.
3. Send the results to a Slack channel
Note: If you have not yet added the Slack integration, you can do so atseekwell.io/profile
At the bottom of the trigger code cell, change the destination from Sheets to Slack, and indicate the correct channel (e.g., #alerts)
4. Set the schedule
Click the clock icon at the top of the app and choose the frequency for your update. Be sure that the frequency is relevant to your code, (e.g., hourly for a query that looks for changes in the last 60 minutes). See here for more information on how to set a schedule.
5. Manage your schedule
You can manage your schedules from the "runSheet" in the workbook (do not delete this sheet), or from your profile page.
Let us know how it goes and what other platform integrations you'd like to see. As always, you can reach us on the in-product chat or at firstname.lastname@example.org. For a quick chat or a demo of this feature or other capabilities, just book a convenient time here.