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.
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.
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.
Notifications can be sent to a Slack channel via their simple and free to install Incoming Webhooks app. 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.
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.
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.
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.
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.
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.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.
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.
This is main content or body of the Email, Slack, Microsoft Teams, Discord or Google Chat message.
When the notification is sent these variables will be replaced with their corresponding values.
{{ spreadsheet }} - The name of the Spreadsheet
{{ sheet }} - The name of the Sheet the Check is on
{{ url }} - A link to the Spreadsheet{{ 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{{ 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 notationFor example, to create a notification with the following content for a check that was monitoring when a stock price exceeded a threshold:
A new match was found in A2 for Sell in Stocks at 17:44:30.
Name: GOOG
Target: 100
Price: 105
You would use variables like so, in this example the column
A contains the name of the stocks:A new match was found in {{ cell }} for {{ check }} in {{ spreadsheet }} at {{ time }}.
Name: {{ column:A }}
Target: {{ expected }}
Price: {{ value }}
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:
HTML:
<p>
<b>New Value:</b> {{ value }}
</p>
<p>
<a href="{{ url }}">View Spreadsheet</a>
</p>
Markdown:
**New Value:** {{ value }}
[View Spreadsheet]({{ url }})
You can use a subset of Markdown that Slack supports to format the content of notification messages.
Last modified 3mo ago