Skip to main content
Question

How do I send a Slack notification when a date is reached in my google sheet

  • December 31, 2024
  • 3 replies
  • 31 views

As the title. 

I have a list of tasks and due date manually added in the google sheet. 

I want to send slack reminder automatically on the due date to the assignee directly. 

 

I have tried:

trigger: google sheet

action: new rows or modification of rows

 

delay until - based on the date in my google sheet: e.g. 31/12/2024 ( I have changed the timezone to GMT for both zap and google sheet)

 

then slack: find user based on name. I have error for this step:

“The error you're encountering is due to Slack's API rate limit being exceeded. To resolve this, you can add a "Delay After Queue" action before your Slack action in the Zap. Set the delay to 1 minute or more to ensure that your actions are queued and executed one by one, preventing the rate limit from being exceeded.”

 

However even I added the Delay After Queue to 2 minuts, still not working and keep giving me the same error message. 

 

Could you advice how to proceed? or any other better way. 

I only want to use google sheet or JIRA ticket (with assignee and due date available in the ticket) and send slack direct message on the due date. I cannot use google calendar. 

 

I have also tried this approach 

 

but not working with same error: “The error you're encountering is due to Slack's API rate limit being exceeded. To resolve this, you can add a "Delay After Queue" action before your Slack action in the Zap. Set the delay to 1 minute or more to ensure that your actions are queued and executed one by one, preventing the rate limit from being exceeded.”

Did this topic help you find an answer to your question?

3 replies

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7304 replies
  • January 2, 2025

Hi ​@orangeh6611! 👋

That’s very strange. Are you seeing that “The error you're encountering is due to Slack's API rate limit being exceeded” error only while testing in the Zap editor?

If so, is it still erroring if you attempt to test the Slack action again now? If it does can you share a screenshot of the Configure section of the Slack action? That will help us to see if there’s any issues on the setup that might be causing some trouble. Make sure to blur or remove all personal information (names, emails, addresses etc.) from screenshots before sharing - you can use a tool like Zappy for that. 

If not, did you run into it while the Zap was switched on? In which case, it could have been that there was a change in the Google Sheets spreadsheet that caused it to trigger too many times all at once: Google Sheets: triggers unexpectedly or too soon. If you try replaying some of the errored actions now, do they go through successfully or do they get the same error?

Looking forward to hearing from you on this!


Troy Tessalone
Forum|alt.badge.img+14

Hi ​@orangeh6611 

Try these Zap steps:

  1. Trigger: Schedule - Daily
    1. Set your desired time
    2. Help: https://zapier.com/apps/schedule/help
  2. Action: Formatter > Date & Time > Format
    1. Used to get the current date in the desired format that matches the GSheet column value
    2. Help: https://zapier.com/apps/formatter/help
  3. Action: GSheets - Lookup Rows
    1. Search by the column that has the dates
  4. Action: Filter
    1. Check if there are results returned to process
    2. Help: https://zapier.com/apps/filter/help
  5. Action: Looping - Create Loop from Line Items
    1. Iterate thru each
    2. Help: https://zapier.com/apps/looping/help
  6. Action: Slack - Find User by Name
  7. Action: Slack - Add Reminder

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7304 replies
  • January 29, 2025

Hey there, ​@orangeh6611!

Just following up to ask how you’re getting on with this—were you able to get to the bottom of what caused the Zap to run into those rate limiting errors? And did using the set up Troy suggested help you get rid of the errors?

Keen to ensure you’re all set so please let us know whether you need any further help here! 🙂