✅
Check Sheet
HomeInstallPricingBlogSupport
  • 👋Introduction
  • âŦ‡ī¸Installing
  • 🚀Getting Started
  • 💡Concepts
    • Checks
    • Conditions
    • Values
    • Notifications
  • âœī¸Workflows
    • Creating a Check
    • Editing a Check
    • Deleting a Check
    • Pausing a Check
  • â„šī¸Examples
  • âš ī¸Limits
Powered by GitBook
On this page
  • Targets
  • Email
  • Slack
  • Teams
  • Discord
  • Google Chat
  • Values in Notifications
  • Dynamic Notification Targets
  • Customising Notifications
  • Subject
  • Content
  • Variables
  • Formatting
  • Email
  • Slack
  • Microsoft Teams
  • Discord
  • Google Chat

Was this helpful?

  1. Concepts

Notifications

PreviousValuesNextCreating a Check

Last updated 2 months ago

Was this helpful?

You can set up your checks to send notifications to one or many 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

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

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

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

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

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.

Values in Notifications

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.

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.

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.

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.

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

When the notification is sent these variables will be replaced with their corresponding values.

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

For 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 }}

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

HTML:

<p>
    <b>New Value:</b> {{ value }}
</p>

<p>
    <a href="{{ url }}">View Spreadsheet</a>
</p>

Markdown:

**New Value:** {{ value }}

[View Spreadsheet]({{ url }})

Slack

Microsoft Teams

Discord

Google Chat

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 .

Notifications can be sent to a Slack channel by creating a "webhook" which you can do for free in a few minutes. You can 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/...

Notifications can be sent to a Microsoft Teams channel via their simple and free to install Incoming Webhooks connector. You can to set up your webhook then you just need to copy the URL that Microsoft generates and use that as the notification target.

Notifications can be sent to a Discord channel via their free to use webhook integration system. You can 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/...

Notifications can be sent to a Google Chat space via their free to use webhook integration system. You can 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/...

Note: At present only accounts (paid) can use webhooks with Google Chat.

By default notifications will only include a reference to the of the cell(s) that were found to match your check.

â„šī¸ This feature requires a

Dynamic notification targets work by specifying the cell or range of cells that the target should be retrieved from using .

â„šī¸ This feature requires a

â„šī¸ This feature requires a

A variable is a way to substitute data into the or of the notification. All variables are wrapped with curly brackets with the name of the variable in the middle like so: {{ name }}

The following variables are available, if there's something else you need please .

{{ time }} - The time the match was found {{ cell }} - The 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 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

You can use or to format the content of notification emails.

You can use a that Slack supports to format the content of notification messages.

You can use to format the content of notification messages.

You can use to format the content of notification messages.

You can use to format the content of notification messages.

💡
contact us
follow this guide
follow this guide
follow this guide
follow this guide
Google Workspace
A1 notation
paid subscription
A1 notation
paid subscription
paid subscription
contact us
A1
CSV
A1 notation
Markdown
HTML
subset of Markdown
Markdown
Markdown
basic HTML
targets
Targets
Email
Slack
Microsoft Teams
Discord
Google Chat
Values in Notifications
Dynamic Notifications Targets
Customising Notifications
Subject
Content
Variables
Formatting
subject
content