Hello,
I am sure this is easy but I cannot figure it out. Based on the following setup where the data has not been dumped into a Google sheet, I now want it to start generating the next step IF the value in column H = Yes. I believe this would be a filter between the two modules but I can’t figure out how to set it up—attaching a screenshot. For clarity, I am looking for How to Trigger the next step AFTER the data is put into the Google sheet and has a Yes value in column H. So I want to begin creating the post, social media post, etc after the information has been added to the google sheet. many Thanks for the support.
blueprint (2).json (273.9 KB)
HI @Kali_Runk
To initiate a scenario based on Google sheet cell change, you can use the module “Watch Changes” in a new scenario.
For more details, refer to the below link:
https://www.make.com/en/help/app/google-sheets#watch-changes-964718
Between, ensure that you apply relevant filter (Check for Yes) after the trigger module.
Regards,
Msquare Automation - Gold Partner of Make
Book a Free Consultation | Connect Live
Explore our YouTube Channel for valuable insights and updates!
I’m sorry to ask what may seem like a dumb question but I am new to make.com. are you saying that in order to accomplish what I was asking, I need to start a new separate scenario? I was hoping to keep it all one fluid scenario. Additionally, how do I set the filter to check for yes?
Hi @Kali_Runk
I see that you have hardcoded the value of column “H” in google sheet. In that case you do not need to add filter as always the value is “yes”.
However, if you will dynamically map this value from any previous module
, then you can map the same variable in filter “equal to” “yes”.
The other way is “get range values” module.
Please download the below attached blueprint and you will be able to set the filter.
blueprint (26).json (295.2 KB)
Regards,
Msquare Automation - Gold Partner of Make
Book a Free Consultation | Connect Live
Explore our YouTube Channel for valuable insights and updates!