How do i trigger when specific cell of Google sheet is changed

[tisaigon]

Hi,
In Youtube link:

: Trigger When a Column Value is Updated
How trigger when only specific cell (eg: A1) updated and equal = APPROVED?
Thank you

 

[Arshita]

Hey @tisaigon

You can use the Filter action step once in your workflow after the trigger event which will only process the workflow when it gets the desired value "Approved" in the respective column.

Also, make sure in the same spreadsheet that column should be your existing Trigger column then only workflow will get triggered.

For example, if you have 3 columns A, B & C and you want to make changes in column C and then trigger the workflow then only it will work.