Skip to main content
Question

Slack reminder when inputted date is reached in Google Sheet

  • December 13, 2024
  • 1 reply
  • 36 views

Hi,

 

Is it possible to have a notification on Slack when a date, which is manually inputted by me, is reached in Google Sheets column?  Would love the ability to get reminders when my “Task Due Date” occurs.

 

Thanks!

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • December 14, 2024

Hi ​@mshoer 

I’d recommend using Airtable instead of GSheets.

Try these Zap steps:

  1. Trigger: Airtable - New Record
    1. View: configure a View with a Filter that looks for a Date field that has a value equal to Today
    2. Help: https://zapier.com/apps/airtable/integrations#help
  2. Action: Slack - Add Reminder
    1. Help: https://zapier.com/apps/slack/integrations#help

 

If you want to use GSheets, try these Zap steps:

  1. Trigger: Schedule
    1. Interval: Daily
    2. Help: https://zapier.com/apps/schedule/help
  2. Action: Formatter > Date & Time > Format Date
    1. Date: Today
    2. Help: https://zapier.com/apps/formatter/help
  3. Action: GSheets - Lookup Rows
    1. Help: https://zapier.com/apps/google-sheets/integrations#help
  4. Action: Filter
    1. Check if Rows were returned
    2. Help: https://zapier.com/apps/filter/help
  5. Action: Looping - Create Loop from Line Items
    1. Used to iterate if there are 1+ Rows returned
    2. Help: https://zapier.com/apps/looping/help
  6. Action: Slack - Add Reminder
    1. Help: https://zapier.com/apps/slack/integrations#help

 

Slack also has native Lists functionality: https://slack.com/help/articles/27452748828179-Use-lists-in-Slack