How do I stop an automation if the cell targeted with Sheets Get A Cell is empty?

How To
1

Dear Make community, I hope someone can help me.

I have an automation that:

  1. Google Sheets > Get a Cell (at a specific day and time)
  2. AI module
  3. AI module
  4. Post to Facebook

What I would like is for the automation to stop if the cell checked in step 1 is empty. Is this possible? Right now, even if the cell is empty, the other three steps are worked through. Resulting in unwanted outputs.

Thank you for your time, take care and have an excellent day.

2

Hey @Dweeb80,
Right after the trigger you have to add a filter where you can check if the field is empty. You can use the length() formula and the condition not equal to 0.

3

Hi DimitrisGoudis, thank you for the response. It is very much appreciated. I used the Exist operator function instead of length and it seems to be working great. Again, thank you for the help. Take care and have an excellent day.

1 Like