How to get Slack, Discord or Google Chat alerts before dates in a Google Sheet

By Jake Marsh · Updated

To get chat alerts before dates in a Google Sheet, create an incoming webhook in Slack, Discord or Google Chat, then in Extensions > Due Date Reminders > Open reminders set up a reminder on your date column and paste the webhook link under Chat, weekly summary and sender options > Also post to Slack, Discord or Google Chat. Each reminder is posted to that channel, with or without an email, every time a date comes due.

Get the webhook link

  • Slack: create an app with Incoming Webhooks turned on and add a webhook to the channel. The link starts with https://hooks.slack.com/services/.
  • Discord: in the channel's settings, open Integrations > Webhooks, click New Webhook and copy its URL. It starts with https://discord.com/api/webhooks/.
  • Google Chat: in the space, open Apps & integrations > Webhooks, add one and copy the URL. It starts with https://chat.googleapis.com/v1/spaces/.

Due Date Reminders only accepts links that start with these addresses.

Steps

  1. Open the spreadsheet and choose Extensions > Due Date Reminders > Open reminders, then New reminder.
  2. Pick the Sheet and Date column, for example a Deadline column on a project tracker.
  3. Choose the days under When to remind: say 3 days before and on the day.
  4. Set Skip rows that are done if the sheet has a Status or Done column.
  5. Open Chat, weekly summary and sender options and paste the webhook link.
  6. Leave Email addresses empty to post to chat only, or add addresses to email as well.
  7. Write the Subject and Message. In chat, the subject is posted in bold above the message, for example:
Subject: {{Task}} is due {{days}}
Message: Owner: {{Owner}}. Open the tracker: {{link}}
  1. Click Preview next 30 days to see which rows will be posted and when, and Send test to me to check the wording by email (tests go to your inbox, not the channel). Then Turn it on.

One post per row or one roundup

With Delivery on One email per row, every due row is its own post. With One combined email per person per day, the channel gets one post per run listing every row due, each on the line you set in Line for each row in combined emails and summaries, which keeps a busy channel quiet.

Good uses

  • Team deadlines posted to the project channel the day before.
  • Contract renewals to an operations channel 30 days ahead.
  • On-call or shift changes posted the morning of.
  • Overdue items reposted every few days with Then keep reminding every N days until the row is done.

To get alerts when a Google Form is submitted rather than when a date comes up, see Form Bugle.

What it costs

The trial covers 50 notices or 14 days, whichever comes first. Then $4.99 a month or $39 a year. Install from the Due Date Reminders page.

Due Date Reminders

Email and chat reminders before the dates in your Google Sheet, even with the sheet closed $4.99 a month or $39 a year per Google account.


Questions

Can Google Sheets send notifications to Slack by itself?

No. Sheets' own notifications are emails about edits. Due Date Reminders posts to Slack, Discord or Google Chat based on dates in your cells.

Can I post to more than one channel?

Each reminder posts to one webhook. Set up a second reminder on the same date column with another channel's webhook.

Does the post include a link to the row?

Yes, if you add {{link}} to the message. It opens the spreadsheet at that row for anyone who has access to the sheet.

Will it post again if nothing changed?

No. Each reminder day is posted once per row. It posts again only for the next reminder day, or for overdue follow-ups you turned on.


More Due Date Reminders guides


More Google guides