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.”