Notifications
You can set up your checks to send notifications to one or many targets via Email, Slack, Microsoft Teams, Discord or Google Chat. To add notifications to a check click the Add
button under Notifications
at the bottom of the create/edit check window.
If you are checking a range of cells you can choose whether to receive a notification just the first time a check matches or each time a new match is found. For example if you had a column with stock statuses you could either receive a notification just the first time a value goes from "In Stock" to "Out of Stock" or each time that occurs.
Targets
The target is where your notification will be sent to and can be one of the following. If you would to see another type of target supported please contact us.
Email
Notifications can be sent via email to yourself, your team or anyone you want by specifying the email address as the notification target.
To add multiple Email notifications add each email address on a separate line when typing into the text box by pressing the enter key.
Slack
Notifications can be sent to a Slack channel by creating a "webhook" which you can do for free in a few minutes. You can follow this guide to set up your webhook then you just need to copy the URL that Slack generates and use that as the notification target. It should look something like: https://hooks.slack.com/services/...
To add more than one Slack notification add each URL on a separate line when typing into the text box by pressing the enter key.
Teams
Notifications can be sent to a Microsoft Teams channel via their simple and free to install Incoming Webhooks connector. You can follow this guide to set up your webhook then you just need to copy the URL that Microsoft generates and use that as the notification target.
To add more than one Microsoft Teams notification add each URL on a separate line when typing into the text box by pressing the enter key.
Discord
Notifications can be sent to a Discord channel via their free to use webhook integration system. You can follow this guide to set up your webhook then you just need to copy the URL that Discord generates and use that as the notification target. It should look something like: https://discordapp.com/api/webhooks/...
To add more than one Discord notification add each URL on a separate line when typing into the text box by pressing the enter key.
Google Chat
Notifications can be sent to a Google Chat space via their free to use webhook integration system. You can follow this guide to set up your webhook then you just need to copy the URL that Google generates and use that as the notification target. It should look something like: https://chat.googleapis.com/v1/spaces/...
To add more than one Google Chat notification add each URL on a separate line when typing into the text box by pressing the enter key.
Note: At present only Google Workspace accounts (paid) can use webhooks with Google Chat.
Values in Notifications
By default notifications will only include a reference to the A1 notation of the cell(s) that were found to match your check.
If you want to include matching values from your spreadsheet you can enable the Include Values
setting for your notification as shown in the screenshot below.
âšī¸ This feature requires a paid subscription
Dynamic Notification Targets
If you wish to set the notification target based on a value in your spreadsheet you can do so using dynamic notification targets.
Dynamic notification targets work by specifying the cell or range of cells that the target should be retrieved from using A1 notation.
To set the notification target based on a single cell such as C4
you would set your notification target to: =C4
.
To set the notification target based on a range of cells such as a column you need to specify a range that matches the size of the range of your check. For example if your check was evaluating if any value in the range A2:A
was greater than 10 you could set the notification target to retrieve the email addresses stored in column B by setting the target to B2:B
which is a range of equivalent size. The corresponding cell will be selected and the notification sent to the value of that cell. Using the same example if a new match was found in A10
then the notification would be sent to the value of the cell B10
.
âšī¸ This feature requires a paid subscription
Customising Notifications
For some use cases you may want to customise the content of our notifications to include things such as the matching values or format them differently so they can be sent to third parties.
âšī¸ This feature requires a paid subscription
Subject
For Email notifications this is the subject of the Email, for Slack, Microsoft Teams, Discord or Google Chat this is the value used to summarise the message used in push notifications.
Content
This is main content or body of the Email, Slack, Microsoft Teams, Discord or Google Chat message.
Variables
A variable is a way to substitute data into the subject or content of the notification. All variables are wrapped with curly brackets with the name of the variable in the middle like so: {{ name }}
When the notification is sent these variables will be replaced with their corresponding values.
The following variables are available, if there's something else you need please contact us.
Spreadsheet
{{ spreadsheet }}
- The name of the Spreadsheet
{{ sheet }}
- The name of the Sheet the Check is on
{{ url }}
- A link to the Spreadsheet
Check
{{ check }}
- The name of your Check
{{ description }}
- A description of what your Check does
{{ range }}
- The range or cell your Check is on
{{ when }}
- What set of cells must match if the range contains multiple
{{ expected }}
- The expected value of your check
{{ condition }}
- The condition your check must meet
Data
{{ time }}
- The time the match was found
{{ cell }}
- The A1 position of the new match found
{{ value }}
- The value of the new match found
{{ row }}
- The values of the entire row the match was found in CSV format
{{ column:A }}
- The value of one of the columns in the matching row
{{ A1:A10 }}
- The value(s) of any cell or range provided using A1 notation
For example, to create a notification with the following content for a check that was monitoring when a stock price exceeded a threshold:
You would use variables like so, in this example the column A
contains the name of the stocks:
Formatting
You can apply formatting to the content of your notifications such as highlighting key information in bold.
What formatting options are available depend on the type of notification you can sending:
Email
You can use Markdown or HTML to format the content of notification emails.
HTML:
Markdown:
Slack
You can use a subset of Markdown that Slack supports to format the content of notification messages.
Microsoft Teams
You can use Markdown to format the content of notification messages.
Discord
You can use Markdown to format the content of notification messages.
Google Chat
You can use basic HTML to format the content of notification messages.
Last updated