Dear Community,
I would like to create a Task in Asana when a cell value in a google sheet goes below 80%.
I assume I need to use webhooks, but I am having trouble finding the right way to do it.
Any suggestions would be greatly appreciated.
Thank you!
Best answer by SamBBest answer by SamB
Just wanted to follow up here for anyone to also suggest the use of a Filter by Zapier step.
Troy is totally right on the suggestion of using the Google Sheets New or Updated Spreadsheet Row trigger. It has the ability to allow the Zap to fire on a changes to cell values in a specific Column. And if you couple that with a Filter, it would be possible to check whether a percentage value drops below 80%.
For example, with the Filter setup shown below, a value of 75% in my Google Sheet’s “Percentage” column would pass the Filter:
But a value of 85% would not pass the Filter:
Then you’d follow that up with whatever actions you’re looking to carry out, like a Create Task Asana action. This would result in tasks only being added to Asana when the percentage value drops below 80%.
You can read more about how to add Filters to your Zaps here: Add conditions to Zaps with filters
One thing to note here is that with the New or Updated Spreadsheet Row trigger the updates would need to be unique in order for the Zap to see them. You can find our more about that here: The "Updated Spreadsheet Row" trigger stopped triggering
+10
Just checking in to see if you still need help with this?
+11Just wanted to follow up here for anyone to also suggest the use of a Filter by Zapier step.
Troy is totally right on the suggestion of using the Google Sheets New or Updated Spreadsheet Row trigger. It has the ability to allow the Zap to fire on a changes to cell values in a specific Column. And if you couple that with a Filter, it would be possible to check whether a percentage value drops below 80%.
For example, with the Filter setup shown below, a value of 75% in my Google Sheet’s “Percentage” column would pass the Filter:
But a value of 85% would not pass the Filter:
Then you’d follow that up with whatever actions you’re looking to carry out, like a Create Task Asana action. This would result in tasks only being added to Asana when the percentage value drops below 80%.
You can read more about how to add Filters to your Zaps here: Add conditions to Zaps with filters
One thing to note here is that with the New or Updated Spreadsheet Row trigger the updates would need to be unique in order for the Zap to see them. You can find our more about that here: The "Updated Spreadsheet Row" trigger stopped triggering
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
