Hi community,
I wanted to build a Zap wich sends a message in our slack channel, whenever there is a change in the worksheet. Unfortunately it doesn’t work automatically. If theres a change i have to “run” the Zap. After i ran it, it works perfektly and sends the message to the slack channel.
So how can i automate it?
Looking forward to you’re knowledge and answers :)
greetings
Lorenz
Best answer
How do I automate sending a Slack message when a Google Sheets worksheet is updated?
Best answer by Troy Tessalone
Hi
Good question.
The Google Sheets trigger is marked "instant" but it still takes a few minutes to trigger
The triggers for Google Sheets are unique among Zapier triggers. When there is a trigger event in the spreadsheet, Zapier gets a notification webhook from Google about this. After that, Zapier sends Google Sheets a request for new data, so it uses both the polling and instant trigger methods. This process takes about 3 minutes overall.
While not being "instant", these triggers are faster than regular polling ones, as they don't depend on the polling interval of the plan your account uses.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.